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 AALA201807169047Sliding Window · bindingFIRST OFFICER`S R2 SLIDING WINDOW DIFFICULT TO OPEN AND CLOSE. THE AIRCRAFT WAS GROUNDED. REPLACED THE WINDOW IAW MCM 56-94-02. OPS CHECKED GOOD.SDR AALA201807193004Transition Panel · corrodedCORROSION ON RIGHT TRANSITION PANEL, BETWEEN BS 867 AND 887, RBL 21. REPLACED THE TRANSITON PANEL IAW 51-00-05-1 AND DRAWING 146A7500.SDR AALA201807193002Angle · corrodedCORROSION ON ANGLE WALL SUPPORT, BS 992, RBL 31 TO RBL 35. REPLACED ANGLE WALL SUPPORT IAW 51-00-05-1 AND DRAWING 147A5700.SDR AALA201807186005Transition Panel · corrodedNUMEROUS AREAS OF CORROSION ON THE LEFT TRANSITION PANEL IN THE FORWARD CARGO, BS 400 - 500I. REPLACED THE TRANSITION PANEL IAW SRM 51-10-2 AND SRM 53-00-53-2R.SDR AALA2018071869044Megaphone · inoperativeAFT CABIN MEGAPHONE WAS FOUND INOPERATIVE. REPLACED THE MEGAPHONE IAW AMM 25-64-00.SDR AALA201807179024Battery Pack · dischargedAIRCRAFT WAS GROUNDED: REGARDLESS OF SWITCH POSITION, EMERGENCY EXIT LIGHTS ON AIRCRAFT LEFT WERE ON INTERMITTENT. MAINTENANCE REPLACED BATTERY PACK EQ M1670 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-06.SDR AALA201807179008Skin · corrodedCORROSION FOUND ON THE FUSELAGE SKIN AT THE LAVATORY VACUUM WASTE VENT. THE AIRCRAFT WAS GROUNDED. REPAIRED FUSELAGE SKIN IAW SRM 53-70-01-2R-3.SDR AALA201807175005Support Frame · corrodedAFT LOWER BULKHEAD SUPPORT FRAME AT BS 500I CORRODED. REPLACED THE SUPPORT FRAME IAW 51-11-05-01.SDR AALA201807175004Baffle · crackedTHE LEFT BAFFLE WAS CRACKED AT BS 500G - 500H. REPLACED THE BAFFLE IAW 51-00-05.SDR AALA201807165006Transition Panel · corrodedNUMEROUS AREAS OF CORROSION ON THE RIGHT TRANSITION PANEL, BETWEEN BS 500A TO 500I IN THE FORWARD CARGO BAY. REPLACED THE RIGHT TRANSITION PANEL IAW SRM 51-10-2 AND SRM 53-00-53-2.SDR AALA201807131003Floor Support · corrodedTHE AFT CABIN FORWARD END OF THE FLOOR SUPPORT, BS 951, RBL 26 WAS CORRODED. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1, DRAWING 147A5700, AND 147A5660.SDR AALA201807139010Connector · disconnectedFORWARD ENTRY DOOR EMERGENCY LIGHT WAS INOPERATIVE. FOUND THE ELECTRICAL CONNECTOR DISCONNECTED. CONNECTED THE CONNECTOR, OPS CHECKED NORMAL IAW AMM 33-51-04.SDR AALA201807129013Life Raft · low pressureCENTER LIFE RAFT PRESSURE WAS LOW. REPLACED THE LIFE RAFT IAW AMM 25-64-00.SDR AALA201807121004Floor Support · corrodedCORROSION WAS FOUND ON THE FLOOR SUPPORT, BS 951, RBL 22. REPLACED THE FLOOR SUPPORT IAW 51-00-05.SDR AALA20180711002Doubler · crackedTHE AIRCRAFT IS IN BASE MAINTENANCE. EXHAUST CUT OUT DOUBLER CRACKED AT INBOARD ATTACH FLANGE ON RIGHT HAND VAPOR BARRIER WEB. REPLACED DOUBLER PER 51-00-05.SDR AALA2018071111001Angle · crackedHORIZONTAL ANGLE CRACKED AT INBOARD END. IN THE RIGHT AIR CONIDITIONING BAY BULKHEAD WEB. REPLACED THE HORIZONTAL ANGLE IAW 51-00-05, AND DRAWING 111A1000.SDR AALA2018071629023Window · arcedCO-PILOT FRONT WINDSHIELD HAS UNEVEN HEATING CAUSING DISTORTION, ELECTRICAL ARCING NOTICED DURING CLIMB. THE AIRCRAFT WAS GROUNDED. REPLACED CO-PILOT R1 WINDOW IAW MCM 56-94-04.SDR AALA2018071310001Support Angle · corrodedCORROSION FOUND ON THE ZEE SUPPORT ANGLE, BS 993 TO 1016, RBL 33 TO 46. REPLACED THE SUPPORT ANGLE IAW 51-00-05 AND DRAWING 147A5700.SDR AALA2018071109030Windshield · crackedCAPTAIN`S L1 WINDSHIELD HAD A CRACK AND SCRATCH ON THE INNER PANE LOWER LEFT CORNER. THE AIRCRAFT WAS GROUNDED. REPLACED L1 WINDSHIELD IAW J/C 56-94-03.SDR AALA2018071210006Oil System · leakingENROUTE AUTOPILOT DISCONNECTED, APU SHUT DOWN WITH LOW OIL PRESSURE ILLUMINATED WHILE AT FL370. RESTART ATTEMPTED AT 270 BUT DID NOT REMAIN RUNNING. THE AIRCRAFT WAS GROUNDED. MAINTENANCE SERVICED APU OIL TO FULL. FOUND SIGHT GLASS DARKENED, CARMELIZED MAKINSDR AALA20180710009Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON RIGHT HAND TRANSITION PANEL (SHIELD) LOCATED FROM STA 420-440 IN THE FORWARD CARGO AREA. REPLACED TRANSITION PANEL (SHIELD) PER DRAWING 143A8126 AND 51-00-05.SDR AALA20180710007Shim · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION AT STA 540, STR 22L OF THE CENTER WING LOWER SKIN. REMOVED/BLENDED OUT CORROSION AND INSTALLED FABRICATED REPAIR SHIM PER EA 282232 DRAFT 1.SDR AALA201807119006Windshield · scratchedTHE AIRCRAFT WAS GROUNDED. FLIGHT DECK L1 WINDSHIELD HAS LARGE SCRATCH. REPLACED FLIGHT DECK L1 WINDSHIELD PER WC 56-94-03.SDR AALA2018071110010Transition Panel · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. NUMEROUS AREAS OF CORROSION FOUND ON RIGHT TRANSITION PANEL FROM BS 490 - 500A . REPLACED THE TRANSITION PANEL IAW SRM 51-10-2, 51-00-05, AND DRAWING 143A8126.SDR AALA201807110002Angle · corrodedCORROSION FOUND ON THE AFT CABIN ZEE ANGLE, BS 993, BETWEEN LBL 33 TO LBL 46. REPLACED THE ANGLE IAW SRM 51-40-02 AND SRM 51-10-02, PARAGRAPH 8.SDR AALA201807109025Bearing · damagedAIRCRAFT WAS NOT GROUNDED: FIRST OFFICERS, SLIDING WINDOW, WAS HARD TO OPEN AND CLOSE. MAINTENANCE REPAIRED FORWARD BEARING FOR SLIDING WINDOW AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 56-12-11.SDR AALA20180709005Web · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON RIGHT HAND K WEB BETWEEN STA 1016 TO STA 986, RBL 32. REPLACED WEB PER 51-00-05 AND DRAWING 147A5700.SDR AALA20180709004Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON INTERCOSTAL BETWEEN STA 986 TO STA 1006, RBL 32. REPLACED INTERCOSTAL PER 51-00-05 AND DRAWING 147A5700.SDR AALA20180709003Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON FLOORBEAM UPPER T CHORD AT STA 947, RBL 7.8 TO LBL 59. REPAIRED FLOORBEAM UPPER T CHORD AND SPLICE DOUBLER PER SRM 53-70-51-2R-5.SDR AALA20180709002Angle · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION AFT CABIN ON Z ANGLE BETWEEN STA 993 TO STA 1016, RBL 32. REPLACED Z ANGLE PER 51-00-05 AND DRAWING 147A5700.SDR AALA20180709001Angle · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION AFT CABIN ON Z ANGLE BETWEEN STA 993 TO STA 1016, LBL 32. REPLACED Z ANGLE PER 51-00-05 AND DRAWING 147A5700.SDR AALA20180710008Threshold · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. THE RIGHT HAND FORWARD CARGO THRESHOLD (WEB) HAS SEVERAL AREAS OF CORROSION LOCATED BETWEEN STA 460-500. REPLACED THRESHOLD WEB PER SRM 51-10-2, 51-00-5.SDR AALA20180709007Strap · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION AFT RIGHT HAND WEB STRAP BETWEEN STA1016 TO STA 1028, RBL 18. REPLACED WEB STRAP PER 51-00-05-1 AND DRAWING 147A5714.SDR AALA20180709006Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION AFT CABIN LAVATORY D FLOOR INTERCOSTAL AT STA 951, LBL 25. REPLACED INTERCOSTAL PER SRM 51-10-02-OG AND SRM 51-40-02.SDR AALA20180708003Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON FLOORBEAM AT STA 948.5 AT OUTBOARD AFT MOUNT OF RIGHT HAND AFT LAVATORY. REPAIRED FLOORBEAM PER SRM 53-70-51-2R-5.SDR AALA201807098008Angle · corrodedCORROSION FOUND ON THE FORWARD SERVICE DOOR CREASE ANGLE AT BS 294.5. REPLACED THE ANGLE IAW 51-00-05-1.SDR AALA201807098006Strap · corrodedR1 CREASE ANGLE ATTACH STRAP CORRODED. REPLACED THE STRAP IAW 51-00-05-1.SDR AALA201807098005Bulkhead Web · crackedDURING ACCOMPLISHMENT OF SURFACE SCAN OF VERTICAL PRESSURE DECK ON THE RIGHT SIDE, OTBD BAY, A CRACK WAS CONFIRMED BETWEEN RBL 40 AND RBL 45.64 MULTIPLE CRACKS AND APPEARS TO SPIDER WEB. REPAIRED PRESSURE BULKHEAD WEB IAW SRM 57-10-10-2R-3, REPAIR ALTERNATE SDR AALA201807098004Strap · corrodedCORROSION ON THE WEB STRAP BETWEEN BS 1016 TO 1028, RBL 18. REPLACED THE WEB STRAP IAW 51-00-05-1, AND DRAWING 147A5714.SDR AALA201807098002Angle · corrodedCORROSION FOUND ON THE ZEE ANGLE AT BS 1014, RBL 31. REPLACED THE ANGLE IAW 51-00-05-1 AND DRAWING 147A5710.SDR AALA201807098001Angle · corrodedCORROSION FOUND ON THE ZEE ANGLE AT BS 992, LBL 38. REPLACED THE ANGLE IAW 51-00-05-1 AND DRAWING 147A5700.SDR AALA201807171006Floor Support · crackedA FLOOR SUPPORT WAS FOUND CRACKED IN THE FORWARD CABIN, BS 328 - 344, LBL45. REPLACED THE FLOOR SUPPORT IAW SRM 51-10-02.SDR AALA201807097001Angle · corrodedCORROSION FOUND ON THE ZEE ANGLE AT BS 1011, LBL 32. REPLACED THE ANGLE IAW 51-00-05, AND DRAWING 147A5700.SDR AALA201807276002Floor Support · corrodedCORROSION ON THE FLOOR SUPPORT BETWEEN BS 947.5 - 967, RBL 25. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1, AND DRAWING 815A0010.SDR AALA20180719003Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON WEB, L2 DOOR, AT FLOORBOARD HOLES. REPLACED WEB PER 51-00-5.SDR AALA201807198004Floor Support · crackedCRACKED FLOOR SUPPORT, BS 540, LBL 2. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA20180718005Floor Support · crackedTHE CABIN FLOOR SUPPORT AT BS 540 IS CRACKED AT RBL 2. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201807171005Floor Support · crackedTHE FLOOR SUPPORT WAS FOUND CRACKED IN THE FORWARD CABIN, BS 312 - 328, LBL 45. REPLACED THE FLOOR SUPPORT IAW SRM 51-10-02.SDR AALA20180711007Intercostal · crackedTHE AIRCRAFT IS IN BASE MAINTENANCE. CRACKED INTERCOSTAL AT STATIONS 277-294 RBL 1. REPLACED INTERCOSTAL PER 51-00-05-1 AND DRAWING 141A5400.SDR AALA2018071199061Bulkhead Web · crackedBS 663 BULKHEAD WEB CRACKED BETWEEN RBL 29.83 AND RBL 36.83. REPAIRED THE BULKEHEAD WEB IAW 57-10-10-9 REPAIR 9.3.
Back to Boeing 737-823