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 ASAA9980108Wire · brokenSEA - AFTER ARRIVAL OF FLT 483 - CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTING AT ROW 1 WAS DISLODGED FROM TRACK. REPLACED BROKEN WIRES IN FLOOR TRACK ASSEMBLY, REINSTALLED LIGHTING INTO TRACK AND OPERATED NORMALLY. (M)SDR ASAA9980100Light · inoperativeSEA - DURING MAINTENANCE CHECK, ONE EMERGENCY FLOOR TRACK LIGHT AT ROW 20 AND TWO AT ROW 23 WERE FOUND INOPERATIVE. REPLACED LAMP MODULES AND OPERATED NORMALLY. (M)SDR ASAA9980014Wire · damagedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE FOUND INOPERATIVE. REPAIRED WIRING IN FLOOR TRACK AND OPERATED NORMALLY. (X)SDR ASAA9880266Wire · damagedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHTS IN FORWARD CABIN WERE FOUND INOPERATIVE. REPAIRED WIRING IN FLOOR TRACK AND OPERATED NORMALLY. (M)SDR ASAA9880248Mechanism · out of adjustSEA - DURING MAINTENANCE CHECK, THE L2 DOOR WOLD NOT LATCH OPEN. ADJUSTED DOOR HOLD OPEN MECHANISM AND OPERATED NORMALLY. (M)SDR ASAA9880170Bottle · dischargedSEA - PRIOR TO DEPARTURE OF FLT 376, CREW REPORTED THE L1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS LOW. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSY. (M)SDR ASAA9880162Batteries · dischargedSEA - DURING MAINTENANCE CHECK, THE OVERHEAD EMERGENCY LIGHTS FROM ROWS 1 TO 6 WERE FOUND INOPERATIVE. REPLACED THE BATTERIES IN THE POWER SUPPLY AND OPERATED NORMALLY. (M)SDR ASAA9880040Batteries · dischargedSEA - FLT 446 - PRIOR TO DEPARTURE, THE EMERGENCY FLOOR TRACK LIGHTS IN THE FIRST CLASS CABIN WERE INOPERATIVE. REPLACED THE BATTERY PACK AND REPAIRING WIRING IN PART OF SECTION, LIGHTS OPERATED NORMALLY. (M)SDR ASAA9780294Release · lack of lubeSEA - DURING TAILCONE EMERGENCY RELEASE CHECK FROM THE AFT CABIN ENTRY DOOR POSITION, THE TAILCONE FAILED TO RELEASE. LUBRICATED TAILCONE RELEASE MECHANISM AND TAILCONE RELEASED NORMALLY. (M)SDR ASAA9780247Emerg Evac Slide · low pressurePDX - DURING MAINTENANCE CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR ASAA9780108Light · defectiveLAX - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ORJA9780006Power Supply · defectivePDX - DURING MAINTENANCE CHECK, THE EXTERIOR OVERWING EMERGENCY LIGHTS WERE FOUND INOPERATIVE. REPLACED THE POWER SUPPLY AND OPERATED NORMALLY. (M)SDR ASAA9680262Light · defectivePDX - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND DIM. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9680236Light · defectivePDX - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND DIM. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9680079Wire · disconnectedSEA - DURING MAINTENANCE CHECK, FORWARD 4 EMERGENCY EXIT TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. RECONNECTED LIGHTS/WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9580197Hold Open Latch · out of adjustSEA - DURING MAINTENANCE CHECK, THE L1 DOOR HOLD OPEN HOOK WOULD NOT ENGAGE. ADJUSTED HOLD OPEN LATCH AND OPERATED NORMALLY. (M)SDR ASAA9580171Portable Eel · defectiveSFO - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSY AND OPERATED NORMALLY. (M)
Back to N965AS