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 AALA202505057338Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT BS 727A, S26R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202505054868Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT BS 727B, S26R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202505053509Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727J AND BS 747 AT S26R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202505019189Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727F AND BS 727G AT LBL 25. REPLACED TRANSITION PANEL PER AARD 51-0-05-1.SDR AALA202505014157Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO TRANSITION PANEL BETWEEN STATION BS 727E AND BS 727F AT LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-051.SDR AALA202505019031Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT BS 727B, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-0-05-1.SDR AALA202505018243Transition Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT BS 727A, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-0-05-1.SDR AALA202505013646Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT BS 727C. LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202505017498Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727D TO BS 727E AT LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202505011542Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727H AND BS 727I, AT LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202505013406Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT BS 767, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-0-05-1.SDR AALA202505017557Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR CUT OUT THRESHOLD WEB AT BS 827, RBL 50. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202504110535Retainer · dislodgedAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY RIGHT SIDE SERVICE DOOR GIRT BAR RETAINING CLIP CAME OFF. REMOVED AND REPLACED RELEASE STOP ASSEMBLY (AALA202504118352). PER AMM 25-66-01. REMOVED AND REPLACED HEAT SHRINK TUBING (AALA202504110535) ON AFFECTED END OF GSDR AALA202504118352Locking Cam · dislodgedAIRCRAFT WAS NOT GROUNDED: FORWARD GALLEY RIGHT SIDE SERVICE DOOR GIRT BAR RETAINING CLIP CAME OFF. REMOVED AND REPLACED RELEASE STOP ASSEMBLY (AALA202504118352). PER AMM 25-66-01. REMOVED AND REPLACED HEAT SHRINK TUBING (AALA202504110535) ON AFFECTED END OF GSDR AALA202504088596Compensator · failedAIRCRAFT WAS GROUNDED: IN FLIGHT THE NUMBER 2 FUEL QUANTITY INDICATION BLANKED FOR 2 TO 3 MINUTES. WHEN THE INDICATION RETURNED THE NUMBER 2 QUANTITY WAS APPROXIMATELY 400 LBS BELOW THE NUMBER 1 QUANTITY. THE FUEL HAD BEEN BALANCED SEVERAL MINUTES PRIOR TO WITSDR AALA202504072378Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 483 TO STA 500I AT LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202504076849Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500B TO STA 500I AT RBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202504075400Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SHIELD FROM STA 492 TO STA 500A AT RBL 25. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202504072790Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL FROM STA 314 TO STA 322 AT S25L. REPLACED INTERCOSTAL PER AARD 51-00-50-+1.SDR AALA202504010914Module · leakingAIRCRAFT WAS GROUNDED: GEAR HANDLE IS EXTREMELY DIFFICULT TO MOVE FROM DOWN TO UP TO OFF (TAKEOFF) AND DOWN FOR LANDING. UPON INSPECTION FOUND UNION ON THE HYDRAULIC MODULE SYSTEM-B LEAKING. REPLACED PACKING, PER AMM 27-09-21. SERVICED HYDRAULIC, PER AMM 12-12SDR AALA202504010874Door Latch · dislodgedAIRCRAFT WAS NOT GROUNDED: REPEAT WRITE-UP. FORWARD LAVATORY INTERIOR DOOR LOCK KNOB FELL OFF MULTIPLE TIMES LOCKING PASSENGERS IN LAVATORY. RESECURED LAVATORY DOOR LOCK KNOB (INSIDE).SDR AALA202504015365Hinge · bindingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR BINDS AND IS DIFFICULT TO OPEN AND CLOSE. PERFORMED LAVATORY DOOR HINGE REPAIR. OPERTIONAL CHECK GOOD. PER AARD 25-40-10.SDR AALA202504019348Knob · dislodgedAIRCRAFT WAS NOT GROUNDED: REPEAT WRITE-UP. FORWARD LAVATORY INTERIOR DOOR LOCK KNOB FELL OFF MULTIPLE TIMES. INSTALLED NEW KNOB ON FORWARD LAVATORY DOOR. PER CMM 25-46-96.SDR AALA202504018596Compensator · faultedAIRCRAFT WAS GROUNDED: IN FLIGHT THE NUMBER 2 FUEL QUANTITY INDICATION BLANKED FOR 2 TO 3 MINUTES. WHEN THE INDICATION RETURNED THE NUMBER 2 QUANTITY WAS APPROXIMATELY 400 LBS BELOW THE NUMBER 1 QUANTITY. THE FUEL HAD BEEN BALANCED SEVERAL MINUTES PRIOR TO WITSDR AALA202504016557Light · inoperativeAIRCRAFT WAS NOT GROUNDED: RIGHT HAND FORWARD EMERGENCY EXIT DOOR LIGHT INOPERATIVE. EMERGENCY LIGHT SYSTEM RESET. PER AMM 33-51-00. RIGHT HAND FORWARD EMERGENCY EXIT DOOR LIGHT OPERTIONAL TEST GOOD.SDR AALA202504015410Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 292 TO STA 272 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202505014126Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSATL FROM BS 950 TO BS 967 AT RBL 54. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202505016560Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 500B PLUS 12 INCHES, LBL 12. REPLACED TRANSITION PANEL PER AARD 51-00-5-1.SDR AALA202504142622Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 284. BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202504140773Floorbeam · 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 AND EA 363558.SDR AALA202504144487Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM AT BS 986, RBL 44. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6 AND EA 363558.SDR AALA202504141047Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT STA 500C PLUS 6 INCHES, RBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202504073729Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 490 TO STA 520 RBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202504072622Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT STA 773, LBL 25. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202504012535Light · shortedAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT FROM ROW 26 TO 33 INOPERATIVE. FOUND EXIT PATH LIGHT CONNECTOR D95035 UNDER SEAT 26ABC DISCONNECTED. RECONNECTED AND LIGHTS DID NOT TURN ON. CHECKED VOLTAGE AT PIN 1 AND 2. PER WDM 33-51-22. NO VOLTAGE READING. FOUND SDR AALA202504017877Door · unsecureAIRCRAFT WAS NOT GROUNDED: LOCK ON LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. RESECURED LAVATORY-D DOOR AS REQUIRED. PER CMM 25-40-64. OPERTIONAL CHECK GOOD.SDR AALA202504014178Light · misinstalledAIRCRAFT IN BASE MAINTENANCE: R1 DOOR EXTERIOR EMERGENCY LIGHT ASSEMBLY COVERED BY THE AMERICAN FLIGHT SYMBOL. AIRCRAFT WENT THROUGH MANY INSPECTION WITHOUT ANYONE NOTICING THE ERROR. AIRCRAFT WAS REPAINTED DURING LIVERY VISIT. LIGHT ASSEMBLY UNMASKED AND OPERSDR AALA202503282535Elec Connector · disconnectedAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT FROM ROW 26 TO 33 INOPERATIVE. FOUND EXIT PATH LIGHT CONNECTOR D95035 UNDER SEAT 26ABC DISCONNECTED. RECONNECTED AND LIGHTS DID NOT TURN ON. CHECKED VOLTAGE AT PIN 1 AND 2. PER WDM 33-51-22. NO VOLTAGE READING. **SUPPLEMSDR AALA202503287652Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: PASSENGER SEAT EMERGENCY LIGHTS ROWS 19 TO 25 ARE INOPERATIVE. FOUND CONNECTOR D95034 DISCONNECTED UNDER SEAT 19ABC. RECONNECTED CONNECTOR. PERFORMED EMERGENCY LIGHT OPERTIONAL CEHCK GOOD. PER WDM 33-51-22.SDR AALA202503284793Knob · brokenAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR LOCK IS BROKEN. REINSTALLED DOOR LOCK KNOB. PER AMM 25-40-10.SDR AALA202503281647Knob · dislodgedAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR LOCK KNOB FELL OFF. PASSENGER GOT LOCKED IN THE LAVATORY. REESECURED LOCK KNOB.SDR AALA202503287877Lock · stiffAIRCRAFT WAS NOT GROUNDED: LOCK ON LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202503288589Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D ACCORDION DOOR GETS JAMMED WHEN TRYING TO OPEN BOTH FROM INSIDE AND OUTSIDE. ADJUSTED DOOR AND CLEANED TRACK. PER CMM 25-40-58.SDR AALA202503283207Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR YELLOW LOCK RELEASE MECHANISM WILL NOT RELEASE, AND FORWARD ENTRY DOOR WILL NOT SHUT. LUBRICATED L1 DOOR HOLD OPEN LATCH, OPERTIONAL CHECK GOOD. PER FIM 52-10-00-810-809.SDR AALA202503280021Warning Light · false indicationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: DURING TAKEOFF ROLL AT APPROXIMATELY 130 KNOTS MASTER CAUTION ILLUMINATED, DUE TO "AFT CARGO DOOR LIGHT". AFT CARGO DOOR LIGHT REMAINED ON DURING RETURN. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SSDR AALA202503283151Tube · missingAIRCRAFT WAS NOT GROUNDED: L1 DOOR MISSING HEAT SHRINK ON ONE SIDE OF THE GIRT BAR. **SUPPLEMENTAL REPORT FOR AALA202503273151: INSTALLED MISSING TUBING PER JOB CARD 2523J012-001.** (CLOSED)SDR AALA202503286402Light · shortedAIRCRAFT WAS GROUNDED: EMERGENCY AISLE LIGHTS FROM ROW 26 AND AFT ARE INOPERATIVE. MAINTENANCE FOUND EMERGENCY LIGHT AT SEAT 29C SHORTED. REPLACED LIGHT PER AMM 33-51-11.SDR AALA202503273151Tube · missingAIRCRAFT WAS NOT GROUNDED: L1 DOOR MISSING HEAT SHRINK ON ONE SIDE OF THE GIRT BAR. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202505010017Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM UPPER CHORD (T-CAP) AT BS 947, RBL 24. REPAIRED FLOOR UPPER CHORD BEAM PER SRM 53-70-2R-5 AND EA 363511.SDR AALA202505015446Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM UPPER CHORD (T-CAP) AT BS 947.5, RBL 52. REPAIRED FLOOR BEAM UPPER CHORD PER SRM 53-70-2R-5 AND EA 363511.
Back to Boeing 737-823