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 AALA202406143138Stiffener · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON VERTICAL STIFFENER ASSEMBLY AT STA 320, S23L. REPLACED STIFFENER PER AARD 51-00-05-1 AND EA 354578A.SDR AALA202406116206Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN STA 727G AND STA 727H. REPLACED TRANSITION PANEL (ZEE ASSEMBLY) PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA202406103068Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN STA 727C AND STA 727D, REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202406105142Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN STA 727B AND STA 727C, REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202406108910Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN STA 727F AND STA 727G, REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202406101019Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN STA 727D AND STA 727E, REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202406109264Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN STA 727E AND STA 727F, REPLACED TRANSITION PANEL PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA202406076241Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN STA 727J AND STA 747, REPLACED TRANSITION PANEL PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA202406078294Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN STA 747 AND STA 767, REPLACED TRANSITION PANEL PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA202406070672Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN STA 767 AND STA 787, REPLACED TRANSITION PANEL PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA202406070687Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL BETWEEN STA 727I AND STA 727J, REPLACED TRANSITION PANEL PER SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA202406066677Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: THREE STIFFENERS CRACKED IN RIGHT HAND HORIZONTAL STABILIZER RIB AT STA 92.70. REPLACED RIB PER AARD 51-00-05-1.SDR AALA202406056250Switch · out of adjustAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFT CARGO DOOR LIGHT ILLUMINATED ON MULITPLE OCCASION IT IS A REPEAT DISCREPANCY; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. **SUPPLEMENTAL REPORT FOR (AALA202406036250): CHECKED FOR POWESDR AALA202406036250Warning Light · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFT CARGO DOOR LIGHT ILLUMINATED ON MULITPLE OCCASION IT IS A REPEAT DISCREPANCY; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202406035208Module · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLIGHT CONTROL SYSTEM- A LOW PRESSUREMLIGHT ILLUMINATED; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. REMOVED AND REPLACED SYSTEM-A FLIGHT CONTROL HYDRAULIC MODULE. OPERTIONAL AND LEAK CHECSDR AALA202406039924Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: UNABLE TO OPEN COCKPIT DOOR. ATTEMPTED KEYPAD ENTRY, IT DOES NOT MAKE SOUND WARNING HORN OR UNLOCK DOOR. LUBED FLIGHT DECK DOOR STRIKER LATCH ASSEMBLY AND OPERTIONAL CHECK GOOD. PER AMM 52-51.SDR AALA202406033649Pressure Switch · inoperativeAIRCRAFT WAS GROUNDED: LEFT AFT FUEL PUMP DOES NOT SHOW OFF WHEN TURNED OFF. BULB IS WORKING AND PUMP TURNED OFF FOR FUEL BALANCING ENROUTE. REMOVED AND REPLACED LEFT HAND AFT BOOST PUMP PRESSURE SWITCH, OPERTIONAL CHECK GOOD. PER AMM 28-42-11-401.SDR AALA202406033977Tube · missingAIRCRAFT WAS NOT GROUNDED: R1 CABIN DOOR EMERGENCY SLIDE GIRT BAR MISSING RED HEAT SHRINK TUBING. INSTALLED RED HEAT SHRINK TUBING ON R1 EMERGENCY SLIDE GIRT BAR CABIN DOOR. PER AARD 25-66-00-4.SDR AALA202406061263Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 394, LBL 15. REPLACED INTERCOSTAL PER AARD 53-00-05-1.SDR AALA202406059540Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 344 TO STA 360, LBL 11. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202406048851Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND SIDE EMERGENCY LIGHTS EXTERIOR ON OVERWING MIDDLE POSITION INOPERATIVE.**SUPPLEMENTAL REPORT (AALA202405318851): REMOVE AND REPLACED RIGHT HAND BATTERY PACK (M01671). OPERTIONAL CHECK GOOD. PER AMM 33-51-06**(CLOSED).SDR AALA202406048641Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND SIDE EMERGENCY LIGHTS EXTERIOR ON OVERWING AFT POSITION INOPERATIVE. **SUPPLEMENTAL REPORT FOR (AALA202405318641): REMOVE AND REPLACED RIGHT HAND BATTERY PACK (M01671). OPERTIONAL CHECK GOOD. PER AMM 33-51-06**(CLOSED).SDR AALA202406033296Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 312 TO STA 328, RBL 31. REPLACED INTERCOSTAL PER AARD 51-00-05-1..SDR AALA202405318813Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL UPPER ANGLE AT STA 385.5, RBL 10. REPLACED ANGLE PER SRM 51-40-02 ND AARD 51-00-05-1.SDR AALA202405310732Sign · detachedAIRCRAFT WAS NOT GROUNDED: L1 DOOR EXIT SIGN HANGING DOWN. SECURED MID AISLE EMERGENCY EXIT SIGN. PER AMM 33-51-00.SDR AALA202405311997Light · out of positionAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ABOVE SEATS 18 AND 19DEF IS OUT OF PLACE. REINSTALLED OVERHEAD EMERGENCY LIGHT ASSEMBLY. PER AMM 33-51-03.SDR AALA202405313443Fan · shortedAIRCRAFT WAS GROUNDED: VERY STRONG BURNING ODOR DURING ENGINE STAR IN THE COCKPIT AND CABIN. ACCOMPLISHED J/C 08L00021001 (SMOKE ODOR FUMES INITIAL TROUBLESHOOTING) FOUND RIGHT RECIRCULATION FAN C/B POPED. REMOVE AND REPLACED RIGHT RECIRCULATION FAN. OPERTIONASDR AALA202405318641Light · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND SIDE EMERGENCY LIGHTS EXTERIOR ON OVERWING AFT POSITION INOPERATIVE. (OPEN).SDR AALA202405318851Light · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND SIDE EMERGENCY LIGHTS EXTERIOR ON OVERWING MIDDLE POSITION INOPERATIVE. (OPEN).SDR AALA202405319301Sign · missingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTED THAT THE EXIT SIGN NEAR THE AFT LEFTLAVATORY IS MISSING. INSTALLED MISSING EXIT LIGHT COVER. PER AMM 33-51-00.SDR AALA202405313373Intercostal · damagedAIRCRAFT IN BASE MAINTENANCE: UNSPECIFIED DAMAGE TO PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 927 TO BS 947, RBL 16. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202406216817Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 767 TO STA 787, RBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202406192869Threshold · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT THRESHOLD AT STA 827, S26R. REPAIRED THRESHOLD PER SRM 51-10-02-0G.SDR AALA202406176585Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727 TO STA 867, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202406176628Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION SHIELD FROM STA 847 TO STA 867, S24R. REPLACED TRANSITION SHIELD PER AARD 51-00-05-1.SDR AALA202406068315Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L2 DOOR ENTRY AREA LOWER SILL INNER CHORD (CREASE ANGLE) AT STA 984, LBL 52. REPARED INNER CHORD PER EA 354931.SDR AALA202406062822Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT FORWARD BULKHEAD RIGHT SIDE BULKHEAD PANEL ANGLE. REPLACED BRACKET PER SRM 51-40-02-0G.SDR AALA202405316090Cover · dislodgedAIRCRAFT WAS NOT GROUNDED: SEAT 12C EMERGENCY LIGHT IS DANGLING FROM WIRES UNDER SEAT. INSTALLED MISSING EXIT LIGHT COVER. PER AMM 33-51-00.SDR AALA202405307427Trim Panel · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKS AND IS HARD TO OPEN AND SHUT. SECURED FORWARD GALLEY LAVATORY TRIM AS REQUIRED. PER AMM 25-40-00.SDR AALA202405303865Housing · unsecureAIRCRAFT WAS NOT GROUNDED: 26C EMERGENCY LIGHT HOUSING IS LOOSE. SECURED 26C EMERGENCY LIGHT HOUSING AS REQUIRED.SDR AALA202405306090Light · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 12C EMERGENCY LIGHT IS DANGLING FROM WIRES UNDER SEAT. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202405308393Battery Pack · no testAIRCRAFT WAS GROUNDED: PER JOB CARD 08T21033001 EMERGENCY LIGHTS FUNCTIONAL CHECK FAILED AT SEAT AISLE ROW 18ABC TO 25ABC. REMOVE AND REPLACED EMERGENCY BATTERY SUPPLY UNIT. PER AMM 33-51-06SDR AALA202405302985Battery Pack · no testAIRCRAFT WAS GROUNDED: PER JOB CARD 08T21033001 EMERGENCY LIGHTS FUNCTIONAL CHECK FAILED AT CEILING LEFT HAND ROW 17-30. REMOVE AND REPLACED EMERGENCY BATTERY SUPPLY UNIT. PER AMM 33-51-06.SDR AALA202405306959Battery Pack · no testAIRCRAFT WAS GROUNDED: PER JOB CARD 08T21033001 EMERGENCY LIGHTS FUNCTIONAL CHECK FAILED AT L2 DOOR EXIT SIGN. REMOVE AND REPLACED EMERGENCY BATTERY SUPPLY UNIT. PER AMM 33-51-06.SDR AALA202405305271Battery Pack · no testAIRCRAFT WAS GROUNDED: PER JOB CARD 08T21033001 EMERGENCY LIGHTS FUNCTIONAL CHECK FAILED AT AFT CEILING EXIT SIGN. REMOVE AND REPALCED EMERGENCY BATTERY SUPPLY UNIT. PER AMM 33-51-06.SDR AALA202405303855Battery Pack · no testAIRCRAFT WAS GROUNDED: PER JOB CARD 08T21033001 EMERGENCY LIGHTS FUNCTIONAL CHECK FAILED AT L1 DOOR EXIT SIGN. REMOVE AND REPLACED EMERGENCY BATTERY SUPPLY UNIT. PER AMM 33-51-06.SDR AALA202406051255Hinge · brokenAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR GETS STUCK. PASSENGERS ARE HAVING A DIFFICULT TIME OPENING AND CLOSING THE DOOR.**SUPPLEMENTAL REPORT FOR (AALA202405291255): REPLACED FORWARD LAVATORY DOOR HINGE. PER CMM 25-45-46**(CLOSED).SDR AALA202405300920Tube · missingAIRCRAFT WAS NOT GROUNDED: R1 GIRT BAR MISSING RED SHRINKING TUBE. **SUPPLEMENTAL REPORT FOR 9AALA202405290920): REPLACED SHRINK WRAP TUBING ON R1 GIRT BAR**(CLOSED).SDR AALA202405296127Transceiver · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WEATHER RADAR FAIL AND PWS FAILED IN FLIGHT; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT TPA. REMOVE AND REPLACED OF WEATHER RADAR TRANSCEIVER. PER FIM 34-43-00.SDR AALA202405298176Tat Probe · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON CLIMB MULTIPLE FAILURE WITH AUTO THROTTLE, TEMP CONTROL, AND OTHER FAILURES; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT TUL. FOUND FAULT TAT PROBESIGNAL FAIL. REMOVED AND REPLACED TAT PROBE. OPERTIONAL
Back to Boeing 737-823