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 AALA202105039010Seal · leakingAIRCRAFT WAS GROUNDED: ENGINE OIL DECREASED DURING FLIGHT. #2 ENGINE FROM 9 QTS AT CRUISE DOWN TO 4 QTS. DECISION MADE TO DIVERT TO MSY. EMERGENCY DECLARED. TEMPERATURE AND PRESSURE NORMAL THROUGHOUT. OIL QUANTITY AS LOW AS 2 QTS ON APPROACH. FOUND OIL LEAK ATSDR AALA202105019001Oil Filter · leakingAIRCRAFT WAS GROUNDED: ENGINE OIL DECREASED DURING FLIGHT. #2 ENGINE FROM 9 QTS AT CRUISE DOWN TO 4 QTS. DECISION MADE TO DIVERT TO MSY. EMERGENCY DECLARED. TEMPERATURE AND PRESSURE NORMAL THROUGHOUT. OIL QUANTITY AS LOW AS 2 QTS ON APPROACH. FOUND OIL LEAK ATSDR AALA202104299009Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: FIRST OFFICER'S RIGHT WINDOW FRAME AT STA 211.8 REQUIRES REINFORCING REPAIR. INSTALLED DOUBLER/TRIPLER REPAIR REF SB 737-53-1335.SDR AALA202104299008Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CAPTAINS LEFT WINDOW FRAME AT STA 211.8 REQUIRES REINFORCING REPAIR. INSTALLED DOUBLER/TRIPLER REPAIR REF SB 737-53-1335.SDR AALA202105049025Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND INTERCOSTAL CRACKED AT FLOORBOARD NUT CLIP HOLES LOCATED AT STA 328-344 AND RIGHT BUTT LINE 32. REPLACED CRACKED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202105049024Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACKED INTERCOSTAL LOCATED AT STA 328-344, LEFT BUTT LINE 45. REPLACED CRACKED INTERCOSTAL PER SRM 51-10-02-0G.SDR AALA202105049023Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACK ON INTERCOSTAL LOCATED AT STA 312-328, LEFT BUTT LINE 45. REPLACED CRACKED INTERCOSTAL PER SRM 51-10-02-0G AND AARD 51-00-05-1.SDR AALA202105039014Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: INTERIOR LH OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED POWER SUPPLY M1694 WITH NEW, OPS CHECK GOOD.SDR AALA202105039013Power Supply · inflt separationAIRCRAFT IN BASE MAINTENANCE: INTERIOR RH OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED POWER SUPPLY M1695 WITH NEW, OPS CHECK GOOD.SDR AALA202105039012Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: RH EXTERIOR FWD EMERGENCY LIGHT INOP. REPLACED POWER SUPPLY M1676 WITH NEW, OPS CHECK GOOD.SDR AALA202104309008Starter · leakingAIRCRAFT WAS GROUNDED: ABOUT 1 HOUR INTO FLIGHT NOTICED A RAPID DECREASE IN OIL QUANTITY, APPROXIMATELY 1 QUART PER HOUR. DECLARED EMERGENCY AND DIVERTED TO PHX. LANDED WITH 2 QUARTS REMAINING. SHUTDOWN NORMAL AFTER LANDING. NO HIGH TEMPERATURE OR LOW PRESSURESDR AALA202104299007Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND 1 INCH CRACK IN VAPOR BARRIER TO CENTER FUEL TANK ATTACH ANGLE. INSTALLED SPLICE REPAIR IAW SRM 57-10-10-2R-5.SDR AALA202104299006Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND 1 INCH CRACK IN VAPOR BARRIER TO CENTER FUEL TANK ATTACH ANGLE. INSTALLED SPLICE REPAIR REF SRM 57-10-10-2R-5.SDR AALA202104299004Sliding Window · stuckAIRCRAFT WAS GROUNDED: FIRST OFFICER SLIDING WINDOW WILL NOT CLOSE. WINDOW FELL OUT OF TRACK. REPLACED SLIDING WINDOW PER AMM 56-12-11 AND MCM 56-96-02.SDR AALA202104289005Windshield · delaminatedAIRCRAFT WAS GROUNDED: POSSIBLE WINDOW DELAMINATION ON BOTTOM RIGHT CORNER OF WINDOW R1. REMOVED AND REPLACED WINDOW REF MCM 56-94-04.SDR AALA202105049034Housing · brokenAIRCRAFT IN BASE MAINTENANCE: EXIT LIGHT HOUSING AT SIDEWALL PANEL 12L BROKEN. REMOVED AND REPLACED EXIT LIGHT HOUSING AT SIDEWALL 12L PER AMM 33-51-01.SDR AALA202104279009Battery · failedAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FORWARD JUMP SEAT FLASHES RED WHEN TESTED NOT GREEN. REPLACED BATTERY PER AMM 25-64-00.SDR AALA202104279008Girt Bar · damagedAIRCRAFT IN BASE MAINTENANCE: BLACK VINYL ON L2 DOOR EMERGENCY ESCAPE SLIDE GIRT FOUND DAMAGED. REPAIRED L2 ESCAPE SLIDE GIRT ASSEMBLY CHAFE PATCH PER AA REPAIR DOCUMENT 25-66-00-2SDR AALA202104269049Slide · damagedAIRCRAFT IN BASE MAINTENANCE: L1 DOOR ESCAPE SLIDE HAS WORN/TORN ABRUDUBLE/RUBBER ON THE GIRT. REMOVED AND REPLACED L1 DOOR ESCAPE SLIDE IN ACCORDANCE WITH B737NG AMM 25-66-01-401.SDR AALA202105049028Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION IN AFT CABIN FLOOR BEAM UPPER STRUCTURE AROUND FASTENER HOLE AT STA 986.5 AND LBL52 ABOUT 2 INCH INBOARD OF THE AFT ENTRY DOOR CREASE ANGLE. INSTALLED STRAP REPAIR IAW EA 327262.SDR AALA202104269050Battery Pack · no testAIRCRAFT WAS NOT GROUNDED: AISLE CEILING EMERGENCY LIGHT INOPERATIVE AT OVERWING EXIT. REPLACED EMERGENCY LIGHT M1695 BATTERY PACK IAW AMM 33-51-06.SDR AALA202104269047Angle · looseAIRCRAFT WAS NOT GROUNDED: FWD SERVICE DOOR GIRT BAR CLIPS LOOSE. ADJUSTED CLIPS IAW AMM 25-61-00, OPS CHECK GOOD.SDR AALA202104269053Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE: AFT CABIN FLOOR PANEL 247BA HAS DELAMINATION ON UPPER SURFACE. REPAIRED FLOOR PANEL PER SRM 53-00-50-2R REPAIR #1.SDR AALA202104269052Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE: FORWARD CABIN FLOOR PANEL 222AAA HAS DELAMINATION ON UPPER SURFACE. REPAIRED FLOOR PANEL PER SRM 53-00-50-2R REPAIR #1SDR AALA202104269051Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE: FORWARD CABIN FLOOR PANEL 221CF HAS DELAMINATION ON UPPER SURFACE. REPAIRED FLOOR PANEL PER SRM 53-00-50-2R REPAIR #1.SDR AALA202105139009Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON TRANSITION PANEL LOCATED AT STA 500A-500I, STR 25R. INSTALLED RIGHT TRANSITION ANGLE BETWEEN 500A AND 500I PER AARD 51-00-05-1.SDR AALA202105139012Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION OF LEFT HAND TRANSITION PANEL FROM STA 500 +13 TO STA 500I, S25L. INSTALLED PER SRM 53-00-53-2R-5.SDR AALA202104269040Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH LIGHTING DETACHED AT SEAT 13C. ADJUSTED COVER FOR EMERGENCY PATH LIGHTING IAW AMM 25-21-00, OPS CHECK GOOD.SDR AALA202105189018Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: MULTIPLE SPOTS OF CORROSION FOUND ON RIGHT TRANSITION PANEL FROM STA 727 TO 767, BUTT LINE 23R. INSTALLED RIGHT TRANSITION PANEL AND SPLICE AT STA 727F +11 TO STA 767 PER AARD 51-00-05-1.SDR AALA202105139008Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: MULTIPLE SPOTS OF CORROSION ON LEFT TRANSITION PANEL LOCATED FROM STA 727 D TO 727 G, BUTT LINE 23L. INSTALLED LEFT TRANSITION PANEL AND SPLICES PER AARD 51-00-05-1.SDR AALA202105139007Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON CARGO TRANSITION PANEL LOCATED AT STA 767 - 1016, STR S-25L, AND RIGHT BUTT LINE 30. REPLACED CARGO TRANSITION PANEL PER SRM 53-00-53.SDR AALA202105109008Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION ON DOOR THRESOLD WEB AT STA 440-492, STR 23R, AND RBL 33. REMOVED AND REPLACED DOOR THRESHOLD WEB REF SRM 51-40-02.SDR AALA202105049030Web · corrodedAIRCRAFT IN BASE MAINTENANCE: FOUND CORROSION ON DOOR THRESHOLD WEB AT 787-847 AND STR 25R. REPLACED WEB REF AARD 51-00-05-1.SDR AALA202104299002Angle · deformedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR STA 887 AND RIGHT BUTT LINE 24.75 THE SEAT TRACK CARRY THROUGH ANGLE HAS OVERSIZED, ELONGATED HOLES. REMOVED AND REPLACED CARRY ANGLE AT STA 887 RIGHT BUTT LINE PER DRAWINGS AND SRM 51-40-02.SDR AALA202104279013Module · faultedAIRCRAFT WAS GROUNDED: LH ALTIMETER AND RH AIRSPEED INDICATION UNRELIABLE, FLIGHT DECLARED EMERGENCY AND DIVERTED TO LIT. REPLACED RH PITOT PROBE (AALA202104279011) IAW AMM 34-11-01, WINDOW/PITOT HEAT MODULE (AALA202104279012) IAW AMM 30-41-41, AND RH PITOT AISDR AALA202104279012Module · faultedAIRCRAFT WAS GROUNDED: LH ALTIMETER AND RH AIRSPEED INDICATION UNRELIABLE, FLIGHT DECLARED EMERGENCY AND DIVERTED TO LIT. REPLACED RH PITOT PROBE (AALA202104279011) IAW AMM 34-11-01, WINDOW/PITOT HEAT MODULE IAW AMM 30-41-41, AND RH PITOT AIR DATA MODULE (AALASDR AALA202104279011Pitot Tube · faultedAIRCRAFT WAS GROUNDED: LH ALTIMETER AND RH AIRSPEED INDICATION UNRELIABLE, FLIGHT DECLARED EMERGENCY AND DIVERTED TO LIT. REPLACED RH PITOT PROBE IAW AMM 34-11-01, WINDOW/PITOT HEAT OH PANEL (AALA202104279012) IAW AMM 30-41-41, AND RH PITOT AIR DATA MODULE (AASDR AALA202104269036Shroud · brokenAIRCRAFT WAS NOT GROUND: FOUND CABIN SEAT EMERGENCY ESCAPE PATH SHROUD BROKEN AT ROW 21C. REPLACED SEAT 21C EMERGENCY ESCAPE PATH SHROUD IAW MM 33-51-11.SDR AALA202104269035Shroud · brokenAIRCRAFT WAS NOT GROUNDED: FOUND CABIN SEAT EMERGENCY ESCAPE PATH SHROUD BROKEN AT ROW 12C. REPLACED SEAT 12C EMERGENCY PATH SHROUD IAW MM 33-51-11.SDR AALA202104269034Shroud · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH, SEAT MOUNTED, AT SEAT 14C IS FALLING OFF. REPLACED SEAT 14C EMERGENCY ESCAPE PATH SHROUD IAW MM 33-51-11.SDR AALA202104269012Switch · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR LIGHT ILLUMINATED AFTER PUSH BACK BEFORE TAXI OUT. TROUBLESHOT PER FIM 52-10-00-810-801 AND ADJUSTED FORWARD ENTRY DOOR SWITCH S1147 PER AMM 52-71-11.SDR AALA202104269048Slide · out of positionAIRCRAFT WAS GROUNDED: R1 ESCAPE SLIDE DISCOVERED FALLEN OUT OF DOOR. NOT DEPLOYED. SLIDE WAS KNOCKED OFF DOOR BY CABIN CLEANERS. REPLACED R1 ESCAPE SLIDE PER MCM 25-94-10.SDR AALA202104269015Striker · missingAIRCRAFT WAS GROUNDED: DURING ACCOMPLISHMENT OF WORK CARD 5218J219-003 FOUND H/P DOOR ACCESS LATCH STRIKER PLATE MISSING AND STRUCTURE WORN. ACCOMPLISHED WORK PER SRM 57-13-10 INSTALLED NUMBER 2 STRIKER PLATE PER SRM 57-13-10-2R-3 PLUS ADJUSTED LATCHES PER AMSDR AALA202105049032Connector · brokenAIRCRAFT IN BASE MAINTENANCE: UPON INSTALL OF G1 GALLEY FOUND EXIT LIGHT WIRES PULLED OUT OF CONNECTOR. REPAIRED CONNECTOR OF EXIT LIGHT AT G1 IAW BOEING SWPM 20-90-14 AND RING OUT GOOD IAW BWPM 33-51-21.SDR AALA202105059005Housing · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD OVER WING EXIT SIGN HOUSING CRACKED. REPLACED HOUSING PER AMM 33-51-04.SDR AALA202105059004Lens · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD OVER WING EXIT SIGN LENS CRACKED. REPLACED LENS PER AMM 33-51-04.SDR AALA202105059003Housing · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT OVER WING EXIT SIGN HOUSING CRACKED. REPLACED HOUSING PER AMM 33-51-04.SDR AALA202105049033Lens · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT OVER WING EXIT SIGN LENS CRACKED. REPLACED LENS PER AMM 33-51-04.SDR AALA202104239022Bracket · out of adjustAIRCRAFT WAS NOT GROUNDED: 1R DOOR GIRT BAR WAS JAMMED UPON ARRIVAL. ADJUSTED GIRT BAR BRACKET IAW AMM 25-66-00, OPS CHECK GOOD.SDR AALA202104239019Lens · missingAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT LENS COVER BY LAVATORY D DOOR MISSING. REPLACED LENS COVER WITH NEW IAW AMM 33-51-00, OPS CHECK GOOD.
Back to Boeing 737-823