N975AS, cancelled Jul 7, 2015
Service difficulty reports · 211
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 = 'N975AS' AND deregistration_id = 'N975AS-2015-07-07' 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 = 'N975AS' AND deregistration_id = 'N975AS-2015-07-07' 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 ASAA0180309Lanyard · disconnectedLAX - DURING PREFLIGHT CHECK, L-2 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DETACHED FROM SLIDE COVER. REATTACHED LANYARD TO SLIDE COVER. (M)SDR ASAA0180265Battery Pack · dischargedGEG - DURING PREFLIGHT CHECK, DETERMINED EMERGENCY TRACK LIGHTING TO BE INOPERATIVE FROM ROWS 13 TO 21. REPLACED ASSOCIATED BATTERY POWER SUPPLY PACK. LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0180225Lanyard · disconnectedSEA - DURING PRE-FLIGHT CHECK, GALLEY SERVICE DOOR EMERGENCY SLIDE LANYARD WAS FOUND TO BE DETACHED FROM THE SLIDE COVER. REATTACHED LANYARD BETWEEN GIRT BAR AND DOOR SLIDE COVER. (M)SDR ASAA0180212Module · disconnectedSEA - DURING PRE-FLIGHT CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS DISCONNECTED AT ROW 7. RECONNECTED LIGHT MODULE SOCKET. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0180209Module · disconnectedSEA - DURING PRE-FLIGHT CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS DISCONNECTED AT ROW 7. RECONNECTED LIGHT MODULE SOCKET. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0180195Light · inoperativeLAX - PRIOR TO FLIGHT, THE EMERGENCY FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE AT ROW 7. SECURED FLOOR TRACK LIGHTING AT ROW 7. LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0180187WindowANC - DURING PREFLIGHT CHECK, IT WAS DETERMINED THAT THE FIRST OFFICERS SLIDING CLEARVIEW WINDOW COULD NOT BE OPENED. ADJUSTED SLIDER MECHANISM. WINDOW THEN OPERATED PROPERLY. (M)SDR ASAA0180177Wire · disconnectedPHX - PRIOR TO FLT 711 - THE EMERGENCY FLOOR TRACK LIGHTS AT ROW 6 WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING TO LIGHT ASSEMBLY AND THE LIGHTS OPERATED NORMALLY. (M)SDR ASAA0180175Wire · disconnectedSJC - PRIOR TO FLT 319 - THE EMERGENCY FLOOR TRACK LIGHT COVER WAS FOUND TO BE MISSING AND THE LIGHTS INOPERATIVE AT ROW 7. INSTALLED MISSING COVER AND RECONNECTED WIRING TO LAMP MODULE AT ROW 7, LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0180147Light · disconnectedPDX - DURING LINE CHECK, EMERGENCY FLOOR TRACK LIGHTING AT ROWS 6 THROUGH 8 WERE DETERMINED TO BE INOPERATIVE. RECONNECTED TRACK LIGHT ASSEMBLIES. TRACK LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0180129Light · inoperativeSEA - DURING LINE CHECK, FORWARD CABIN PORTABLE EMERGENCY LIGHT WAS DETERMINED TO BE INOPERATIVE. REPLACED LIGHT ASSEMBLY. LIGHT THEN OPERATED NORMALLY. (M)SDR ASAA0180097Wire · brokenSEA - DURING CRUISE, TRACK LIGHTING CAME ON FOR A MOMENT. A CHECK OF THE EMERGENCY FLOOR TRACK LIGHTS FOUND THE LIGHTS AT ROWS 22 TO 24 INOPERATIVE. REPAIRED BROKEN WIRES. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0180085Window · inoperativeLAX - DURING PREFLIGHT CHECK, CAPTAINS SLIDING CLEARVIEW WINDOW WAS FOUND TO BE DIFFICULT TO CLOSE. LUBRICATED WINDOW. WINDOW THEN OPERATED PROPERLY. (M)SDR ASAA0180050Light · inoperativeSEA - DURING LINE CHECK, EMERGENCY FLOOR TRACK LIGHTING MODULE WAS DETERMINED TO BE BROKEN IN TAILCONE AREA. REPLACED BROKEN EMERGENCY FLOOR TRACK LIGHTING MODULE. LIGHT THEN OPERATED PROPERLY. (M)SDR ASAA0180016Light · inoperativeSEA - DURING LINE CHECK, PORTABLE EMERGENCY LIGHT WAS DETERMINED TO BE INOPERATIVE. REPLACED PORTABLE EMERGENCY LIGHT. LIGHT OPERATED PROPERLY. (M)SDR ASAA0080668Battery · dischargedSEA - DURING MAINTENANCE CHECK, EMERGENCY TRACK LIGHTING AT ROW 2 WAS DETERMINED TO BE INOPERATIVE. REPAIRED WIRING AT ROW 2. LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0080649Battery · dischargedDURING MAIN CHECK OVERHEAD EMERGENCY LIGHTS FOUND TO BE INOP BETWEEN AFT LAV. REPLACED NICAD BATTERIES IN BATTERY PACK. OPERATED NORMALLY.SDR ASAA0080503Harness · disconnectedSEA - PRIOR TO FLIGHT 660, THE FORWARD 7 EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING HARNESS AT ROW 3 AND THE EMERGENCY EXIT LIGHTS OPERATED NORMALLY. (M)SDR ASAA0080502Light · inoperativeSEA - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA0080501Wire · disconnectedSFO - PRIOR TO DEPARTURE OF FLIGHT 391, CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE INOPERATIVE. SECURED LOOSE CONNECTOR IN FLOOR TRACK AT ROW 3 AND OPERATED NORMALLY. (M)SDR ASAA0080494Wire · disconnectedLAX - DURING MAINTENANCE CHECK, 5 EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND TO BE INOPERATIVE IN THE FIRST CLASS CABIN. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR 20001004AP009Power Supply · inoperativeOAK - DURING MAINTENANCE CHECK, THE EXTERIOR OVERWING EMERGENCY LIGHTS WERE FOUND INOPERATIVE. REPLACED THE POWER SUPPLY, RELAY R2-271, AND THE EMERGENCY LGIHT SWITCH AT THE FORWARD FLIGHT ATTENDANT PANEL AND OPERATED NORMALLY. (M)SDR ASAA0080363Relay · inoperativeOAK - DURING MAINTENANCE CHECK, THE EXTERIOR OVERWING EMERGENCY LIGHTS WERE FOUND INOPERATIVE. REPLACED THE POWER SUPPLY, RELAY R2-271, AND THE EMERGENCY LIGHT SWITCH AT THE FORWARD FLIGHT ATTENDANTS PANEL. OPERATED NORMALLY. (M)SDR ASAA0080364Power Supply · inoperativeOAK - DURING MAINTENANCE CHECK, THE EXTERIOR OVERWING EMERGENCY LIGHTS ILLUMINATE WHEN ELECTRICAL POWER SWITCHED FROM GROUND POWER TO APU GENERATOR POWER. REPLACED THE POWER SUPPLY AND OPERATED NORMALLY. (M)SDR ASAA0080257Turbine · leakingOAK: FLIGHT DIVERTED DUE TO FUMES IN THE AFT CABIN AFTER TAKEOFF. THE RIGHT AFT LAV SMOKE DETECTOR CHIMES SOUNDED APPROX. TEN TIMES. LANDED WITHOUT INCIDENT, MX FOUND THE LEFT COOLING TURBINE LEAKING OIL. REPLACED COOLING TURBINE. PERFORMED HIGH PRESSURE DUCTISDR ASAA0080249Wire · disconnectedLAS - FLT 633 - PRIOR TO DEPARTURE, CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE INOPERATIVE. RECONNECTED AND SECURED CONNECTOR AT ROW 2 AND OPERATED NORMALLY. (X)SDR ASAA0080244Light · inoperativeSEA - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND WITH BROKEN FASTENERS. REPLACED LIGHT ASSEMBLY AND OPERATED NORMALLY. (X)SDR ASAA0080172Wire · disconnectedSEA - PRIOR TO DEPARTURE OF FLT 274, CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE INOPERATIVE. RECONNECTED WIRING IN FLOOR TRACK AND OPERATED NORMALLY. (M)SDR ASAA0080006Wire · disconnectedONT - PRIOR TO DEPARTURE OF FLIGHT 447, CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE INOPERATIVE. RECONNECTED WIRE IN FLOOR TRACK AND OPERATED NORMALLY. (M)SDR ASAA9980334Wire · disconnectedPDX - PRIOR TO DEPARTURE OF FLIGHT 100, CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE INOPERATIVE. RECONNECTED WIRING I NFLOOR TRACK AND OPERATED NORMALLY. (M)SDR ASAA9980330Wire · disconnectedSEA - PRIOR TO DEPARTURE OF FLIGHT 386, CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE INOPERATIVE. RECONNECTED WIRING IN FLOOR TRACK AND OPERATED NORMALLY. (M)SDR ASAA9980266Slide · will not testOAK - DURING C-CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (X)SDR ASAA9980192Lamp · failedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHT AT ROW 23 WAS FOUND INOPERATIVE. REPLACED DEFECTIVE LAMP MODULE AND OPERATED NORMALLY. (X)SDR ASAA9980183Battery · dischargedSEA - DURING MAINTENANCE CHECK, THE FORWARD OVERWING EMERGENCY EXIT IDENTIFIERS WERE FOUND INOPERATIVE. REPLACED THE BATTERIES IN THE POWER SUPPLY AND OPERATED NORMALLY. (M)SDR ASAA9980180Wire · disconnectedSEA - PRIOR TO DEPARTURE OF FLIGHT 434, CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE INOPERATIVE. RECONNECTED WIRING IN FLOOR TRACK AND OPERATED NORMALLY. (M)SDR ASAA9980171Wire · disconnectedLAX - PRIOR TO DEPARTURE OF FLT 559, CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE INOPERATIVE. RECONNECTED WIRING IN FLOOR TRACK AND OPERATED NORMALLY. (M)SDR ASAA9980158Wire · damagedSEA - PRIOR TO DEPARTURE OF FLT 444, CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE INOPERATIVE. REPAIRED WIRING IN FLOOR TRACK AND OPERATED NORMALLY. (M)SDR ASAA9980156Connector · looseANC - PRIOR TO DEPARTURE OF FLT 188, CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTS IN THE AFT CABIN WERE INOPERATIVE. SECURED CONNECTOR TO LIGHT ASSEMBLY AT ROW 27 AND OPERATED NORMALLY. (M)SDR ASAA9980141Batteries · dischargedPDX - DURING MAINTENANCE CHECK, THE OVERHEAD EMERGENCY LIGHTS FROM ROWS 19 TO 23 WERE FOUND INOPERATIVE. REPLACED THE BATTERIES IN THE POWER SUPPLY AND OPERATED NORMALLY. (X)SDR ASAA9980140Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHTS FROM ROWS 29 TO 32 WERE FOUND INOPERATIVE. RECONNECTED WIRING IN FLOOR TRACK AND OPERATED NORMALLY. (X)SDR ASAA9980112Wire · disconnectedSMF - AFTER ARRIVAL OF FLIGHT 384, CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE INOPERATIVE. SECURED WIRING TO LIGHT SOCKET IN FLOOR TRACK AND OPERATED NORMALLY. (M)SDR ASAA9980074Wire · damagedSEA - PRIOR TO DEPARTURE OF FLIGHT 463, CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE INOPERATIVE. REPAIRED WIRING IN FLOOR TRACK AND OPERATED NORMALLY. (M)SDR ASAA9980066Wire · disconnectedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE FOUND INOPERATIVE. RECONNECTED WIRING IN FLOOR TRACK AT ROW 3 AND OPERATED NORMALLY. (M)SDR ASAA9980047Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHTS FROM ROWS 6 TO 8 WERE FOUND INOPERATIVE. RECONNECTED WIRING IN FLOOR TRACK AND OPERATED NORMALLY. (M)SDR ASAA9980042Bulb · failedSEA - DURING MAINTENANCE CHECK, THE AFT 2 RED EMERGENCY FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. REPLACED THE LAMP MODULES AND OPERATED NORMALLY. (M)SDR ASAA9980031Wire · disconnectedPDX - FLT 583 - CREW REPORTED EMERGENCY EXIT FLOOR TRACK LIGHTS IN FIRST CLASS WERE INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9980009Wire · damagedSEA - PRIOR TO DEPARTURE OF FLT 264, CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE INOPERATIVE. REPAIRED WIRING IN FLOOR TRACK AND OPERATED NORMALLY. (X)SDR ASAA9980003Wire · disconnectedANC - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHTS FROM ROWS 9 TO 13 WERE FOUND INOPERATIVE. RECONNECTED WIRING IN FLOOR TRACK AT ROW 11 AND OPERATED NORMALLY. (M)SDR ASAA9880273Wire · disconnectedPDX - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE FOUND INOPERATIVE. RECONNECTED WIRING IN FLOOR TRACK AND OPERATED NORMALLY. (M)SDR ASAA9880246Wire · disconnectedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHT WERE FOUND INOPERATIVE FROM ROWS 10 THROUGH 13. RECONNECTED WIRING IN FLOOR TRACK AT ROW 11 AND LIGHTS OPERATED NORMALLY. (M)
Back to N975AS, cancelled Jul 7, 2015