N966AN
Service difficulty reports · 248
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 = 'N966AN' 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 = 'N966AN' 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 AALA20130424008Bracket · damagedRIGHT ENGINE FIRE BARRIER BRACKET INBOARD SIDE IS DAMAGED JUST BELOW PYLON TORQUE BOX, 8 INCHES AFT OF EXHAUST NOZZLE SEPARATION FLANGE. REPLACED FIRE BARRIER BRACKET PER SRM 51-40-02-0G.SDR AALA20130424013Skin · crackedEXTERNAL POWER SERVICE PANEL CUTOUT AFT EDGE CRACKED. INSTALLED DOUBLER PER SRM 53-10-15-2R-4.SDR AALA20130424007Angle · crackedFORWARD CARGO BAY INTERCOSTAL ANGLE CRACKED AT BODY STATION 500E AND RIGHT BUTTLINE 24. REPLACED ANGLE (CLIP) PER SRM 51-40-02-0G.SDR AALA20130423014Support · corrodedCORROSION ON FORWARD CARGO BAY RIGHT FLOOR TO BULKHEAD SUPPORT SURFACE, BODY STATION 500I, LEFT TO RIGHT BUTTLINE 24. REPLACED FORWARD CARGO BAY FLOOR TO BULKHEAD SUPPORT PER AARD 51-00-05-1.SDR AALA20130423010Stabilizer · corrodedCORROSION ON G4 GALLY FLOOR STABLIZER FROM STATIONS 987 TO 1007 RIGHT BUTTINE 12 AND WATERLINE 208.5. REPLACED FLOOR STABLIZER PER SOPM 20-50-01.SDR AALA20130423008Stabilizer · corrodedCORROSION ON G4 GALLY FLOOR STABILIZER FROM STATIONS 987 TO 1007 LEFT BUTTLINE 12 AND WATERLINE 208.5. REPLACED STABILIZER FITTING ASSEMBLY PER SOPM 20-50-01.SDR AALA20130423007Stringer Clip · corrodedCORROSION ON STRINGER CLIP AT BODY STATION 907 AND STRINGER 27 LEFT. REPLACED CLIP PER AARD 51-10-05-1.SDR AALA20130422030Plate · damagedRIGHT WING PANEL 651GB WIGGLE PLATE ATTACH FASTENERS ARE PULLED THROUGH. REPLACED PLATE PER SRM 51-40-02.SDR AALA20130422027Stringer Clip · corrodedCORROSION ON STRINGER CLIP AT BODY STATION 807 AND STRINGER 26 LEFT. REPLACED CLIP PER SRM 51-40-05-0G, BOEING DWG 146A1263, SM 51-40-02-0G AND AARD 51-10-05-1.SDR AALA20130422023Stringer Clip · corrodedCORROSION ON STRINGER CLIP AT BODY STATION 787 AND STRINGER 26 LEFT. REPLACED CLIP PER SRM 51-40-05-0G, BOEING DWG 146A1262, SRM 51-40-02-0G AND AARD 51-10-05-1.SDR AALA20130422008Support · crackedSEAL SUPPORT AT RSS 272 AT UPPER TRAILING EDGE PANEL IS CRACKED. REPLACED LEFT WING SEAL SUPPORT AT RSS 272 PER SRM 51-40-02-0G.SDR AALA20130419012Angle · crackedLEFT WING TRAILING EDGE UPPER PANEL SUPPORT CRACKED AT INBOARD FLAP OUTBOARD DEFLECTION CONTROL ROLLER BEAM. REPLACED CRACKED ANGLE PER SRM 51-40-02-0G.SDR AALA20130419015Angle · crackedFORWARD CARGO BAY INTERCOSTAL ANGLE IS CRACKED AT BODY STATION 500E, LEFT BUTTLINE 24, FORWARD SIDE OF FRAME. REPLACED CLIP PER AARD 51-00-05-01.SDR AALA20130419011Support · crackedSEAL SUPPORT AT RSS 272 INBOARD FIXED BULKHEAD ON RIGHT WING CRACKED. REPLACED SEAL SUPPORT PER SRM 51-40-02-0G.SDR AALA20130419009Crease Beam · corrodedRIGHT CREASE BEAM AT STATION 984, RIGHT BUTTLINE 48 AND WATERLINE 208 CORRODED. REPLACED SILL CHORD PER AARD 51-00-05.SDR AALA20130418008Frame · crackedBODY STATION 480 RIGHT FRAME IS CRACKED AT STRINGER 8 AIR CONDITIONING SUPPORT BRACKET. REPAIRED FRAME PER ECO J1159AE-0009.SDR AALA20130418007Frame · crackedBODY STATION 480 LEFT FRAME IS CRACKED AT AIR CONDITIONING SUPPORT BRACKET. REPAIRED FRAME PER ECO J119AE-0008.SDR AALA20130418005Angle · corrodedCORROSION ON ANGLE ATTACHED TO RIGHT NUMBER 1 DOOR MOP SEAL. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA20130418004Intercostal · crackedCRACKED FLOOR INTERCOSTAL FROM BODY STATIONS 312 TO 328, RIGHT BUTTLINE 30 AND WATERLINE 208. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20130417013Intercostal · crackedCRACKED INTERCOSTAL FROM BODY STATIONS 312 TO 328, LEFT BUTTLINE 6 AND WATERLINE 208. REPLACED INTERCOSTAL PER AARD 51-00-05.SDR AALA20130417011Intercostal · crackedCRACKED INTERCOSTAL FROM BODY STATIONS 328 TO 344, LEFT BUTTLINE 46 AND WATERLINE 208. REPLACED INTERCOSTAL PER AARD 51-00-05.SDR AALA20130417007Angle · crackedCRACKED ANGLE AT FORWARD GALLEY DOORWAY, FORWARD FRAME (FORWARD SIDE) TO MOPSILL, BODY STATION 294.5, RIGHT BUTTLINE 54 AND WATERLINE 208. REPLACED CRACKED ANGLE PER AARD 51-00-05.SDR AALA20130417006Shear Web · corrodedCORROSION ON SHEAR WEB AT MAIN CABIN FLOOR AT STATION 986 RIGHT BUTTLINE 32 AND WATERLINE 208. REMOVED WEB AND INSTALLED NEW WEB FROM BODY STATIONS 986 TO 1016 AND RIGHT BUTTLINES 32 TO 45 PER AARD 51-00-05.SDR AALA20130417005Vapor Barrier · damagedRIGHT AC BAY AFT BULKHEAD VAPOR BARRIER DAMAGED IN BAY 2. ACCOMPLISHED BONDED REPAIR PER SRM 51-70-04-2R AND SRM 51-70-04-2R-10.SDR AALA20130417004Vapor Barrier · damagedRIGHT AC BAY AFT BULKHEAD VAPOR BARRIER DAMAGED IN BAY 1. ACCOMPLISHED BONDED REPAIR PER SRM 51-70-04-2R-10 AND SRM 51-70-04-2R.SDR AALA20121031001Rib · crackedLOWER FORWARD OUTBOARD CORNER OF RIB NUMBER 10 CRACKED (WHERE RIB OVERLAPS LOWER ANGLE OF FRONT SPAR). INSTALLED REPAIR STRAP PER EA B737-55-026751.SDR AALA20120828003Connector · looseEMERGENCY LIGHT AT 24D INOPERATIVE. RE-SECURED CONNECTOR AT 24D SIDEWALL. OPS CHECK NORMAL.SDR AALA20120717001Battery Pack · dischargedEMERGENCY LIGHTS FROM ROWS 15 TO 21 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS FROM ROWS 15 TO 21. OPS CHECK NORMAL.SDR AALA20100727MIA02Battery Pack · dischargedEMERGENCY LIGHTS IN CABIN INOPERATIVE. REPLACED BATTERY PACK FOR CABIN EMERGENCY LIGHTS. OPS CHECK NORMAL.SDR AALA20100727MIA03Battery Pack · dischargedRIGHT AND WING OVERWING EXIT LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR RIGHT WING OVERWING EXIT LIGHT. OPS CHECKED NORMAL.SDR AALA20100727MIA01Battery Pack · dischargedROW 13 THRU 21 EMERGENCY EXITS LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY EXIT LIGHTS FOR ROWS 13 THRU 21. OPS CHECKED NORMAL.SDR AALA20100322TUL14Transmitter · faultyGUA - CREW REPORTED LEFT ENGINE OIL FILTER BYPASS LIGHT ILLUMINATED. ENGINE RETARDED THROTTLE AND LIGHT DID NOT EXTINGUISH. CREW SHUTDOWN ENGINE (SINGLE ENGINE TIME 5 MINUTES). EMERGENCY DECLARED FLIGHT RETURNED GUA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVESDR AALA20100323GUA01Transmitter · inoperativeGUA - CAPTAIN REPORTED LEFT ENGINE OIL FILTER BYPASS LIGHT ILLUMINATED ON CLIMB. LEFT ENGINE SHUTDOWN PER QRH. SINGLE ENGINE TIME 5 MINUTES. EMERGENCY DECLARED RETURNED GUA LANDED WITHOUT INCIDENT. REPLACED CLOGGING TRANSMITTER AND LEFT ENGINE OIL FILTER ESDR AALA2009052300001Window · crackedMIA - INFLIGHT FLL-KIN. LEFT NUMBER 1 WINDOW CRACKED DURING FLIGHT. EMERGENCY DECLARED, LANDED MIA WITHOUT INCIDENT. REMOVED AND REPLACED LEFT NUMBER 1 WINDOW. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA2009032500656Lens · missingATL - EMERGENCY EXIT LIGHT AT ROW 13ABC MISSING LENS. REPLACED LENS FOR EMERGENCY EXIT LIGHT AT ROW 13ABC.SDR AALA200800543Actuator · inoperativeMIA INFLIGHT T592/10MAR - BOTH CAPTAIN AND FIRST OFFICERS STABILIZER TRIM INOPERATIVE. RETURNED MIA AND LANDED WITHOUT INCIDENT. REPLACED HORIZONTAL STABILIZER TRIM ACTUATOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800495Lens · brokenMIA - EMERGENCY LIGHT AT SEAT ROW 28 HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 28. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800494Shroud · brokenMIA - EMERGENCY LIGHT AT SEAT ROW 28 HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 28. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800493Lamp · inoperativeMIA - EMERGENCY LIGHT AT SEAT ROW 28 INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 28. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800492Lens · brokenMIA - EMERGENCY LIGHT AT SEAT ROW 27 LENS BROKEN. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 27. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800491Shroud · brokenMIA - EMERGENCY LIGHT AT SEAT ROW 27 HAS BROKEN SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 27. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800490Lamp · inoperativeMIA - EMERGENCY LIGHT AT SEAT ROW 27 INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 27. SYSTEM GROUND CHECKED NORMAL OPERATIONSDR AALA20072256Light · inoperativeMIA - EMERGENCY LIGHT AT SEAT ROW 14DEF DOOR SIDE WALL INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT ROW 14DEF DOOR SIDE WALL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071880Connector · disconnectedDFW - EMERGENCY LIGHT AT SEAT ROW 22DEF INOPERATIVE. SECURED PIN UNDER J BOX FOR EMERGENCY LIGHT AT LEFT OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071424Connector · looseMIA - EMERGENCY LIGHT AT SEAT ROW 22D INOPERATIVE. SECURED CONNECTOR FOR EMERGENCY LIGHT AT SEAT ROW 22D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060844Lanyard · out of positionTUL - WHEN OPENED DOOR SLIDE DEPLOYED BUT RIGHT FORWARD DOOR WOULD NOT OPEN COMPLETELY DUE TO INFLATION BOTTLE LANYARD CAUGHT IN THE DOOR LATCH BRACKET. INSTALLED NEW EMERGENCY SLIDE PACK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050310Battery Pack · inoperativeTUL - TWO EMERGENCY EXIT LIGHT BATTERY PACKS AT CABIN SIDEWALL DOES NOT HOLD CHARGE. REPLACED BATTERY PACKS AT CABIN SIDEWALL FOR EMERGENCY EXIT LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20040018Connector · looseEMERGENCY LIGHT AT SEAT 20D INOPERATIVE. RESEAT CONNECTOR AT 20D EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.--CLOSED--
Back to N966AN