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 AALA202505202530Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CAP) AT STA 947.5, LBL 51. REPAIRED CHORD PER SRM 53-70-51-2R -5.SDR AALA202505200857Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 950, LBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202505209943Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 950, LBL 25. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202505204236Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT AT BS 951, LBL 17. REPLACED SUPPORT PER AARD 51-00-01-5.SDR AALA202505201462Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 950, LBL 26. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202505205990Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 947.5 TO BS 967 AT LBL 52. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202505121142Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM AT BS 986, LBL 44. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6.SDR AALA202505065469Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500 TO BS 500A AT S26R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202505011774Oil System · lowAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: OIL QUANTITY AND PRESSURE DROPPED BELOW 5 QUARTS; SHUTDOWN NUMBNER 1 ENGINE AS A PRECAUTION. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ATL. **SUPPLEMENTAL REPORT FOR (AALA202504281774): REMOVSDR AALA202504289375Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: REPEAT WRITE UP. AFTER LEFT LAVATORY DOOR STICKS WHEN LOCKED. LUBRICATED TOP AND BOTTOM LOCKING POSTS AND LOCKING LATCH ON LAVATORY DOOR. PER AMM 12-25-40.SDR AALA202504286889Door · unsecureAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY-D DOOR HARD TO OPEN. SECURED AFT LEFT HAND LAVATORY DOOR UPPER TRACK. OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202504281774Oil System · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: OIL QUANTITY AND PRESSURE DROPPED BELOW 5 QUARTS; SHUTDOWN NUMBNER 1 ENGINE AS A PRECAUTION. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ATL. (OPEN).SDR AALA202507316594Web · corrodedCORROSION IN SECTIONS 4 AND 7. AIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE WEB AT BS 989 AND RBL 33. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202505206594Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE WEB AT STA 986.5, FROM RBL 30 TO RBL 34. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202505206225Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE WEB AT STA 988, RBL 32. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202505201277Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR LOWER SILL INNER CHORD (CREASE ANGLE) AT BS 991, RBL 45. REPLACED CHORD PER AARD 51-00-05-1 AND EA 364702A.SDR AALA202505162768Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD FLANGE AT STA 947, RBL 43. REPAIRED CHORD PER SRM 53-70-51-2R PROCEDURE 6 ALTERNATIVE 4 AND EA 364364.SDR AALA202505066365Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT INTERCOSTAL FROM BS 847 TO BS 856, AT S25R. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202504302845Compensator · faultedAIRCRAFT WAS NOT GROUNDED: 2 HOURS INTO FLIGHT IN LEVEL CRUISE, LEFT MAIN FUEL QUANTITY BEGAN TO SHOW FUEL DECREASING AT APPROXIMATELY 100LBS/SECOND. AT APPROXIMATELY 1500LB IMBALANCE IT STOPPED AND STAYED AT A 1500LB IMBALANCE. TROUBLESHOT IAW TSM 28-41-00-81SDR AALA202504285132Blower Motor · shortedAIRCRAFT WAS GROUNDED: AFT OF AIRCRAFT HAS A BURNING SMELL THE SMELL IS STRONGEST AT ROW 31 AND AFT, THE SMELL IS LIKE AN ELECTRICAL BURNING SMELL. REMOVE AND REPLACED VACUMM BLOWER MOTOR, PER AMM 38-32-05. OPERTIONAL CHECK GOOD. CONFIRMED NO SMELL AT THIS TIMSDR AALA202504282845Indicator · shortedAIRCRAFT WAS NOT GROUNDED: 2 HOURS INTO FLIGHT IN LEVEL CRUISE, LEFT MAIN FUEL QUANTITY BEGAN TO SHOW FUEL DECREASING AT APPROXIMATELY 100LBS/SECOND. AT APPROXIMATELY 1500LB IMBALANCE IT STOPPED AND STAYED AT A 1500LB IMBALANCE. TROUBLESHOT IAW TSM 28-41-00-81SDR AALA202504280351Cam · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENTS REPORTS ENTRY DOOR 1L GIRT BAR HARD TO ENGAGE. LUBRICATED GIRT BAR RETAINER CLIPS TO 1L DOOR. OPERTIONAL CHECK GOOD. PER AMM 25-66-01.SDR AALA202504282699Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENTS REPORTED HARD TO OPEN AND CLOSE THE FORWARD LAVATORY DOOR. LUBRICATED DOOR HINGES AND ATTACHING HARDWARE. OPERTIONAL CHECK NORMAL. PER 25-40-00.SDR AALA202504280322Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS HARD TO OPEN AND CLOSE. SPRAYED LUB ON LAVATORY DOOR D LATCH AND TRACKS, OPERTIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202504283249Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFTER LEFT LAVATORY DOOR LOCK STICKS WHEN LOCKED. LUBRICATED AFT LEFT LAVATORY DOOR TRACK. PER AMM 24-40-14.SDR AALA202504286626Oil System · emptyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 1 ENGINE OIL QUANTITY DROPPED TO 0 IN FLIGHT; THEN OIL PRESSURE WENT TO 0; INFLIGHT SHUT DOWN COMPLETED. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MCO. REMOVED AND REPLACED LEFT ENGINE ASSEMBLYT, SDR AALA202505215968Support Bracket · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN KEEL BEAM SUPPORT BRACKET AT STA 549, LBL 6. REPLACED BRACKET PER SRM 51-40-02.SDR AALA202505201319Lug · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND HORIZONTAL STABILIZER REAR SPAR LOWER AFT LUG. REPAIRED PER SB 737-55-1074 AND EA 364454.SDR AALA202505204625Lug · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND HORIZONTAL STABILIZER REAR SPAR LOWER LUG. REPAIRED PER SB 737-55-1074 AND EA 364454.SDR AALA202505168936Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500B PLUS 12 INCHES AND BS 500I AT RBL 12. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202505163513Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500C AND BS 500I AT LBL 25. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202505090271Bracket · crackedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT BULKHEAD BRACKET ASSEMBLY AT BS 947 FROM S25L TO S25R. REPLACED BRACKET ASSEMBLY (SUPPORT RAIL) PER AARD 51-00-05-1.SDR AALA202505090941Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL AT BS, RBL 25. REPLACED INETERCOSTAL PER AARD 51-00-05-1.SDR AALA202505097825Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER T CHORD AROUND LAVATORY MOUNT AT BS 947, RBL 51. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R PROCEDURE 5.SDR AALA202505029353Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 946, RBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202504296958Duct · damagedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: CONTROL CABIN ZONE TEMPERATURE LIGHT ON RECALL, FLIGHT DECK TEMP UNCONTROLLABLE IT IS STUCKED AT FULL COLD 40 DEGREE SUPPLY DUCT TEMP READING. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. SDR AALA202504292401Module · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: CONTROL CABIN ZONE TEMPERATURE LIGHT ON RECALL, FLIGHT DECK TEMP UNCONTROLLABLE IT IS STUCKED AT FULL COLD 40 DEGREE SUPPLY DUCT TEMP READING. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. SDR AALA202504294417Sensor · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: CONTROL CABIN ZONE TEMPERATURE LIGHT ON RECALL, FLIGHT DECK TEMP UNCONTROLLABLE IT IS STUCKED AT FULL COLD 40 DEGREE SUPPLY DUCT TEMP READING. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. SDR AALA202504296089Sensor · bentAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: CONTROL CABIN ZONE TEMPERATURE LIGHT ON RECALL, FLIGHT DECK TEMP UNCONTROLLABLE IT IS STUCKED AT FULL COLD 40 DEGREE SUPPLY DUCT TEMP READING. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. SDR AALA202504296372Overheat Sensor · bentAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: CONTROL CABIN ZONE TEMPERATURE LIGHT ON RECALL, FLIGHT DECK TEMP UNCONTROLLABLE IT IS STUCKED AT FULL COLD 40 DEGREE SUPPLY DUCT TEMP READING. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. SDR AALA202504291122Air Filter · dirtyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: CONTROL CABIN ZONE TEMPERATURE LIGHT ON RECALL, FLIGHT DECK TEMP UNCONTROLLABLE IT IS STUCKED AT FULL COLD 40 DEGREE SUPPLY DUCT TEMP READING. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. SDR AALA202504255664Roll Pin · missingAIRCRAFT WAS NOT GROUNDED: GIRT BAR ON R1 DOOR HAS LOOSE SPACER ON AFT SIDE OF BAR. INSTALLED NEW ROLL PIN IN GIRT BAR SPACER. OPERTIONAL CHECK GOOD. PER AMM25-66-00.SDR AALA202504250052Mechanism · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD GIRT BAR RETENSION BRACKET AT DOOR R1 DOES NOT SECURE GIRT BAR. ADJUSTED GIRT BAR RETENTION BRACKET AT R1 DOOR. OPERTIONAL CHECKS GOOD.SDR AALA202504253292Liner · tornAIRCRAFT IN BASE MAINTENANCE: L2 SLIDE GIRT FABRIC TORN. REMOVED AND REPLACED SLIDE. PER AMM 25-66-01.SDR AALA202504257758Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE INOPERATIVE. REPLACED MEGAPHONE AND OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202504252273Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: GIRT BAR LOOSE ON FORWARD PASSENGER DOOR. REPOSITION FORWARD DOOR GIRT BAR HOLDER. PER AMM REF 54-20-00.SDR AALA202504251122Control Module · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: CONTROL CABIN ZONE TEMPERATURE LIGHT ON RECALL, FLIGHT DECK TEMP UNCONTROLLABLE IT IS STUCKED AT FULL COLD 40 DEGREE SUPPLY DUCT TEMP READING. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. SDR AALA202505092490Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: FORWARD RECESSED PANEL EMER LIGHT IS INOPERATIVE. REMOVED AND REPLACED FORWARD RECESSED PANEL EMERGENCY LIGHT BULB. PER B737-NG-AMM 33-51-03. PERFORMED SATISFACTORY OPERTIONAL CHECK OF FORWARD RECESSED PANEL EMERGENCY LIGHT. PER BSDR AALA202505066122Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL UPPER ANGLE FROM BS 380 TO BS 400, AT BL 0. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202505065491Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL UPPER ANGLE FROM BS 380 TO BS 400, AT RBL 10. REPLACED ANGLE PER AARD 51-00-05-1.
Back to Boeing 737-823