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 AALA20180315003Floor Support · crackedCABIN FLOOR SUPPORT CRACKED BETWEEN BS 328 - 344, LBL 45. REPLACED THE FLOOR SUPPORT 51-00-05-1.SDR AALA20180315002Floor Support · crackedCABIN FLOOR SUPPORT BETWEEN BS 312 - 328, LBL 45 FOUND CRACKED. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA20180315001Floor Support · crackedCABIN FLOOR SUPPORT BETWEEN BS 292 - 277, BL 0 IS CRACKED. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA201803169003Sign · missingEXIT SIGN MISSING, AFT OF PASSNEGER DOOR NEXT TO TRASH CAN IN GALLEY RIGHT OF GALLEY DOOR. REPLACED THE EXIT SIGN AND LENS IAW 33-51-01.SDR AALA201803159022Smoke Detector · malfunctionedFORWARD LAVATORY SMOKE DETECTOR ACTIVATES INTERMITTENTLY WITH NO INDICATION OF SMOKE. REPLACED THE FORWARD LAVATORY SMOKE DETECTOR IAW AMM 26-14-01.SDR AALA201803169012Lens · detachedFORWARD ENTRY AREA, EMERGENCY LIGHT LENS DETACHED AND WOULD NOT STAY ON. INSTALLED THE EMERGENCY LIGHT LENS, OK FOR SERVICE IAW AMM 33-51-01.SDR AALA20180314010Rail · corrodedRAIL ASSEMBLY WAS CORRODED AT BS 520 BETWEEN LBL 64 AND RBL 64. REPLACED THE RAIL ASSEMBLY.SDR AALA20180314003Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO LEFT TRANSITION PANEL BETWEEN BS 727D AND 727E. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53.SDR AALA20180314004Transition Panel · corrodedCORROSION ON THE LEFT TRANSITION PANEL IN THE AFT CARGO BETWEEN BS 727E TO 727F. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53 PROCEDURE 5.SDR AALA201803140004Transition Panel · corrodedCORROSION ON THE LEFT TRANSITION PANEL IN THE AFT CARGO BETWEEN BS 727E TO 727F. REPLACED THE TRANSITION PANEL IAW SRM, 53-00-53, PROCEDURE 5.SDR AALA20180314005Transition Panel · corrodedAFT CARGO, RIGHT TRANSITION PANEL CORRODED BETWEEN BS 727J AND 747. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R PROCEDURE 5.SDR AALA201803159002Shade · brokenAIRCRAFT WAS NOT GROUNDED. WINDOW SHADE AT EMERGENCY EXIT SEAT 14F IS BROKEN. WINDOW SHADE EMERGENCY EXIT SEAT 14F WAS REPLACED PER IAW AMM 25-21-12-400-802. OK FOR SERVICE.SDR AALA201803159021Window · damagedCAPTAIN`S L3 WNDOW FOUND DAMAGED, INSIDE CENTER. REPLACED THE CAPTAIN`S WINDOW IAW AMM 56-11-21, LEAK CHECKED OK. THE AIRCRAFT WAS GROUNDED.SDR AALA20180313006Transition Panel · corrodedCORROSION ON THE AFT CARGO, LEFT TRANSITION PANEL BETWEEN BS 727I AND 727J. REPAIRED THE TRANSITION PANEL IAW SRM 53-00-53-2R, PROCEDURE 5.SDR AALA20180313009Floorbeam · brokenBS 540, BL 0 - RBL 20 FLOORBEAM IS BROKEN. REPLACED THE FLOORBEAM IAW 51-00-05-1 REPAIR 1.SDR AALA20180313007Transition Panel · corrodedTRANSITION PANEL CORRODED. REPAIRED THE TRANSITION PANEL IAW SRM 53-00-53-2R, PROCEDURE 5.SDR AALA20180313002Transition Panel · corrodedCORROSION FOUND ON THE RIGHT TRANSITION PANEL. REPAIRED THE TRANSITION PANEL AND DOUBLER IAW SRM 53-00-53-2R, PROCEDURE 5.SDR AALA20180312004Fitting · corrodedCABIN FLOOR GIRT BAR FITTING CORRODED OUT OF LIMITS. REPLACED THE GIRT BAR FITTING IAW 51-00-05-1.SDR AALA20180312003Fitting · corrodedCABIN FLOOR GIRT BAR FITTING AT BS 312, LBL 54 CORRODED OUT OF LIMITS. REPLACED THE GIRT BAR FITTING IAW 51-00-05-1.SDR AALA20180312002Angle · corrodedCORROSION FOUND ON THE ZEE ANGLE. REPLACED THE ANGLE IAW 51-00-05, AND SRM 51-40-02.SDR AALA201803139013Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED. FORWARD LAVATORY SMOKE DETECTOR ACTIVATES INTERMITTENTLY WITH NO INDICATION OF SMOKE. COULD NOT DUPLICATE- ALL OPERATIONS NORMAL AT TIME OF LAVATORY SMOKE SELF TEST AMM 26-14-00.SDR AALA201803129035Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. CABIN DOOR 4L EXIT SIGN MISSING. EXIT SIGN LENS FOUND ON THE FLOOR. SECURED LENS IN PLACE. OPERATIONS CHECK GOOD.SDR AALA201803129034Light · damagedTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT FLOOR ENTRY WAY FLOOD LIGHT HOUSING DAMAGED. REPLACED LIGHT ASSEMBLY EMERGENCY FLOOD PER AMM 33-51-01. OPERATIONS CHECK GOOD.SDR AALA201803129032Lens · brokenEMERGENCY LIGHT LENS AND BEZEL DAMAGED. THE LENS ON FLOOR LEVEL THRESHOLD LIGHT AT FWD ENTRY DOOR IS DENTED AND WILL NOT STAY ON. FORWARD ENTRY LIGHT LENS COVER DAMAGED AT L1 DOOR. REPLACED FORWARD EMERGENCY LIGHT LENS IAW STANDARD MAINTENANCE PRACTICES.SDR AALA201803129018Sign · brokenAIRCRAFT WAS NOT GROUNDED. AFT GALLEY DOOR EXIT SIGN COVER FELL OFF. REPLACED 4L DOOR EMERGENCY EXIT SIGN PER MM 33-51-01.SDR AALA201803129033Lens · missingEMERGENCY AISLE LIGHT LENS AT ROW 24ABC MISSING. INSTALLED A NEW LENS IAW AMM 33-5103.SDR AALA201803129017Lens · detachedAIRCRAFT WAS NOT GROUNDED: MAINTENANCE FOUND EMERGENCY EXIT LENS ON FORWARD GALLEY TABLE. REPLACED EMERGENCY EXIT SIGN AT R1 DOOR AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER MM 33-51-01.SDR AALA201803129011Flashlight · missingAIRCRAFT WAS NOT GROUNDED. CABIN EMERGENCY FLASHLIGHT MISSING AT 4R AISLE JUMPSEAT. INSTALLED NEW FLASHLIGHT AT DOOR 4R JUMPSEAT.SDR AALA20180310004Trim Motor · faultyAIRCRAFT WAS GROUNDED. STABILIZER OUT OF TRIM LIGHT ILLUMINATED AT 4000 FT. NO ELECTRICAL TRIM AVAILABLE WITH AUTO PILOT ON OR OFF. MANUAL TRIM WORKED USING HANDLE. EMERGENCY DECLARED, AIRCRAFT RETURNED TO DFW. AIRCRAFT LANDED OVERWEIGHT AND WITHOUT INCIDENT.SDR AALA201803139032Skin Panel · corrodedAIRCRAFT WAS GROUNDED. LAV VENT SHOWS EVIDENCE OF CORROSION UNDER SKIN. REPAIRED SKIN PER EA 278409.SDR AALA201803129030Lanyard · unsecureFORWARD ENTRY DOOR ESCAPE SLIDE COVER HAS A WIRE PROTRUDING FROM BEHIND. REINSTALLED THE SLIDE PACK LANYARD AND OPS CHECKED NORMAL IAW MM 25-66-00. OK FOR SERVICE.SDR AALA201803129031Access Panel · looseAIRCRAFT WAS NOT GROUNDED: BOTTOM EMERGENCY ACCESS PANEL ON FLIGHT DECK DOOR LOOSE. MAINTENANCE RESET PRESSURE RELEASE LATCH AND INSTALLED DOOR PER AMM 52-51-08 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201803129051Lens · missingEMERGENCY LIGHT LENS ON CEILING AT ROW 19 MISSING. REPLACED THE LENS IAW MM 33-51-03.SDR AALA201803129029Lens · missingEMERGENCY LIGHT LENS ON CEILING AT ROW 17 MISSING. REPLACED THE LENS IAW MM 33-51-03.SDR AALA201803129027Window Shade · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT DOOR WINDOW SHADE 14F BROKEN. MAINTENANCE REPLACED EMERGENCY EXIT DOOR WINDOW SHADE 14F PER AMM 25-21-12 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180307006Intercostal · corrodedCORROSION FOUND ON LOWER LEG OF AN INTERCOSTAL, BS 909 AND STRINGER 25L, LBL 22. REPLACED THE INTERCOSTAL IAW 51-00-05-1.SDR AALA201803089012Lens · missingEMERGENCY LIGHT LENS MISSING ON ROW 15. INSTALLED THE LENS IAW AMM 33-51-03.SDR AALA201803099015Lens · damagedEMERGENCY LIGHT LENS AT THE R1 DOOR WILL NOT STAY ATTACHED. INSTALLED AND SECURED THE EMERGENCY LIGHT LENS IAW AMM 33-51-01.SDR AALA20180307004Transition Panel · corrodedTRANSITION PANEL FROM BS 727 TO 787 AT STRINGER 25L WAS FOUND TO HAVE MULTIPLE AREAS OF CORROSION. REMOVED AND BLENDED OUT DAMAGE. FOUND TO BE BEYOND LIMITS IAW SRM 53-00-53-1A. LEFT TRANSITION PANEL WAS REPLACED IAW SRM 53-00-53-2R.SDR AALA201803089010Lens · defectiveSEAT 15D EMERGENCY LIGHT LENS DEFECTIVE. REPLACED THE LENS IAW AMM 33-51-11.SDR AALA201803089011Lens · detachedTHE AIRCRAFT WAS NOT GROUNDED. AFT LEFT ENTRY DOOR EXIT LIGHT COVER CAME OFF. REMOVED AND REPLACED AFT LEFT ENTRY DOOR EXIT LIGHT LENS IAW AMM 33-51-02.SDR AALA20180306002Angle · corrodedCORRODED LEFT TOP FLANGE CREASE ANGLE BETWEEN BS 974 TO 984. REPLACED THE ANGLE IAW SRM 51-40-02.SDR AALA20180306001Angle · corrodedCORRODED LEFT CREASE ANGLE BETWEEN BS 953 TO 960. REPLACED THE ANGLE IAW 51-00-05-1 AND DRAWING 147A8540.SDR AALA20180305014Stub Frame · crackedR1 DOOR STUB FRAME CRACKED AT A PREVIOUS REPAIR, BETWEEN BS 291 TO 300, STRINGERS 15R AND 17R. REPAIRED THE STUB FRAME IAW SRM 51-70-11-2R.SDR AALA20180306006Transition Panel · corrodedCORROSION FOUND ON THE FORWARD RIGHT TRANSITION PANEL. REPLACED THE TRANSITION PANEL IAW 51-00-05-1.SDR AALA20180306005Strap · corrodedCORROSION WAS FOUND ON THE SUPPORT STRAP LOCATED AT BS 1016 - 1024, RBL 18. REMOVED AND REPLACED THE STRAP IAW DRAWING 147A5715-5, AND 51-00-05.SDR AALA201803069033Sign · inoperativeAIRCRAFT WAS NOT GROUNDED. EXIT SIGN LIGHT AT AFT GALLEY DOOR INOPERATIVE. EVALUATE THE AFT GALLEY LEFT HAND EMERGENCY EXIT LIGHT ASSEMBLY BY L2 DOOR AND REPAIR OR REPLACE AS REQUIRED. REPLACED DAMAGED AFT GALLEY LEFT HAND REAR LOWER EXIT SIGN BY GALLEY DOOR PSDR AALA20180305010Rib · crackedRIGHT HORIZONTAL STABILIZER RIB CRACKED AT HSS 92.7, BETWEEN STIFFENERS 2 & 3 AT THE BOTTOM OF STIIFFNERS. REPAIRED THE RIB IAW 55-10-09.SDR AALA20180305009Angle · corrodedCORROSION FOUND ON THE ANGLE, LBL 32, BETWEEN BS 986 AND 1016. REPLACED THE ANGLE IAW 51-00-05-1 AND PRINT 147A5710.SDR AALA20180305005Floorbeam · corrodedCORROSION WAS FOUND ON THE FLOORBEAM ANGLE, BS 992, BETWEEN RBL 33 AND RBL 46. REPLACED THE FLOORBEAM ANGLE IAW 51-00-05-1, DRAWINGS 147A5710, AND 147A5700.
Back to Boeing 737-823