N965AS
Service difficulty reports not matched to an aircraft · 167
They name N965AS, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. 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 = 'N965AS' AND registry_match IS NULL 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 = 'N965AS' AND registry_match IS NULL 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 ASAA0580120Floor Panel · delaminatedOKC HV-CHECK - CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (NM02200500849) (K)SDR ASAA0580119Floor Panel · delaminatedOKC HV-CHECK - CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (NM02200500849) (K)SDR ASAA0580118Floor Panel · delaminatedOKC HV - CHECK - CABIN FLOOR PANEL IS DELAMINATED. REPLACED FLOOR PANEL. (NM02200500849) (K)SDR ASAA0580117Floor Panel · damagedOKC HV- CHECK - CABIN FLOOR PANEL IS WATER DAMAGED AND HAS CORRODED FASTENERS. REPLACED FLOOR PANEL. (NM02200500849) (K)SDR ASAA0580114Floor Panel · corrodedOKC HV-CHECK - CABIN FLOOR PANEL HAS CORRODED AND CRACKED FASTENERS. REPLACED FLOOR PANEL. (NM02200500849) (K)SDR ASAA0580113Floor Panel · corrodedOKC HV- CHECK FLOOR PANEL HAS CORRODED FASTENERS. REPLACED FLOOR PANEL. (NM02200500849) (K)SDR ASAA0580112Channel · debondedOKC HV - CHECK - CABIN FLOOR PANEL HAT CHANNEL DISBONDED. BOND REPAIRED. (K)SDR ASAA0580111Channel · dentedOKC HV-CHECK - CABIN FLOOR PANEL HAT CHANNEL DENTED. REPLACED CHANNEL. (K)SDR ASAA0580091Lanyard · brokenOKC - HV-CHECK, FORWARD PAX (L-1) DOOR EMERGENCY EXIT SLIDE FAILED TO DEPLOY DURING TEST PER TASKCARD 28425002 STEP 2. THE CAUSE WAS DETERMINED TO BE A BROKEN GIRT BAR-TO-SLIDE COVER LATCH LANYARD. IT WAS BROKEN AT THE LATCH END. THE ENTIRE EMERGENCY SLIDE SDR ASAA0480394Module · disconnectedPDX - DURING PREFLIGHT CHECK, FOUND EMERGENCY TRACK LIGHTS INOPERATIVE AT ROW 32. RECONNECTED LOOSE MODULE CONNECTOR. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0480340Vane · damagedFOUND DURING C-CHECK, LEFT OUTBOARD FLAP INBOARD VANE ACCESS PANEL IS CREASED. REPLACED FLAP VANE PANEL PER SRM 51-10-4 AND 51-30-1. (M)SDR ASAA0480339Floor Panel · corrodedOKC - FOUND DURING C-CHECK, PASSENGER CABIN FLOOR PANEL HAS CORRODED INSERTS AT FS 200-256. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480338Floor Panel · corrodedOKC - DURING C-CHECK, FOUND PASSENGER CABIN FLOOR PANEL IS CRACKED AT FS 200-256. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480341Frame · gougedDURING C-CHECK, FOUND LEFT VENTRAL AFT ACCESSORY COMPARTMENT FRAME IS GOUGED AND CHAFED. REPAIRED DAMAGED AREAS PER EA 5310-02342. (M)SDR ASAA0480342Panel · corrodedDURING C-CHECK, FOUND AFT WING FILLET PANEL 2208C BETWEEN ATTACH RUB STRIP AND FUSELAGE SKIN IS CORRODED. REMOVED DAMAGED AREA AND INSTALLED DOUBLER PER SRM 53-04. (M)SDR ASAA0480337Floor Panel · corrodedOKC - DURING C-CHECK, FOUND PASSENGER CABIN FLOOR PANEL HAS BROKEN AND CORRODED INSERTS AT FS 160-120. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480334Floor Panel · crackedOKC - FOUND DURING C-CHECK, PASSENGER CABIN FLOOR PANEL HAS SEVERAL CRACKED INSERTS. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480333Floor Panel · crackedOKC - FOUND DURING C-CHECK, PASSENGER CABIN FLOOR PANEL HAS SEVERAL CRACKED AND MISSING INSERTS. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480332Floor Panel · crackedOKC - FOUND DURING C-CHECK, PASSENGER CABIN FLOOR PANEL HAS DISBONDED AT FS 160-200. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480331Floor Panel · crackedOKC - FOUND DURING C-CHECK, PASSENGER CABIN FLOOR PANEL HAS DISBONDED AND HAS CRACKED EDGE AT FS 160-180. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480330Floor Panel · corrodedOKC - FOUND DURING C-CHECK, PASSENGER CABIN FLOOR PANEL HAS CORRODED INSERTS AND COMPOSIT DAMAGE AT CORNER AT FS 160-200. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480329Floor Panel · corrodedOKC - FOUND DURING C-CHECK, PASSENGER CABIN FLOOR PANEL HAS CORRODED INSERTS AND HOLES NEAR FORWARD ENTRY AT FS 160-200. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480328Web · gougedFOUND C-CHECK, LEFT VENTRAL AFT ACCESSORY COMPARTMENT FRAME, WEB, GOUGED AT FS 1380. REPLACED WEB PER SRM 51-70-4. (M)SDR ASAA0480336Floor Panel · corrodedOKC - FOUND DURING C-CHECK, PASSENGER CABIN FLOOR PANEL HAS BROKEN AND CORRODED INSERTS AT FS 160-120. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480335Floor Panel · crushedOKC - FOUND DURING C-CHECK, PASSENGER CABIN FLOOR PANEL IS CRUSHED IN SEVERAL LOCATIONS AT FS 140-160. REPLACED FLOOR PANEL PER SRM 53-05. (M)SDR ASAA0480269Lanyard · misriggedOKC C-CHECK, AFT SERVICE DOOR EMERGENCY SLIDE FAILED TO DEPLOY DURING DEPLOYMENT TEST. SUSPECT MIS-RIGGED LANYARD, BUT INVESTIGATION IS UNDERWAY TO MORE DEFINITIVELY DETERMINE CAUSE. MFG (ENG-G DOC 3053)- MIS-RIGGING APPEARS TO HAVE BEEN IMPROPER FOLDING OF SDR ASAA0480072Light · inoperativeSEA - DURING PREFLIGHT CHECK, FOUND COCKPIT OVERHEAD STANDBY EMERGENCY LIGHT FOUND INOPERATIVE. REPLACED LIGHT SOCKET. LIGHT THEN OPERATED PROPERLY. (M)SDR ASAA0380636Lanyard · disconnectedLINE CHECK, FOUND FORWARD PAX L1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR ASAA0380544Lanyard · disconnectedPREFLIGHT CHECK, FORWARD PAX ENTRY L-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR ASAA0380134Light · inoperativeSEA - DURING PREFLIGHT CHECK, EMERGENCY TRACK LIGHTING WAS FOUND TO BE INOPERATIVE FORWARD OF ROW 2. REPLACED DAMAGED CONNECTOR SEGMENT. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0380104Wire · brokenSJC - PREFLIGHT CHECK, EMERGENCY TRACK LIGHTING IN FIRST CLASS WAS FOUND INOPERATIVE. REPAIRED BROKEN WIRE. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0380100Heat Exchanger · cloggedOAK - HOT INSULATION ODOR AND BLUE HAZE IN CABIN WITH APU ON AND AIR CON PACKS ON. REPLACED BOTH PRIMARY AND SECONDARY (P/N 18406032, S/N 46-5085) HEAT EXCHANGERS, BOTH HAD INGESTED INSULATION BLANKET MATERIAL. OPS CHECK OK. (M)SDR ASAA0380094Frame · corrodedOKC - FOUND DURING C-CHECK, AFT LOWER FLANGE FRAME CORRODED AT FS 1231. REPLACED DAMAGED SECTION OF FRAME PER SRM 53-03. (M)SDR ASAA0380093Angle · crackedOKC - FOUND DURING C-CHECK, VERTICAL ANGLE IN RIGHT WHEEL WELL IS CRACKED AT FORWARD INBOARD LOWER CORNER. REPLACED ANGLE PER SRM 51-30-5. (M)SDR ASAA0380091Cargo Track · corrodedOKC - FOUND DURING C-CHECK, AFT CARGO BAY TIEDOWN BRACKET IS CORRODED. REPLACED BRACKET PER SRM 51-30-5. (M)SDR ASAA0380090Spacer · corrodedOKC - FOUND DURING C-CHECK, AFT CARGO BAY DOOR LOWER BEAM SPACER IS CORRODED. REPLACED EXISTING DOUBLER PER SRM 51-30-5 AND 53-05. (M)SDR ASAA0380092Cargo Track · corrodedOKC - FOUND DURING C-CHECK, AFT CARGO BAY FLOOR TRACK CORRODED AT FASTENER HOLES. REPLACED FLOOR TRACK PER SRM 53-05 AND 51-10-3. (M)SDR ASAA0380087Skin · crackedOKC - FOUND C-CHECK, AFT CARGO BAY BARRIER DOOR INTERNAL SKIN IS CRACKED 1.25 INCH. INSTALLED FILLER AND DOUBLER PER SRM 51-70-2. (M)SDR ASAA0380086Cargo Track · corrodedOKC - FOUND DURING C-CHECK, AFT CARGO BAY TIEDOWN TRACK IS CORRODED AROUND FASTENER HOLES. REPLACED TRACK PER SRM 51-10-4 AND 51-30-1. (M)SDR ASAA0380085Skin · crackedOKC - FOUND DURING C-CHECK, FORWARD CARGO BAY BARRIER DOOR SKIN CRACKED. INSTALLED FILLER AND DOUBLER PER SRM 51-70-2. (M)SDR ASAA0380084Clip · crackedOKC - FOUND DURING C-CHECK, AFT CARGO BAY BRACKET ANGLE CLIP CRACKED. REPLACED CLIP PER SRM 51-30-1. (M)SDR ASAA0380082Torque Box · corrodedOKC - FOUND DURING C-CHECK, TORQUE BOX WEB UPPER SURFACE CORRODED AT FS 1212. REPLACED WEB SECTION PER SRM 51-70-4. (M)SDR ASAA0380081Angle · corrodedOKC - FOUND DURING C-CHECK, AFT CARGO BAY AFT BULKHEAD PANEL MOUNTING STRAP ATTACH ANGLE CORRODED. REPLACED ANGLE PER SRM 51-10-2 AND 51-30-5. (M)SDR ASAA0380079Cargo Track · corrodedOKC - FOUND DURING C-CHECK, AFT CARGO BAY LEFT TRACK IS CORRODED AT FS 1079-1222. REPLACED TRACK PER SRM 53-05. (M)SDR ASAA0380080Hinge · crackedOKC - FOUND DURING 30K CHECK, FORWARD CARGO BAY BARRIER DOOR HINGE IS CRACKED. REPLACED HINGE PER SRM 51-30-1. (M)SDR ASAA0380083Floorboard · puncturedOKC - FOUND DURING C-CHECK, FORWARD CARGO BAY NR 4 FLOORBOARD PUNCTURED AND CORRODED. REPLACED FLOOR PANEL PER SRM 51-10-4. (M)SDR ASAA0380077Access Panel · crackedOKC - FOUND DURING C-CHECK, ACCESS PANEL BENEATH SEAT IN COCKPIT IS BENT AND TORN. INSTALLED DOUBLER PER SRM 53-01. (M)SDR ASAA0380076Hinge · crackedOKC - FOUND DURING C-CHECK, MID CARGO BAY BARRIER DOOR HINGE IS CRACKED. REPLACED HINGE PER SRM 51-10-3, 51-10-4, AND 51-30-1. (M)SDR ASAA0380075Plate · crackedOKC - FOUND DURING C-CHECK, MID CARGO BAY DOOR LOWER SCUFF PLATE IS CRACKED. CUT OUT AND REPLACED DAMAGED AREA PER SRM 53-01. (M)SDR ASAA0380073Frame · corrodedOKC - FOUND DURING C-CHECK, FRAME CORRODED IN AFT CARGO BAY. REPLACED FRAME SEGMENT PER SRM 51-30-2 AND 51-30-5. (M)
Back to N965AS