N959AN
Service difficulty reports · 189
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
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 n_number = 'N959AN' AND registry_match = 'registration' 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 n_number = 'N959AN' AND registry_match = 'registration' 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 AALA202307192950Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202307198968Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202307192880Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202307197774Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202307193004Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202307199127Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202307199470Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202307193532Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202307191912Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202307177555Floor Panel · debondedAIRCRAFT IN BASE MAINTENANCE: CABIN CENTER FLOOR PANEL 242DF UPPER SURFACE DISBONDED. REPLACED FLOOR PANEL.SDR AALA202306294126Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN / CLOSE. **SUPPLEMENTAL REPORT FOR AALA202306284126: MAINTENANCE FOUND DOOR LATCH OUT OF ADJUSTMENT. ADJUSTED AND LUBRICATED DOOR LATCH PER AMM 52-50-00.** (CLOSED)SDR AALA202306284126Unknown · unknownAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN / CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202304174215Circuit Breaker · trippedAIRCRAFT WAS NOT GROUNDED: AIRCRAFT PORT SIDE, SIDE LIGHTS AND EXIT LIGHTS ARE INOPERATIVE. RESET CIRCUIT BREAKER E-12 ON P-92 PANEL. CABIN INTERIOR LIGHTS OPERATIONAL CHECK GOOD PER AMM 33-21-02.SDR AALA202303080316Slide · tornAIRCRAFT WAS GROUNDED: R1 SERVICE DOOR ESCAPE SLIDE GIRT TORN APPROXIMATELY 1 INCH LONG ON FORWARD. SIDE JUST BELOW GIRT BAR. INSTALLED NEW SLIDE ONTO R1 DOORSDR AALA202210056859Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTS NOT ARMED LIGHT 1 BULB INOPERATIVE. RELAMPED 1 EACH BULB IN LIGHT ASSEMBLY PER AMM 33-18-00.SDR AALA202209194393Solenoid · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DOES NOT LATCH SECURELY AND CAN BE PULLED OR PUSHED OPEN WHEN SHUT. REMOVED AND REPLACED COCKPIT DOOR ELECTRIC STRIKE ASSEMBLY IN ACCORDANCE WITH AMM 52-51-03.SDR AALA202209128124None · stickingAIRCRAFT WAS NOT GROUNDED: 1R GIRT BAR RETAINER CLIP TO TIGHT FOR USE. LOOSENED UP CLIPS PER AMM 25-66-02.SDR AALA202206027473Rib · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER INSPAR RIB 1 CRACKED, LOCATED AT STABILIZER STA 101.90. REPAIRED RIB PER SRM 55-10-09-2R PROCEDURE 4 REPAIR 4.SDR AALA202206163809Bracket · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK TRAILING EDGE SUPPORT BRACKET BETWEEN WS 278.50 AND WS 302.50 AT RIGHT WING. REPLACED TRAILING EDGE SUPPORT BRACKET BETWEEN WS 278.50 AND 302.50 AT RT WING PER B737-NG SRM 51-40-02-0G.SDR AALA202205137482Hydraulic Line · leakingAIRCRAFT WAS GROUNDED: ON TAKEOFF ENGINE # 1 HYDRAULIC LOW PRESSURE LIGHT ILLUMINATED. EMERGENCY DECLARED, RETURNED TO DFW LANDING SAFELY. REPLACED # 1 ENGINE DRIVEN PUMP HYDRAULIC PRESSURE LINE PER AMM 29-11-11. OPERATIONAL CHECK GOOD PER AMM 71-00-00.SDR AALA202204019163Light · unsecureAIRCRAFT WAS NOT GROUNDED: SEAT 19C EMERGENCY LIGHT ON AISLE LIGHT DISCONNECTED. RE SECURED EMERGENCY LIGHT TRIM PER AMM 25-22-00.SDR AALA202203294614Fastener · looseAIRCRAFT WAS NOT GROUNDED: BOTH FASTENERS ON AFT GALLEY SERVICE DOOR SLIDE PACK ARE LOOSE. RE-SECURED FASTENERS PER AMM 25-66-11.SDR AALA202203233623Latch · noneAIRCRAFT WAS GROUNDED: DOOR 1L SLIDE FELL OUT OF HOLDER / COVER UPON DOOR OPENING AT GATE ARRIVAL. REPLACED THE SLIDE GIRT BAR LATCH ASSEMBLY PER AMM 25-66-01-000-804. REINSTALLED DOOR 1L SLIDE ASSEMBLY PER AMM 25-66-01-000-802.SDR AALA202112276535Control Cable · lack of lubeAIRCRAFT WAS GROUNDED: AILERONS SEEMS "STIFFER " THAN NORMAL 190 KNOTS FLAPS 5 TO 30 RESPONSE TIME IN MOVEMENT SLOWER THAN NORMAL. POST FLIGHT CONTROL CHECK SEEMED STIFFER TOO. ACCOMPLISHED INSPECTION AND LUBRICATION ON CONTROL CABLES AND FEEL CENTERING UNISDR AALA202112150192Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: 1L GIRT BAR LOOSE/FALL OUT. ADJUSTED L1 DOOR GIRT BAR PER AMM 5-66-01.SDR AALA202112139516Actuator · stiffAIRCRAFT WAS GROUNDED: ON APPROACH AILERONS STIFF TO TURN AILERONS OFFER INTERMITTENT STIFFNESS WHEN TURNING BOTH DIRECTIONS. REMOVED AND REPLACED AILERON TRIM ACTUATOR PER AMM 27-11-54.SDR AALA202110126218None · looseAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR 1R GIRT BAR CLIP IS LOOSE. BENT FWD ENTRY GIRT BAR CLIP TO CONFORM PER AMM 25-66-01.SDR AALA202110123381None · brokenAIRCRAFT WAS GROUNDED: PASSENGER SEAT AT SEAT 18C ESCAPE PATH LIGHT LOOSE. REPLACED BROKEN TRIM AT SEAT 18C PER AMM 33-51-00.SDR AALA202110119067Housing · out of positionAIRCRAFT WAS NOT GROUNDED: PLASTIC COVER FOUND ON FLOOR AT SEAT 27. REMOVED AND REPLACED EMERGENCY LIGHT HOUSING AT 27C PER AMM 33-51-11.SDR AALA202108174945Wire · brokenAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT AT SEAT 10C WIRE BROKEN. REPAIRED WIRE PER BOEING STANDARD WIRING PRACTICES MANUAL 20-30-12.SDR AALA202108165790Light · damagedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT AT SEAT 13C DAMAGED. REPLACED LIGHT ASSEMBLY PER CMM 25-23-67.SDR AALA202108161119Light · damagedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT AT SEAT 10C DAMAGED. REPLACED LIGHT ASSEMBLY PER CMM 25-23-67.SDR AALA202108095790Light · damagedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT AT SEAT 13C DAMAGED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202108091119Light · damagedAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT AT SEAT 10C DAMAGED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202107260487Shroud · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY AISLE LIGHT IS HANGING BY ITS WIRES AT SEAT 20C. REMOVED AND REPLACED SHROUD IAW CMM 25-23-67.SDR AALA202107263374Shroud · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY AISLE LIGHT IS HANGING BY ITS WIRES AT SEAT 15C. REMOVED AND REPLACED SHROUD IAW CMM 25-23-67SDR AALA202107260283Shroud · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVER IS OFF AT SEAT 14C. **SUPPLEMENTAL FOR AALA202107200283: REPLACED SHROUD PER CMM 25-23-67.** (CLOSED)SDR AALA202107266091Shroud · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVER IS OFF AT SEAT 19C. **SUPPLEMENTAL FOR AALA202107206091: REPLACED SHROUD PER CMM 25-23-67.** (CLOSED)SDR AALA202107261523Shroud · out of positionAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER IS OFF AT SEAT 10C. **SUPPLEMENTAL REPORT FOR AALA202107211523: REMOVED AND REPLACED SHROUD PER CMM 25-23-67.** (CLOSED)SDR AALA202107211523Lens · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER IS OFF AT SEAT 10C. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202107200283Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVER IS OFF AT SEAT 14C. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202107206091Cover · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT COVER IS OFF AT SEAT 19C. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN)SDR AALA202106219022Light · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT 28C HANGING FROM SIDE OF SEAT. RE INSTALLED EMERGENCY LIGHT AT SEAT 28C PER AMM 33-15-02.SDR AALA202106159006Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: R2 DOOR EXTERIOR EMERGENCY LIGHT NOT ILLUMINATING. RELAMPED R2 DOOR EXTERIOR EMERGENCY LIGHT IAW B737 AMM 33-51-04-960-801, OPS CHECK GOOD.SDR AALA202106308371Floorbeam · damagedAIRCRAFT IN BASE MAINTENANCE: DAMAGE PLUG HOLE ON FLOOR BEAM LOCATED AT STA 907 AND RBL 55.8. REPAIRED FLOOR BEAM PER EA 328186 AND SRM 51-40-02.SDR AALA202103319019Switch · dirtyAIRCRAFT IN BASE MAINTENANCE: RT FWD OVERWING EMERGENCY EXIT DOOR WARNING SWITCH INOPERATIVE. CLEANED WARNING SWITCH IAW B737NG AMM 20-00-02, OPS CHECK GOOD.SDR AALA202008219009Sign · missingAIRCRAFT WAS NOT GROUNDED: CABIN ENTRY DOOR 4R EMERGENCY EXIT LIGHT/SIGN DAMAGED/MISSING. INSTALLED CABIN ENTRY DOOR SIGN AT DOOR 4R.SDR AALA2020032329014Unknown · malfunctionedAIRCRAFT NOT GROUNDED: FUEL BURNING OUT OF WINGS PRIOR TO EXHAUSTING CENTER TANK FUEL. FUEL LOAD WAS 29K. WITH 19.8 INBOARD, LEFT WAS 8.3, RIGHT 7.5 AND CENTER STILL HAD 3.87. TURNED CENTERS OFF IN FLIGHT MOMENTARILY TO X-FEED AND AVOID WING TANKS EXCEEDING SDR AALA202002219025Retainer · misalignedAIRCRAFT NOT GROUNDED: 2R SLIDE COMING OUT HARD TO ARM GIRT BAR. REALIGNED GIRT BAR RETAINER IAW AMM 25-66-00.SDR AALA202001169002Pump · malfunctionedAIRCRAFT WAS GROUNDED: IN CRUISE WITH ALL FUEL PUMPS ON AND FUEL IN CENTER TANK, AIRCRAFT BEGAN BURNING FUEL FROM RIGHT TANK. SUPPLEMENTAL REPORT: ACCOMPLISHED BITE OF UFI PER FIM 28-22-00-810-822 SHOWED NO FAULTS. RE-PRIMED PUMP PER AMM 28-22-41. OPERATIONAL
Back to N959AN