N974AS
Service difficulty reports not matched to an aircraft · 122
They name N974AS, 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 = 'N974AS' 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 = 'N974AS' 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 ASAA0080643Battery · dischargedOAK-DURING C06 CHECK, EMERGENCY FLOOR TRACK LIGHTING DETERMINED TO BE INOP IN FIRST CLASS CABIN. REPLACED BATTERY ASSEMBLY. OPS CHECKED NORMALLY.SDR ASAA9980195Battery Pack · dischargedPHX - DURING C-CHECK, THE OVERHEAD EMERGENCY EXIT LIGHTS WERE FOUND INOPERATIVE AT ROWS 13 THROUGH 20. REPLACED PACK BATTERIES AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9980044Mechanism · out of adjustANC - AFTER ARRIVAL OF FLIGHT 88, CREW REPORTED THE L1 DOOR IS DIFFICULT TO OPEN AFTER CABIN HAS BEEN PRESSURIZED, OPERATION NORMAL ON SUBSEQUENT OPENINGS. INSPECTED L1 DOOR AND ACCOMPLISHED GROUND PRESSURIZATION CHECK TO 6.0 PSID, NO DEFECT NOTED AND FOUND OPSDR ASAA9980043Mechanism · lack of lubeFAI - AFTER ARRIVAL OF FLIGHT 115, CREW REPORTED THE L1 DOOR WAS DIFFICULT TO OPEN. LUBRICATED DOOR OPERATING MECHANISM AND OPERATED NORMALLY. (M)SDR ASAA9880213Hold Open Hook · bentSEA - PRIOR TO DEPARTURE OF FLIGHT 318, CREW REPORTED THE L1 DOOR WAS DIFFICULT TO OPEN AND HOLD OPEN LATCH WOULD NOT LINE UP. REPLACED DOOR HOLD OPEN HOOK AND OPERATED NORMALLY. (M)SDR ASAA9880176Light · inoperativeSEA - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9880124Latch · malfunctionedSEA - DURING MAINTENANCE CHECK, THE L1 DOOR WOLD NOT RELEASE FROM THE LATCHED OPEN POSITION. ADJUSTED THE DOOR HOLD OPEN LATCH RELEASE MECHANISM AND OPERATED NORMALLY. (M)SDR ASAA9880115Latch · lack of lubeSFO - PRIOR TO DEPARTURE OF FLIGHT 420, CREW REPORTED THE L1 DOOR WOULD NOT LATCH OPEN. LUBRICATED THE DOOR HOLD OPEN LATCH MECHANISM AND OPERATED NORMALLY. (X)SDR ASAA9880108Battery · dischargedSEA - DURING MAINTENANCE CHECK, THE AFT OVERWING EMERGENCY EXIT IDENTIFIERS WERE FOUND INOPERATIVE. REPLACED THE BATTERIES IN THE POWER SUPPLY AND OPERATED NORMALLY. (M)SDR ASAA9880092Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, THE AFT TWO OVERHEAD EMERGENCY EXIT LIGHTS AND LOWER TAILCONE LIGHTS WERE FOUND INOPERATIVE. REPLACED BATTERY PACK AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9880090Light · inoperativeSEA - DURING MAINTENANCE CHECK, THE PORTABLE EMERGENCY EXIT LIGHT AT THE L-1 DOOR WAS FOUND INOPERATIVE. RELAMPED AND LIGHT OPERATED NORMALLY. (M)SDR ASAA9880091Skin · damagedSEA - LEFT FORWARD CORNER OF NOSE LANDING GEAR WHEEL WELL WAS DAMAGED DURING PUSHBACK BY A TUG. THE DAMAGE WAS FOUND TO BE WITHIN SRM LIMITS. REPLACED LOOSE BLIND FASTENERS PER THE SRM AND RELEASED AIRCRAFT PER PLT DEFERRAL, WITH REINSPECTIONS TO BE ACCOMPLISDR ASAA9780209Wire · disconnectedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHTS FROM ROWS 1 TO 4 WERE INOPERATIVE. RECONNECTED WIRE IN TRACK AT ROW 4 AND OPERATED NORMALLY. (M)SDR ASAA9780093Lanyard · disconnectedANC - DURING INSPECTION OF THE TAILCONE EMERGENCY EVACUATION SLIDE THE AUTOMATIC DEPLOY LANYARD WAS FOUND DISCONNECTED FROM THE GIRT TAB. CONNECTED THE AUTOMATIC DEPLOY LANYARD TO THE GIRT TAB. (M)SDR ASAA9780066Release Mech · out of adjustSEA - DURING MAINTENANCE TEST, THE TAILCONE FAILED TO DEPART THE AIRCRAFT WHEN THE EMERGENCY RELEASE HANDLE WAS ACTIVATED FROM THE AFT CABIN ENTRY DOOR POSITION. FOUND THE AFT RELEASE MECHANISM CLIPS ADJUSTMENT TOO TIGHT. ADJUSTED THE CLIP TENSION IAW DC-9 MSDR ASAA9680245Fire Warning · soundedGEG - FLT 305 - CREW REPORTED, APU AURAL FIRE WARNING SOUNDED DESCENDING THROUGH 8500 FEET IN RAIN, NO VISUAL INDICATION NOTED. PERFORMED APU/ENGINE FIRE WARNING TEST, NO FAULT FOUND. (M)SDR ASAA9680237Light · defectiveSFO - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9680200Light · inoperativePDX - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9680098Portable Light · defectiveSEA - DURING MAINTENACNE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9680063Slide · failedOAK - DURING C-CHECK, THE TAILCONE EMERGENCY EVACUATION SLIDE EMERGENCY LIGHTS FAILED TEST. REPLACED THE TAILCONE EMERGENCY EVACUATION SLIDE. (M)SDR ASAA9680039Mechanism · lack of lubeANC - FLT 112 - AFTER ARRIVAL, CREW REPORTED THE L1 DOOR WAS DIFFICULT TO OPEN. CLEANED AND LUBRICATED DOOR MECHANISM AND OPERATED NORMALLY. (X)SDR ASAA9580135Portable Eel · defectiveLAX - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)
Back to N974AS