N979AS
Service difficulty reports not matched to an aircraft · 133
They name N979AS, 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 = 'N979AS' 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 = 'N979AS' 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 ASAA04800420Cusp Web · crackedOKC - DURING HV CHECK, FOUND CUSP WEB AT STATION 246, RBL 44.5 IS CRACKED. REMOVED DAMAGE AND INSTALLED REPAIR DOUBLER IAW 53-01. (M)SDR ASAA0480421Frame · corrodedDURING HV CHECK, FOUND FRAME IN AFT PIT AT STATION 1117, LONGERON 29R TO 29L IS CORRODED. REMOVED DAMAGE AND INSTALLED NEW FRAME IAW 51-30-1. (M)SDR ASAA0480403Floor Panel · tornDURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 200-256, LBL 15 - RBL 22 HAS TORN FIBERS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480422Frame · corrodedDURING HV-CHECK, FOUND FRAME IN AFT PIT AT STATION 1250, LONGERON 29R TO 28L IS CORRODED. REMOVED DAMAGE AND INSTALLED FRAME REPAIR ANGLES IAW 53-03. (M)SDR ASAA0480404Floor Panel · corrodedDURING HV-CHECK, FOUND CABIN FLOOR PANEL AT STATION 200-256, RBL 22-44 HAS CORRODED INSERTS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480410Floor Panel · corrodedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 160-200, LBL 44-54 HAS CORRODED INSERTS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480411Floor Panel · delaminatedDURING HV-CHECK, FOUND CABIN FLOOR PANEL AT STATION 144-160, RBL 32-44 HAS DELAMINATED CORNERS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480412Floor Panel · tornOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 200-256, LBL 22-44 HAS TORN FIBERS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480413Floor Panel · debondedDURING HV-CHECK, FOUND OVERWING AREA FLOORBOARD IS DISBONDED ON CORNER. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480408Floor Panel · crackedDURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 160-200, RBL 44-54 IS CRACKED. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480409Floor Panel · corrodedDURNIG HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 180-200, RBL 8-44 HAS CORRODED AND BROKEN INSERTS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480406Floor Panel · tornDURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 160-200, LBL 8 - RBL 8 HAS TORN FIBERS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480407Floor Panel · corrodedDURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 144-160, RBL 8-16 HAS CORRODED INSERTS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480405Floor Panel · debondedOKC - DURING HV CHECK, CABIN FLOOR PANEL AT STATION 160-200, LBL 8-44 HAS DISBONDED CORNERS. REMOVED FLOOR PANEL AND INSTALLED REPLACEMENT FLOOR PANEL IAW 53-05. (M)SDR ASAA0480374Floor Panel · crackedOKC - DURING HV CHECK, FOUND OVERWING AREA FLOOR PANEL HAS CRACKED ATTACH STRIP. REPAIR IAW SRM. (M)SDR ASAA0480375Floor Panel · crackedDURING HV CHECK, FOUND OVERWING AREA FLOOR PANEL HAS 2 CRACKS ON ATTACH STRIP. REPAIR IAW MM. (M)SDR ASAA0480379Cusp Web · corrodedDURING HV CHECK, FOUND CUSP WEB BETWEEN FUSELAGE AT STATION 503 AND 522 IS CORRODED LEFT. REPAIR IAW SRM. (M)SDR ASAA0480376Floor Panel · debondedDURING HV CHECK, FOUND CABIN FLOOR PANEL AT FS 826-927 TRIM SEPARATED. REPAIR IAW SRM. (M)SDR ASAA0480377Floor Panel · debondedDURING HV CHECK, FOUND CABIN FLOOR PANEL AT FS 200-256 STIFFENERS ARE DISBONDED. REPAIR IAW MM. (M)SDR ASAA0480378Cusp Web · corrodedDURING HV CHECK FOUND MAIN CABIN RIGHT SIDE CUSP WEB CORRODED BETWEEN STATION 845 AND 864. REPAIR IAW SRM. (M)SDR ASAA0480380Skin · puncturedDURING HV CHECK, FOUND EMP SKIN PUNCTURED BETWEEN STATION 1485 AND 1497. REPAIR IAW SRM. (M)SDR ASAA0480381Skin · puncturedDURING HV CHECK, FOUND EMP SKIN PUNCTURED BETWEEN 1474-1485. REPAIR IAW SRM. (M)SDR ASAA0480382Window Frame · crackedOKC - DURING HV CHECK, FOUND CRACK ON CAPTAINS CLEAR VIEW WINDOW CUT OUT AT UPPER AFT CORNER ON INNER SURFACE. REPAIR IAW SRM. (M)SDR ASAA0480383Skin · gougedDURING HV CHECK, FOUND EMP SKIN GOUGED BETWEEN STATION 1497 AND 1510. REPAIR IAW SRM. (M)SDR ASAA0480384Skin · dentedOKC - DURING HV CHECK, FOUND DENT IN FUSELAGE SKIN AT SIDE STATION 239 BETWEEN 18L AND 19L. REPAIR IAW SRM. (M)SDR ASAA0480387Floor Panel · crackedDURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 927-1003 CRACKED. REPAIR IAW SRM. (M)SDR ASAA0480388Floorboard · puncturedDURING HV CHECK, FOUND OVERWING AREA FLOORBOARD HAS A HOLE AT STATION 826. REPAIR IAW SRM. (M)SDR ASAA0480389Door Frame · crackedDURING HV CHECK, FOUND RIGHT NOSE GEAR DOOR JAMB FRAME CRACKED AT STATION 69. REPAIR IAW SRM. (M)SDR ASAA0480392Cusp Web · corrodedOKC - DURING HV CHECK, FOUND MAIN CABIN STATION 731 AT LONGERON 18R CORROSION ON UPPER AND LOWER SURFACE OF CUSP MEMBRANE. REPAIR IAW SRM. (M)SDR ASAA0480390Door Frame · crackedDURING HV CHECK, FOUND LEFT NOSE GEAR DOOR JAMB FRAME CRACKED AT FS 69. REPAIR IAW SRM. (M)SDR ASAA0480386Floor Panel · tornOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL AT STATION 160-180 AND RBL 8-44 DAMAGED. REPAIR IAW SRM. (M)SDR ASAA0480385Floor Panel · crackedOKC - DURING HV CHECK, FOUND CABIN FLOOR PANEL STATION 200-256 AND LBL 15-22 CRACKED. REPAIR IAW SRM. (M)SDR ASAA0480391Shear Tie · corrodedOKC - DURING HV CHECK, FOUND AFT CARGO COMPARTMENT STATION 1060 BETWEEN LONGERON 29R AND 30 CORROSION ON SHEAR TIE. REPAIR IAW SRM. (M)SDR ASAA0480279Connector · disconnectedLAX - DURING PREFLIGHT CHECK, EMERGENCY TRACK LIGHT WERE FOUND INOPERATIVE IN 1ST CLASS CABIN. RECONNECTED CONNECTOR AT ROW 2. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0480270Connector · disconnectedDURING SEA LINE CHECK, FOUND EMERGENCY TRACK LIGHTS INOPERATIVE. RECONNECTED CONNECTOR AT ROW 3. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0480237Girt Bar · disconnectedPHX - DURING PREFLIGHT CHECK, FOUND FORWARD PAX L1 DOOR EMERGENCY SLIDE GIRT LANYARD DETACHED. RESECURED LANYARD TO GIRT BAR. (M)SDR ASAA0480191Light · inoperativePDX - FOUND DURING LINE CHECK, PORTABLE EMERGENCY LIGHT AT FORWARD ENTRY DOOR INOPERATIVE. REPLACED LIGHT ASSEMBLY. LIGHT THEN OPERATED PROPERLY. (M)SDR ASAA0480161Module · inoperativePHX - DURING PREFLIGHT CHECK, EMERGENCY TRACK LIGHTS INOPERATIVE IN FIRST CLASS CABIN. RECONNECTED CONNECTOR WIRE. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0380604Lanyard · disconnectedPREFLIGHT CHECK, FORWARD PASSENGER L-1 DOOR EMERGENCY SLIDE LANYARD WAS FOUND DISCONNECTED. RECONNECTED LANYARD. (M)SDR ASAA0380597Light · inoperativeSAN PREFLIGHT CHECK, FIRST 4 EMERGENCY FLOOR TRACK LIGHTS INOPERATIVE IN 1ST CLASS CABIN. RECONNECTED LOOSE CONNECTOR. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0380348Wire · damagedSEA PREFLIGHT CHECK, FOUND FIRST CLASS EMERGENCY TRACK LIGHTING INOPERATIVE. REPAIRED DAMGED WIRE AT ROW 3. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0180271Battery Pack · dischargedLAX - DURING PREFLIGHT CHECK, COCKPIT OVERHEAD EMERGENCY LIGHTING WAS INOPERATIVE. REPLACED ASSOCIATED BATTERY POWER SUPPLY PACK AT B5-23. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0180142Light · missingLAX - DURING PREFLIGHT CHECK, FOUND EMERGENCY FLOOR TRACK LAMP MODULES MISSING AT ROW 10. REPLACED MISSING LAMP MODULES. LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0180107Harness · failedOAK - DURING C-CHECK, L1 DOOR EMERGENCY SLIDE HARNESS FAILED THE AMPERAGE CHECK. REPLACED L1 DOOR SLIDE. (M)SDR ASAA0180045Light · inoperativeSEA - DURING LINE CHECK, PORTABLE EMERGENCY LIGHT WAS DETERMINED TO INOPERATIVE. REPLACED LIGHT ASSEMBLY. LIGHT THEN OPERATED PROPERLY. (M)SDR ASAA0080522Power Supply · dischargedSEA - DURING MAINTENANCE CHECK, BOTH EXTERIOR OVERWING EXIT LIGHTS FAILED TO EXTINGUISH. REPLACED THE POWER SUPPLY AND BOTH LIGHTS OPERATED NORMALLY. (M)SDR ASAA0080475Power Supply · dischargedSEA - DURING MAINTENANCE CHECK, BOTH EXTERIOR OVERWING EMERGENCY EXIT LIGHTS WERE FOUND TO BE INOPERATIVE. REPLACED POWER SUPPLY AND BOTH LIGHTS OPERATED NORMALLY. (M)SDR ASAA0080365Light · inoperativeOAK - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLCED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA0080122Splice · crackedPHX - DURING 15K CHECK, THE LEFT WING LEADING EDGE SPLICE AT XRS 164 WAS FOUND CRACKED. REPLACED SPLICE PER SRM 51-30-2. (M)SDR ASAA0080121Cargo Track · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON THE AFT CARGO COMPARTMENT LEFT CARGO TIEDOWN TRACK ON THE TOP AND BOTTOM SURFACE OF THE TRACK BETWEEN STATION 1231 AND 1212, LONGERON 28L. REPAIRED PER SRM 51-30. (M)
Back to N979AS