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 AALA202510292804Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY-D DOOR LOCK IS VERY DIFFICULT TO OPERATE. LUBED LEFT AFT LAVATORY DOOR. OPERATIONAL CHECKED GOOD.SDR AALA202601146352Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER TEE AT OTBD LAVATORY MOUNT, LOCATED AT BS 947.5, AT RBL 54. REPAIRED TEE IAW SRM 53-70-51-2R-5.SDR AALA202511035044Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB AT STABILIZER BL 281.81. REPLACED RIB PER AARD 51-00-05-1.SDR AALA202510306793Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: WHILE ACCOMPLISHING W/C 08T20033001, FOUND L2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMPED LIGHT. PER AMM 33-51-04. OPERATIONAL CHECK GOOD.SDR AALA202510291253Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: CEILING EMERGENCY EXIT SIGN AT EMERGENCY EXIT ROW, FELL DOWN DURING TAKEOFF AND IS HANGING BY THE WIRE. TIGHTENED AND SECURED EMERGENCY EXIT LIGHT ASSEMBLY AT CEILING PANEL ROW 17ABC. OPERTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202510294147Heat Shrink · missingAIRCRAFT WAS GROUNDED: DUE TO SLIDE REPLACEMENT AT R1 DOOR, GIRT BAR REQUIRES RED HEATSHRINK TUBING. REPLACED GIRT BAR HEAT SHRINK. PER AARD 25-66-00SDR AALA202510292218Slide · unwanted deployAIRCRAFT WAS GROUNDED: FORWARD SERVICE DOOR EVACUATION SLIDE PARTIALLY DEPLOYED FROM HOUSING. REMOVED AND REPLACED R1 DOOR SLIDE. PER WORK CARD 08L22125001.SDR AALA202510291620Guide Arm · out of adjustAIRCRAFT WAS GROUNDED: L1 DOOR HARD TO OPEN. ADJUSTED THE GUIDE ARM BUT NO HELP. DOOR STILL HARD TO OPEN AND CLOSE. REMOVE AND REPLACED MAIN ENTRY DOOR GUIDE ARM. PER AMM 52-11-21.SDR AALA202601157498Shield · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON AFT CARGO COMPARTMENT SHIELD ASSEMBLY LOCATED FROM BS 767 TO BS 793 AT S25R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202510302433Door · out of adjustAIRCRAFT WAS GROUNDED: GATE AGENT SAYS MAIN CABIN DOOR IS DIFFICULT TO OPEN. READJUSTED L1 DOOR. PER 52-11-21-400-802.SDR AALA202510304348Engine · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 2 ENGINE SHUT DOWN IN FLIGHT DUE TO LOSS OF OIL QUANTITY THEN LOSS OF OIL PRESSURE. AIRCRAFT EMERGENCY LANDED SAFELY AT CLT. REMOVED AND REPLACED NUMBER 2 ENGINE. PER J/C 08L40072003. ALL OPERATIOSDR AALA202510306318Elec Connector · damagedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ALL LAVATORIES NOT FUNCTIONING AT ALL, PASSENGER WASTE BUILD UP IN TOILET POSSIBLE OVERFLOW. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT PHX. LAVATORY CONNECTOR FOUND DAMAGED. REMOVE AND REPLACED CONNECTORSDR AALA202510274554Elec Connector · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT AISLE INDICATION INOPERATIVE AT ROWS 18ABC THROUGH ROW 25ABC. REMOVE AND REPLACED CONNECTOR AT SEAT 18ABC. PER SWPM 20-61-28. SYSTEM OPERATIONAL CHECK GOOD.SDR AALA202510277243Sign · missingAIRCRAFT WAS NOT GROUNDED: ROW 17F EMERGENCY LIGHT AT SIDEWALL, SIGN IS MISSING. REPLACED RIGHT HAND AFT EMERGENCY EXIT BOTTOM SIGN LIGHT AT SIDE WALL IAWAMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA202510276246Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FRONT LAVATORY DOOR IS HARD TO OPEN AND CLOSE FOR PASSENGER. ADJUSTED AND TIGHTENED DOOR HANDLE ASSEMBLY AND LAVATORY DOOR. OPERATIONAL CHECKS NORMAL. PER CMM 25-44-49.SDR AALA202510274961Bolt · looseAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR GUST LOCK BOLT IS LOOSE, POSSIBLE SAFETY WIRE MISSING. INSTALLED KEYWASHER AND SCREW FOR GUIDE ARM. PER AMM 52-11-21. OPERATIONAL CHECK GOOD.SDR AALA202510270663Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR CLIP LOOSE. ADJUSTED GIRT BAR CLIP FOR FORWARD SERVICE DOOR. PER AMM 25-66-01.SDR AALA202510272433Door · stiffAIRCRAFT WAS GROUNDED: GATE AGENT SAYS MAIN CABIN DOOR IS DIFFICULT TO OPEN. (OPEN).SDR AALA202601154238Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER TEE FITTING AT BS 986.5, RBL 43. REPAIRED UPPER TEE FITTING IAW SRM 53-70-51-2R-4.SDR AALA202601149757Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO SEAL SUPPORT INTERCOSTAL ON AFT PRESSURE BULKHEAD AT BS 1016, FROM LBL 8 TO LBL 30. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202510308671Windshield · arcedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER ENTERING IMC AT FL280 ARCING BEGAN EMANATING FROM FO R1 WINDSHIELD, CONTINUED AND WORSENED WITH CONTINUED FLIGHT IN IMC. FLIGHT CREW COULD PHYSICALLY FEEL BUILD UP OF STATIC ELECTRICITY. AIRCRAFT DSDR AALA202510278954Fuel Filter · cloggedAIRCRAFT WAS NOT GROUNDED: NUMBER 1 FUEL FILTER BYPASS LIGHT ILLUMINATED SHORTLY AFTER TAKEOFF. REMOVE AND REPLACED THE NUMBER 1 ENGINE FUEL FILTER. PER AMM 73-11-02. OPS & LEAK CHECK GOOD.SDR AALA202510272092Locking Cam · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS ARE EXPERIENCING TROUBLE REMOVING THE GIRT BAR FROM ITS BRACKETS ON THE 1R DOOR. CLEANED AND LUBRICATED R1 SLIDE GIRT BAR RETAINER CLIPS. PER AMM25-66-00.SDR AALA202510273827Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LOCK IS DIFFICULT TO SLIDE AND PRONE TO GETTING STUCK. ADJUSTED AND LUBRICATED LEFT AFT LAVATORY DOOR AND LOCK MECHANISM. PER AAMM 25-40-00. OPERATIONAL CHECK GOOD.SDR AALA202510278370Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: GIRT BAR HOOKS NEED ADJUSTED, TOO TIGHT TO ARM AND DISARM. CLEANED AND LUBRICATED GIRT BAR FITTINGS ON ALL DOORS. OPERATIONAL CHECK GOOD.SDR AALA202601159210Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER TEE FITTING AT BS 986.5, LBL 29. REPAIRED UPPER TEE FITTING IAW SRM 53-70-51-2R-4.SDR AALA202601153686Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER TEE FITTING AT BS 986, LBL 43. REPAIRED UPPER TEE FITTING IAW SRM 53-70-51-2R-4.SDR AALA202601152252Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER TEE FITTING AT BS 986.5, RBL 29. REPAIRED UPPER TEE FITTING IAW SRM 53-70-51-2R-4.SDR AALA202601154040Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER TEE FITTING AT STA 986, RBL 33. REPAIRED UPPER TEE FITTING PER SRM 53-70-51-2R-4.SDR AALA202601158169Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER TEE FITTING AT BS 986.5, RBL 38. REPAIRED UPPER TEE FITTING PER SRM 53-70-51-2R-4.SDR AALA202510302013Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTNING ELECTRICAL CONNECTOR IN SEAT 2AB BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING CONNECTOR. PER SWPM 20-61-28.SDR AALA202510308702Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTNING ELECTRICAL CONNECTOR IN SEAT 4AB BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING CONNECTOR. PER SWPM 20-61-28.SDR AALA202510303846Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: BOTH EMERGENCY LIGHTING ELECTRICAL CONNECTOR UNDER SEAT 19ABC FOUND BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT CONNECTOR. PER SWPM 20-61-28.SDR AALA202510301725Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING ELECTRICAL CONNECTOR UNDER SEAT 25ABC FOUND BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT CONNECTOR. PER SWPM 20-61-28.SDR AALA202510303655Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTNING ELECTRICAL CONNECTOR IN SEATS 12ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT CONNECTOR. PER SWPM 20-61-28.SDR AALA202510305742Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING ELECTRICAL CONNECTOR UNDER SEAT 26ABC FOUND BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT CONNECTOR. PER SWPM 20-61-28.SDR AALA202510302915Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: BOTH EMERGENCY LIGHTING CONNECTORS UNDER SEATS 18ABC FOUND TO BE DAMAGED AND CRACKED. REMOVED AND REPLACED EMERGENCY LIGHTING CONNECTOR. PER SWPM 20-61-28.SDR AALA202510306337Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTNING ELECTRICAL CONNECTOR IN SEATS 11ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING CONNECTOR. PER SWPM 20-61-28.SDR AALA202510305320Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTNING ELECTRICAL CONNECTOR IN SEAT 8ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING CONNECTOR. PER SWPM 20-61-28.SDR AALA202510307884Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING CONNECTOR UNDER SEATS 21ABC FOUND TO BE DAMAGED AND CRACKED. REMOVED AND REPLACED EMERGENCY LIGHTING CONNECTOR. PER SWPM 20-61-28.SDR AALA202510308606Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTNING ELECTRICAL CONNECTOR AT SEATS 17ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTNING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202510301562Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: RED EMERGENCY LIGHTING CONNECTOR BENEATH PASSENGER SEAT 13CBA IS BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTNING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202510303149Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR STUCK HALF OPEN AGAIN. AFT LEFT LAVATORY DOOR IS OFF ITS TRACK AND INOPERATIVE, THE TRACK IS BENT. FOUND DOOR OUT OF TRACK, READJUSTED DOOR AND PERFORMED OPERATIONAL TEST. PER AMM 25-40-15. OPERATIONAL CHECK GOOD.SDR AALA202510300382Indication Sys · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NO DECLARED DUE TO: HYDRAULIC SYSTEM-A DECREASED DURING FLIGHT. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MIA. ACCOMPLISHED GVI OF AIRCRAFT FLIGHT SURFACES FOR LEAKS AND OPERATIONAL CHECKS, NO LEAKS NOTED. PERFORMED OPERSDR AALA202510273149Door · off trackAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR STUCK HALF OPEN AGAIN. AFT LEFT LAVATORY DOOR IS OFF ITS TRACK AND INOPERATIVE, THE TRACK IS BENT. (OPEN).SDR AALA202510276786Door · off trackAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR OFF RAIL AND STUCK. REINSTALLED AFTER LEFT DOOR ON RAIL. OPERATIONAL CHECKED GOOD.SDR AALA202510270012Light · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY PATH LIGHTING MODULE AT SEAT 20C DISLODGED AND ON FLOOR. REPLACED EMERGENCY LIGHT ASSEMBLY AT 20C. PER AMM 33-51-11.SDR AALA202510276823Light · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT AT SEAT 26C FELL OFF. REINSTALLED EMERGENCY EXIT LIGHT AT 26C. OPERATIONAL CHECK GOOD. PER AMM 33-51-00.SDR AALA202601146926Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL AT BS 927, LBL 25. REPLACED INTERCOSTAL IAW AARD 51-00-05-1.SDR AALA202601149864Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED AT BS 500, S16R. REPLACED TRANSITION PANEL IAW AARD 51-00-05-1.
Back to Boeing 737-823