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 AALA202410100162Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT ROW 11 ABC FOUND HANGING. REINSTALLED EMERGENCY LIGHT. LIGHT CHECKS GOOD. PER AMM 33-51-11.SDR AALA202410100075Engine · fodAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENGINE NUMBER 1 VIBRATION AT CRUISE. SUSTAINED LEVELS GREATER THAN 1.0 ACCOMPANIED BY AUDIBLE OR AIRFRAME VIBRATIONS; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT CLT. REMOVED TOOLING FROM PREVIOUS JOB INSSDR AALA202410107968Probe · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON TAKEOFF ENGINE NUMBER 2 EGT EXCEEDED LIMITS (AT LEAST 977) FOR ABOUT 1-2 MINUTES AT CRUISE IT'S APPROX 50 DEGREES HOTTER THAN NUMBER 1; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. ACCOSDR AALA202410108579Wire Harness · damagedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON TAKEOFF ENGINE NUMBER 2 EGT EXCEEDED LIMITS (AT LEAST 977) FOR ABOUT 1-2 MINUTES AT CRUISE IT'S APPROX 50 DEGREES HOTTER THAN NUMBER 1; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. ACCOSDR AALA202410105300Probe · overtempAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON TAKEOFF ENGINE NUMBER 2 EGT EXCEEDED LIMITS (AT LEAST 977) FOR ABOUT 1-2 MINUTES AT CRUISE IT'S APPROX 50 DEGREES HOTTER THAN NUMBER 1; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. ACCOSDR AALA202410165666Frame · not reportedAIRCRAFT IN BASE MAINTENANCE: REPLACEMENT OF RIGHT HAND FRAME (PICKLE FORK) AT STA 663, S18R REQUIRED PER EA 358150 DUE TO REPLACEMENT OF LEFT HAND FRAME (SEE AALA202410160180 FOR LEFT HAND FRAME REPLACEMENT). REPLACED FRAME PER EA 358150 .SDR AALA202410151043Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT STA 927 PLUS 16 INCHES, RBL 16. REPAIRED PER SRM 53-10-51-1A-1.SDR AALA202410155674Floorbeam · out of toleranceAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLES IN AFT PASSENGER CABIN GALLEY FLOOR STRUCTURE Z ANGLE AT STA 993, FROM RBL 37 TO RBL 43. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202410144329Attach Bracket · damagedAIRCRAFT IN BASE MAINTENANCE: DAMAGE TO R2 DOOR LOWER SILL STRUCTURE ATTACH BRACKET (CLIP) AT STA 947, RBL 51. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA202410147576Web · damagedAIRCRAFT IN BASE MAINTENANCE: DAMAGE TO R2 DOOR LOWER SILL STRUCTURE WEB AT STA 947, RBL 51. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202410090591Sign · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN ON CEILING BY EXIT ROWS FELL ON THE GROUND. RESECURED CEILING EMERGENCY EXIT ROW SIGN, OPERTIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202410095014Pressure Switch · faultedAIRCRAFT WAS NOT GROUNDED: AT CRUISE ALTITUDE, THE LEFT AFT MAIN TANK "LOW PRESSURE" LIGHT ILLUMINATED STEADY. 5.30 QTY INDICATED IN LEFT TANK. RAN QRH AND TURNED OFF THE AFT LEFT PUMP AND "LOW PRESSURE" LIGHT REMAINED ILLUMINATED. FUEL FLOW AND QTY APPEARED NSDR AALA202410091547Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTANDENT FLASHLIGHT IS FLASHING RED. REPLACED FORWARD FLIGHT ATTENDANT INBOARD FLASHLIGHT ASSEMBLY. PER AMM 25-64-00.SDR AALA202410098108Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN STUB FRAME ABOVE CENTER WING BOX AT BS 616, FROM RBL 70 TO RBL 85. ACCOMPLISHED REINFORCING REPAIR PER EA 357998.SDR AALA202410156567Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT STA 540, RBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202410154796Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 320 TO STA 344, LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202410150408Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL AT STA 540, LBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202410095745Overheat Loop · shortedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: CLIMBING THROUGH 11,000 FT RIGHT WING TO BODY OVERHEAT LIGHT ILLUMINATED. RAN QRH LIGHT DID NOT GO OUT, 10 MIN LATER LIGHT WENT OUT BUT FLICKERED FOR REMAINDER OF FLIGHT, AIRCRAFT AIR INTERRUPTED BACK TOSDR AALA202410095176Battery · no testAIRCRAFT IN BASE MAINTENANCE: OUTBOARD FLIGHT ATTENDANT FLASHLIGHT AT FORWARD ENTRY DOOR DOES NOT TEST. INSTALLED NEW BATTERY IN FLASHLIGHT PER AMM 25-64-00. OPS CHECK GOOD.SDR AALA202410085745Warning Light · intermittentAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: CLIMBING THROUGH 11,000 FT RIGHT WING TO BODY OVERHEAT LIGHT ILLUMINATED. RAN QRH LIGHT DID NOT GO OUT, 10 MIN LATER LIGHT WENT OUT BUT FLICKERED FOR REMAINDER OF FLIGHT, AIRCRAFT AIR INTERRUPTED BACK TOSDR AALA202410158623Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500B TO STA 500I, S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202410071894Window · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LOUD SQUEAL FROM CAPTIAN SLIDING WINDOW ON CLIMB. CHECKED WINDOW, WINDOW WAS LOCKED. SQUEAL LESSENED WHEN PRESSURE APPLIED TO HANDLE BUT NEVER WENT AWAY COMPLETELY; AIRCRAFT AIR INTERRUPTED BACK TO AND LSDR AALA202410071538Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: LIGHT NEEDS NEW BATTERY IN FORWARD EMERGENCY BOX. REPLACED FORWARD EMERGENCY BATTERY LIGHT AS REQUIRED AMM 25-00-00.SDR AALA202410156858Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED GIRT BAR TIEDOWN AT BS 344, LBL 17. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202410072715Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS FRONT FLASHLIGHT UNDER JUMP SEAT, SEAL IS BROKEN AND INSTALLED BACKWARDS. MAINTENANCE REPLACED FLASHLIGHT BATTERY.SDR AALA202410212534Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 948, RBL 50. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202410214058Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947, RBL 53. REPAIRED CHORD PER SRM 53-70-51-2R-5.SDR AALA202410217266Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 460 TO STA 500I, S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202410156195Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM STA 847 TO STA 867, RBL 18. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202410150485Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED GIRT BAR TIEDOWN AT BS 312, LBL 17. REPLACED TIEDOWN PER AARD 51-00-05-1.SDR AALA202410150369Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT AT STA 787, RBL 23. REPAIRED PER SRM 51-10-02 -0G.SDR AALA202410151855Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT STA 727 PLUS 12 INCHES, LBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202410154314Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION SHIELD FROM STA 767 TO STA 787, S25R. REPLACED TRANSITION SHIELD PER AARD 51-00-05-1A.SDR AALA202410152675Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD AT STA 947, FROM LBL 13 TO RBL 13. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-70-51-2R-8.SDR AALA202410159440Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 727 PLUS 4 INCHES TO 727B PLUS 7 INCHES, S25R. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202410112249Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FORWARD GALLEY FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328, LBL 33. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202410110491Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FORWARD GALLEY FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 330, RBL 32. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202410112434Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FORWARD GALLEY FLOOR STRUCTURE INTERCOSTAL FROM BS 291 TO BS 277, RBL 1. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202411065506Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947, LBL 23. REPAIRED CHORD PER SRM 53-70-51-2R-5 ALTERNATIVE 2 AND EA 358641.SDR AALA202411066097Skin · corrodedAIRCRAFT WAS GROUNDED: LARGE AREA OF SEVERE CORROSION APROX 2" X 1" AT BS 887 STR 27L. RIVET HEAD MISSING AN D SKIN CRACKED APROX 1" LENGTHWISE OF AC. MX FOUND CORROSION ON FUSELAGE SKIN UNDER SPLICE STRAP AT BS 887, FROM S24L TO S27R. ACCOMPLISHED DOUBLER RESDR AALA202410215885Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L2 DOOR SURROUND STRUCTURE LOWER SILL CHORD (CREASE ANGLE) LOCATED FROM STA 969 TO STA 984, LBL 48.SDR AALA202410213728Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT AT STA 950, LBL 47. REPLACED SUPPORT PER AARD 51-00-5-01.SDR AALA202410216390Floorbeam · corrodedAIRCARFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE SUPPORT (Z-ANGLE) AT STA 992, FROM LBL 37 TO LBL 44. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202410180711Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727I TO STA 767, S23R. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202410158064Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500B TO STA 500E, S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202410141933Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL AT STA 755, LBL 24. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202410144349Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR LOWER CUTOUT WEB FROM STA 787 TO STA 849, S24R. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202410116534Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE:: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 956, LBL 50. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202410046671Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LH FWD OVERWING EXTERIOR EMERGENCY LIGHT INOP. MAINTENANCE RE-LAMPED LEFT FWD OVERWING EXTERIOR EMERGENCY LIGHT, OPS CHECKGOOD PER AMM 33-51-04SDR AALA202410116331Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CHORD) AT STA 945, LBL 33. REPAIRED CHORD PER AARD 51-00-05-01 SRM 53-70-51-2R-5.
Back to Boeing 737-823