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 AALA202407173608Transition Panel · corrodedAIRCRAFT IN MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT STA 500C PLUS 16 INCHES, RBL 35. REPLACED TRANSITION PANEL PER AARD 53-00-05-1.SDR AALA202407179739Transition Panel · corrodedAIRCRAFT IN MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT STA 500E PLUS 8 INCHES, RBL 36. REPLACED TRANSITION PANEL PER AARD 53-00-05-1.SDR AALA202407175740Transition Panel · corrodedAIRCRAFT IN MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT STA 500D PLUS 3 INCHES, RBL 36. REPLACED TRANSITION PANEL PER AARD 53-00-05-1.SDR AALA202407080646Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION SHIELD FROM STA 767 TO STA 793, S23R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202407085064Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT BREAK ASSEMBLY AT STA 540 FROM BL 0 TO RBL 20. REPLACED BREAK ASSEMBLY PER AARD 51-00-05.SDR AALA202407080886Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT BREAK ASSEMBLY AT STA 540 FROM BL 0 TO LBL 20. REPLACED BREAK ASSEMBLY PER AARD 51-00-05.SDR AALA202407010467Door Sill · unsecureAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR DIFFICULT TO OPEN WHILE IN FLIGHT. TIGHTENED BOLTS FOR SILL PLATE AND DOOR. OPERTIONAL CHECK GOOD. PER TO AMM 25-40-11.SDR AALA202407011710Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD RIGHT GALLEY DOOR GIRT BAR HARD TO OPERATE. REQUIRES LUBE AND ADJUSTMENT. ADJUSTED ATTACH FITTING AS NEEDED.SDR AALA202407012392Trim Panel · unsecureAIRCRAFT WAS NOT GROUNDED: L1 LAVATORY ENTRY DOOR DIFFICULTTO OPEN AND CLOSE. RESECURED FORWARD LAVATORY DOOR TRIM, DOOR OPERATES NORMAL. PER CMM 25-44-49.SDR AALA202407015007Gust Lock · inoperativeAIRCRAFT WAS NOT GROUNDED: L1 DOOR GUST LOCK INOPERATIVE, WILL NOT STAY LOCKED OPEN. L1 DOOR GUST LOCK GUIDE ARM REPLACED. PER AMM 52-11-00.SDR AALA202407013555Air Filter · contaminatedAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANTS REPORT MUSTY OR DIRTY SOCK SMELL IN AFT CABINAND AFT GALLEY. FOUND HEPA FILTERS DIRTY AND CONTAMINATED. REMOVE AND REPLACED HEPA FILTERS. PER AMM 21-25-01. PERFOMRED PACK DECONTAMINATION PER AMM 21-00-01. NO FURTHER ODOSDR AALA202407010571Pitot Tube · fodAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AIRSPEED DISAGREE ANNUNCIATION AT ROTATE, DETERMINED CAPTAINS AIRSPEED WAS ERRONEOUS, SPLIT 10-20 KNOTS BETWEEN INDICATIONS; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT IAD. REMOVED AND INSTALLED NEW CAPTASDR AALA202407018175Element · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENGINE NUMBER 2 OVERHEAT AIRBORNE PASSING 13,000; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ELP. REPLACED DETECTOR ELEMENT M1757 (AALA202407018175), PER AMM 26-11-01. REPLACED CORE FIRE DETECSDR AALA202407013063Wire Harness · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENGINE NUMBER 2 OVERHEAT AIRBORNE PASSING 13,000; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ELP. REPLACED DETECTOR ELEMENT M1757 (AALA202407018175), PER AMM 26-11-01. REPLACED CORE FIRE DETECSDR AALA202407014953A/C Pack · warning messageAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENGINE NUMBER 2 OVERHEAT AIRBORNE PASSING 13,000; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ELP. REPLACED DETECTOR ELEMENT M1757 (AALA202407018175), PER AMM 26-11-01. REPLACED CORE FIRE DETECSDR AALA202407016340Overheat Sensor · faultedAIRCRAFT WAS GROUNDED, AN EMERGENCY WAS DECLARED DUE TO: ENGINE NUMBER 2 OVERHEAT AIRBORNE PASSING 13,000; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ELP. REPLACED DETECTOR ELEMENT M1757 (AALA202407018175), PER AMM 26-11-01. REPLACED CORE FIRE DETECSDR AALA202407013854Controller · faultedAIRCRAFT WAS GROUNDED, AN EMERGENCY WAS DECLARED DUE TO: RIGHT AFTER TAKE OFF AUTO FAIL ON CABAIN PRESSURE CONTROLLER IN BOTH AUTO AND ALTERNATE MODE; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. FOUND CB: F5 "AUTO 2" (FO P6-4 PANEL) PULLED AND SDR AALA202407178830Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD (T CAP) OF FLOOR BEAM AT STA 947, LBL 6. REPAIRED UPPER CHORD PER 53-70-51 REPAIR 5 ALTERNATIVE 2 AND EA 356105.SDR AALA202407053837Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR INTERCOSTAL FROM STA 344 TO STA 360, LBL 8. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202407039640Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR INTERCOSTAL BETWEEN STA 328 AND STA 312, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202407013941Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED FORWARD LAVATORY DOOR. PER AMM 25-40-00.SDR AALA202407018591Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR INTERCOSTAL BETWEEN STA 328 AND STA 344, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202406287455Tube · missingAIRCRAFT WAS NOT GROUNDED: DOOR 2L SLIDE GIRT BAR CLIP MISSING RED COLOR TIP. INSTALLED RED COLOR TIP ON 2L DOOR GIRT BAR. PER AMM 25-66-00.SDR AALA202406289124Light · detachedAIRCRAFT WAS NOT GROUNDED: DAMAGED EMERGENCY EXIT LIGHT ASSEMBLY 27C. REATTACHED EMERGENCY EXIT LIGHT ASSEMBLY SEAT 27C. PER AMM 25-22-00.SDR AALA202407084490Attach Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD ATTACH RAIL ASSEMBLY AT STA 500I FROM LBL 25 TO RBL 25. REPLACED RAIL ASSEMBLY PER AARD 51-00-05-1.SDR AALA202407088200Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 500 TO STA 500I, LBL 23. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202407031883Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD OF FLOOR BEAM AT STA 986, LBL 42. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202407039375Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT GALLEY SHEAR WEB AT STA 988, RBL 32. REPAIRED SHEAR WEB PER SRM 51-10-02-0G AND EA 355745.SDR AALA202407033515Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR INTERCOSTAL AT STA 957, RBL48. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202407014545Tube · missingAIRCRAFT WAS GROUNDED. CABIN DOOR L1 SHRINK WRAP GIRT BAR MISSING. INSTALLED NEW L1 GIRT BAR SHRINK WRAP. PER EO 2523J012.SDR AALA202407015366Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LAVATORY MOUNT FLOOR SUPPORT INTERCOSTAL AT STA 949, LBL 50. REPLACED INTERCOSTAL PER AARD 51-00-05-1SDR AALA202406277813Hinge · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HARD TO OPEN. SECURED DOOR HINGE, OPERTIONALCHECK GOOD. PER CMM 25-40-61.SDR AALA202406277390Flashlight · not seatedAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT UNDER NUMBER 1 FLIGHT ATTANDENT JUMP SEAT INOPERATIVE. RESEATED FLIGHT ATTANDENT L1 FLASHLIGHT, OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202406276505Girt Bar · unsecureAIRCRAFT WAS NOT GROUNDED: AFT SERVICE DOOR 2R GRIT BAR HANGING OUT SLIDE PACK COMING OUT OF BUSLE. RESTOWED R2 DOOR GIRT BAR. PER AMM 25-66-02.SDR AALA202406270786Fuel Filter · faultyAIRCRAFT WAS GROUNDED: AT APPROX 1500 FEET ON TAKEOFF, NUMBER 1 FILTER BYPASS LIGHT ILLUMINATED CREW REPORTS THAT THE BY-PASS WAS FUEL RELATEDED. REMOVED AND REPLACED NUMBER 1 ENGINE FUEL FILTER. PER AMM 73-11-02.SDR AALA202406274111Sliding Window · dislodgedAIRCRAFT WAS NOT GROUNDED: OPENED THE SLIDING WINDOW ON THE CAPTAINS SIDE AND THE WHOLE WINDOW FELL OUT ON MY LAP. COMPLETELY OFF OF THE TRACKS. REINSTALLED L2 WINDOW. FUNCATRIONAL CHECK GOOD. PER AMM 56-12-11.SDR AALA202406271365Slide · dislodgedAIRCRAFT WAS GROUNDED: L1 DOOR SLIDE FELL OUT OF CRADLE ON OPENING. L1 DOOR HALF OPEN WITH SLIDE BUNDLE RESTING ON JETBRIDGE AND AIRCRAFT ENTRYWAY. REPLACED L1 DOOR SLIDE. PER WORK CARD 08L2212501.SDR AALA202406274545Girt Bar · damagedAIRCRAFT WAS GROUNDED: CABIN DOOR L1 SHRINK WRAP GIRT BAR MISSING. OPENSDR AALA202407080594Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSOIN ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 767 TO STA 727, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202407038375Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL (ZEE ASSEMBLY) BETWEEN STA 727 AND STA 847, RBL 25. REPLACED PANEL PER AARD 51-00-05-1.SDR AALA202407030555Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN STA 500C AND STA 500I, RBL 21. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202407036659Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SURROUND STRUCTURE SHIELD FROM STA 500 TO STA 500A, RBL 25. REPLACED SHIELD PER SRM 53-30-15 AND AARD 51-00-05-1.SDR AALA202407033230Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION SHIELD FROM STA 787 TO STA 767, S23R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202407032018Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT STA 540, BETWEEN LBL 0 AND LBL 25. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05..SDR AALA202406273200Hinge · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR STICKS WHEN BEING OPENED OR CLOSED. ADJUSTED DOOR HINGE, OPERTIONAL CHECK GOOD. PER AMM 52-50-00.SDR AALA202406273827Pump · inoperativeAIRCRAFT WAS GROUNDED: LEFT SIDE FORWARD FUEL PUMP LOW PRESSURE LIGHT FLASH INTERMITTENTLY DURING FLIGHT, REMOVE AND REPLACED LEFT HAND FORWARD FUEL BOOST PUMP. PER AMM 28-22-41.SDR AALA202406273605Slide · dislodgedAIRCRAFT WAS GROUNDED: DURING OPENING OF 1L DOOR, COMPLETE SLIDE PACK FELL OUT OF DOORAND ONTO THE JETWAY. IT DID NOT INFLATE. REMOVED AND REPLACED L1 DOOR SLIDE ASSEMBLY. OPERTIONAL CHECK GOOD. PER J/C 08L22125001.SDR AALA202406271513Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT LIGHT ABOVE ROW 17ABC INOPERATIVE. FOUND DISCONNECTED ELECTRICAL CONNECTOR CONNECTED EMERGENCY LIGHT CONNECTOR PER WDM 33-51-13. PERFORMED OPERTIONAL CHECK PER AMM 33-51-00 OPERTIONAL CHECK NORMAL.SDR AALA202406279883Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: NUMBER 1 AND NUMBER 2 LEFT AFT FLIGHT ATTENDANT FLASHLIGHTS DO NOT TEST. INSTALLED 2 (AALA202406279883) (AALA202406275688) NEW SERVICEABLE ONES, PRESS TO CHECK OPERTIONAL CHECKED GOOD. PER AMM 25-64-00.SDR AALA202406275688Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: NUMBER 1 AND NUMBER 2 LEFT AFT FLIGHT ATTENDANT FLASHLIGHTS DO NOT TEST. INSTALLED 2 (AALA202406279883) (AALA202406275688) NEW SERVICEABLE ONES, PRESS TO CHECK OPERTIONAL CHECKED GOOD. PER AMM 25-64-00.
Back to Boeing 737-823