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 AALA202406182483Fan · odorAIRCRAFT WAS GROUNDED: ON DESCENT INTO CLT AT 5000FT STRONG ODOR THROUGH BLEED AIR IN FLIGHT DECK. ELECTRICAL TYPE SMELL AND FLIGHT ATTENDANTS REPORTED STRONG SIMILAR SMELL IN THE AFT GALLEY AT SAME ALTITUDE. SUBSIDED AFTER LANDING THEN AGAIN BUT MORE SUBTLE ASDR AALA202406188726Fan · odorAIRCRAFT WAS GROUNDED: ON DESCENT INTO CLT AT 5000FT STRONG ODOR THROUGH BLEED AIR IN FLIGHT DECK. ELECTRICAL TYPE SMELL AND FLIGHT ATTENDANTS REPORTED STRONG SIMILAR SMELL IN THE AFT GALLEY AT SAME ALTITUDE. SUBSIDED AFTER LANDING THEN AGAIN BUT MORE SUBTLE ASDR AALA202406184789Air Filter · odorAIRCRAFT WAS GROUNDED: ON DESCENT INTO CLT AT 5000FT STRONG ODOR THROUGH BLEED AIR IN FLIGHT DECK. ELECTRICAL TYPE SMELL AND FLIGHT ATTENDANTS REPORTED STRONG SIMILAR SMELL IN THE AFT GALLEY AT SAME ALTITUDE. SUBSIDED AFTER LANDING THEN AGAIN BUT MORE SUBTLE ASDR AALA202406189260Air Filter · odorAIRCRAFT WAS GROUNDED: ON DESCENT INTO CLT AT 5000FT STRONG ODOR THROUGH BLEED AIR IN FLIGHT DECK. ELECTRICAL TYPE SMELL AND FLIGHT ATTENDANTS REPORTED STRONG SIMILAR SMELL IN THE AFT GALLEY AT SAME ALTITUDE. SUBSIDED AFTER LANDING THEN AGAIN BUT MORE SUBTLE ASDR AALA202406281821Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD OF FLOOR BEAM AT STA 986.5, LBL 44. REPAIRED CHORD PER SRM 53-70-51-2R-8. **SUPPLEMENTAL REPORT FOR AALA202406271821: QC REVIEWED THIS EVENT AND DETERMINED THAT IT WAS A LEVEL 2 FINDING. SECTION 7 CORROSIOSDR AALA202406271821Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD OF FLOOR BEAM AT STA 986.5, LBL 44. REPAIRED CHORD PER SRM 53-70-51-2R-8.SDR AALA202406253707Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500D TO STA 500E, RBL 21. ACCOMPLISHED SPLICE REPAIR PER SRM 53-00-53-2R-5.SDR AALA202406258462Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500C TO STA 500D, S25L. ACCOMPLISHED SPLICE REPAIR PER SRM 53-00-53-2R-5.SDR AALA202406256496Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500A TO STA 500I, S25R. ACCOMPLISHED SPLICE REPAIR PER SRM 53-00-53-2R-5.SDR AALA202406258140Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500C TO STA 500D, RBL 25. ACCOMPLISHED SPLICE REPAIR PER SRM 53-00-53-2R-5.SDR AALA202406256693Support · corrodedAIRCARFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT BULKHEAD SUPPORT ASSEMBLY AT STA 500I, LBL 23. REPLACED SUPPORT ASSEMBLY PER AARD 51-00-05-1.SDR AALA202406251482Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE; CORROSION ON UPPER CHORD OF FLOORBEAM AT STA 986.5, RBL 44. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-8..SDR AALA202406210555Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTING DETACHED DURING LANDING FOR FROWARD ENTRY DOOR R1. ADJUSTED CLIP OF R1 DOOR EMERGENCY LIGHT LENS. PER AMM 33-25-00**(CLOSED).SDR AALA202406183887Gasket · leakingAIRCRAFT WAS GROUNDED:RETURN TO GATE, ON TAXI-OUT ANOTHER AIRCRAFT REPORTED LIQUID STREAMING FROM RIGHT ENGINE. CABIN FILLED WITH ODOR OF FUEL AND WE SECURED THE RIGHT ENGINE AS A PRECAUTION. REMOVED AND REPALCED THE GASKET FUEL OUT TUBE FROM OIL COOLER RIGHT SDR AALA202406180555Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTING DETACHED DURING LANDING FOR FROWARD ENTRY DOOR R1. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202406182179Light · unsecureAIRCRAFT WAS NOT GROUNDED: ROW 13ABC SEAT EMERGENCY LIGHTING MODULE LOOSE. RESECURED EMERGENCY LIGHT MODULE ASSEMBLY AT ROW 13ABC. PER AMM 33-51-11.SDR AALA202406187735Battery · no testAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTANDENT JUMPSEAT FLASH LIGHT DOES NOT TURN ON. REMOVED AND REPLACED OUTBOARD FORWARD ATTENDANT HANDHELD FLASHLIGHT BATTERY. PER AMM 25-64-00.SDR AALA202406178823Skin · noneAIRCRAFT IN BASE MAINTENANCE: CREATED ACCESS CUT OUT IN SKIN AT RIGHT HAND HORIZONTAL STABILIZER STA 92.70 TO FACILITATE RIB STIFFENER #3 REPAIR (RIB REPLACED. SEE AALA202406175882). REPAIRED CUT OUT BY INSTALLING DOUBLER REPAIR PER SRM 55-10-01-2R PROCEDURE 1SDR AALA202406275094Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED GIRT BAR AFT TIEDOWN FITTING AT BS 344, LBL 60. REPLACED TIEDOWN PER AARD 51-00-05-1 AND SRM 51-40-01-0G.SDR AALA202406184140Girt Bar · unsecureAIRCRAFT WAS NOT GROUNDED: 2L SLIDE ATTACHMENT FOR GIRT BAR ATTACHMENT IS LOOSE. SECURED GIRT BAR. PER AMM 25-64-00.SDR AALA202406181727Connector · damagedAIRCRAFT WAS NOT GROUNDED: DURING CRUISE, HYDRAULIC SYSTEM-A ELECTRICAL 2 OVERHEAT LIGHT ILLUMINATED CORRESPONDING WITH ELECTRICAL BURNING ODOR ASSOCIATED. FOUND CONNECTOR (D2664) ON EMDP"A" TO BE FAULTY AND DAMAGED. REMOVE AND REPLACED CONNECTOR. OPERTIONAL ASDR AALA202406183592Threshold · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STUCK ON THRESHOLD. TIGHTENED AND LUBRICATED FORWARD LAVATORY THRESHOLD. OPERTIONAL CHECKED NORMAL.SDR AALA202406188735Flashlight · not seatedAIRCRAFT IN BASE MAINTENANCE: BOTH FLASHLIGHTS AT FORWARD FLIGHT ATTANDENT STATION WILL NOT TEST. CORRECTLY SEATED FORWARD FLIGHT ATTANDENT STATION FLASHLIGHTS TO FIX TEST FUNCTION. PER AMM 25-64-00.SDR AALA202406182064Megaphone · no testAIRCRAFT WAS GROUNDED: FLIGHT ATTANDENT REPORTS AFT MEGAPHONE INOPERATIVE WILL NOT TEST. REMOVED AND REPLACED MEGAPHONE , OPERTIONAL CHECKED GOOD. PER AMM 25-64-00.SDR AALA202406186525Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH LIGHTING HAS BECOME UNSECURED FROM SEAT 22C. REPLACED EMERGENCY ESCAPE LIGHT. PER AMM 33-51-11.SDR AALA202406188010Housing · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT PATH LIGHTING SEATS 30C AND 31C IS DANGLING BY WIRES IN THE AISLE. REMOVE AND REPLACED EMERGENCY LIGHT HOUSING AT 30C. PER AMM 25-22-00.SDR AALA202406185787Housing · looseAIRCRAFT WAS NOT GROUNDED: 31C EMERGENCY LIGHT PANEL LOOSE. REMOVE AND REPLACED EMERGENCY LIGHT HOUSING AT 31C. PER AMM 25-22-00.SDR AALA202406189235Tire · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 2 TIRE BLOWN ON DEPARTURE; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT CLT. REMOVED AND REPLACED NUMBER 2 WHEEL ASSEMBLY. PER AMM 32-45-11.SDR AALA202407018421Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CENTER WING BOX LEFT SIDE SKIN. REPAIRED SKIN PER EA 355468.SDR AALA202406254932Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 767 TO STA 727I, S25R. ACCOMPLISHED SPLICE REPAIR PER SRM 53-00-53-2R-5.SDR AALA202406259476Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727I PLUS 5 INCHES TO STA 727I PLUS 10 INCHES, S25L. ACCOMPLISHED SPLICE REPAIR PER SRM 53-00-53-2R-5.SDR AALA202406251372Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE SHIELD BETWEEN STA 767 AND STA 794.37, S25R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202406253484Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN STA 727 AND STA 727D, S25L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202406194155Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB AT STABILIZER STATION 192.50. REPLACED RIB PER AARD 55-00-05-01.SDR AALA202406193389Slide · unwanted deployAIRCRAFT WAS GROUNDED: THE FLIGHT ATTENDANT FORGOT TO DISARM THE R1 SERVICE DOOR AND THE SLIDE PARTIALLY DEPLOYED. REMOVED AND REPLACED DOOR 1 RIGHT SLIDE ASSEMBLY PER J/C 09L20025004**(CLOSED).SDR AALA202406140885Sign · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN DANGLING FROM CEILING ABEAM ROW 17. REINSTALLED EXIT SIGN. OPERTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202406144024Spacer · missingAIRCRAFT WAS NOT GROUNDED: GIRT BAR WHITE SPACER MISSING AT DOOR 1R. INSTALLED GIRT BAR WHITE SPACER. PER MM 25-66-01.SDR AALA202406148555Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND LOCK. LUBRICATED DOOR HINGEDOOR OPERATES NORMALY.SDR AALA202406145708Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT LIGHT SIGN CAME OFF IN FLIGHT AT RIGHT SIDE EMERGENCY EXIT. REMOVE AND REPLACED LIGHT ASSEMBLY. OPERTIONAL CHECK NORMAL. PER AMM 33-51-01.SDR AALA202406143389Slide · crew errorAIRCRAFT WAS GROUNDED: THE FLIGHT ATTENDANT FORGOT TO DISARM THE R1 SERVICE DOOR AND THE SLIDE PARTIALLY DEPLOYED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202406137867Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER AT STA 663.70 FROM LBL 24.92 TO LBL 31.83. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9 AND SRM 57-10-10-2R-2 PARAGRAPH 6.SDR AALA202406131418Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER AT STA 663.75 FROM LBL 31.83 TO LBL 40.00. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9 AND SRM 57-10-10-2R-2 PARAGRAPH 6.SDR AALA202406191908Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB STIFFENER. SECOND STIFFENER FROM FRONT SPAR AT STABILIZER STA 92.70. REPLACED RIB PER AARD 55-00-05-01.SDR AALA202406192302Pressure Switch · inoperativeAIRCRAFT WAS NOT GROUNDED: ON CLIMB OUT WITH FUEL IN ALL TANKS, CROSSFEED CLOSED, ALL PUMPS ON, LEFT WING TANK BURNED TO 1200LB IMBALANCE WITHIN 10 MINUTES. REMOVED AND REPLACED CENTER BOOST PUMP PRESSURE SWITCH. OPERTIONAL CHECK GOOD. PER AMM 28-42-11.SDR AALA202406142302Fuel Sys · unbalancedAIRCRAFT WAS NOT GROUNDED: ON CLIMB OUT WITH FUEL IN ALL TANKS, CROSSFEED CLOSED, ALL PUMPS ON, LEFT WING TANK BURNED TO 1200LB IMBALANCE WITHIN 10 MINUTES. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202406146287Door · out of adjustAIRCRAFT WAS GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. REINSTALLED AND ADJUSTED LAVATORY-D DOOR. OPERTYIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202406146203Oven · smokeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: SMOKE HOT SMELL CLIMBING THROUGH 32000. SMELL IN FLIGHT DECK AND FIRST CLASS; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT AUS. FOUND BOTH FORWARD GALLEY OVENS PRODUCING ODORS WHILE OPERATING. REMOVE AND RESDR AALA202406148779Oven · smokeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: SMOKE HOT SMELL CLIMBING THROUGH 32000. SMELL IN FLIGHT DECK AND FIRST CLASS; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT AUS. FOUND BOTH FORWARD GALLEY OVENS PRODUCING ODORS WHILE OPERATING. REMOVE AND RESDR AALA202406146552Pressure Switch · out of toleranceAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB THROUGH 15000 FEET ALARM FOR CABIN PRESSURE WENT OFF CONTINUOUSLY; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT LAS. ACCOMPLISHED CABIN ALTITUDE WARNING SWITCHES TEST FOR S128 AND SSDR AALA202406149780Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 9 INCHES AFT OF FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.
Back to Boeing 737-823