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 ASAA0080120Cargo Track · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON THE AFT CARGO COMPARTMENT RIGHT AFT CARGO TIEDOWN TRACK AROUND THE INBOARD AND OUTBOARD FASTENER HOLES FROM STATION 1212 TO 1287 AT LONGERON 28R. REPAIRED PER SRM 53-24. (M)SDR ASAA0080119Frame · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON THE AFT CARGO COMPARTMENT FRAME LOWER AFT FLANGE AROUND FASTENERS, STATION 1250, LONGERON 29L. REMOVED CORROSION PER SRM 53-01. (M)SDR ASAA0080118Frame · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON THE AFT CARGO COMPARTMENT AFT LOWER FLANGE OF THE FRAME, STATION 1287, LONGERON 30. REMOVED CORROSION PER SRM 51-30-2. (M)SDR ASAA0080117Floor Support · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON SURFACES OF THE AFT LEFT CABIN LAVATORY FLOOR SUPPORT, STATION 1287, LBL 20. REPAIRED PER SRM 53-01. (M)SDR ASAA0080116Frame · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON THE AFT CARGO COMPARTMENT FRAME FORWARD UPPER FLANGE, STATION 1271, LONGERON 28L. REMOVED CORROSION PER SRM 53-01. (M)SDR ASAA0080115Frame · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON UPPER FLANGE OF THE AFT CARGO COMPARTMENT FRAME WHICH EXTENDS UNDER THE CARGO TIEDOWN TRACK AT STATION 1271, LONGERON 27R. REMOVED CORROSION PER SRM 53-01. (M)SDR ASAA0080114Frame · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON THE AFT CARGO COMPARTMENT FRAME AT STATION 1250, LONGERON 27R. REPAIRED PER SRM 53-01. (M)SDR ASAA0080113Frame · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON THE AFT LOWER FLANGE OF THE AFT CARGO COMPARTMENT FRAME AROUND FASTENERS AND ON THE FRAME FLANGE AT STATION 1250, LONGERON 30. REPAIRED PER SRM 53-01, FIG 1. (M)SDR ASAA0080112Angle · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON THE AFT CARGO COMPARTMENT FUSELAGE FRAME STRAP ANGLE AT STATION 1231, LONGERON 28R. REPAIRED PER SRM 51-30. (M)SDR ASAA0080111Angle · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON THE AFT CARGO COMPARTMENT FLOORBOARD SUPPORT ANGLE AT STATION 1212 BETWEEN LONGERON 29R AND 28R. REPAIRED PER SRM 51-10-3. (M)SDR ASAA0080110Shear Tie · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON THE AFT CARGO COMPARTMENT FORWARD SIDE OF FRAME AT SHEAR TIE, STATION 1174, LONGERON 29R TO 30. REMOVED CORROSION PER SRM 53-01. (M)SDR ASAA0080109Beam · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON THE AFT CARGO LOWER DOOR BEAM SPACER AROUND THE DOOR STOP AT STATION 1174 AND 1193, LONGERON 28R. REMOVED CORROSION PER WORK CARD 28553000. (M)SDR ASAA0080108Floor Support · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON THE AFT CARGO COMPARTMENT FRAME ON THE TOP AND BOTTOM SURFACE OF THE FLOORBOARD SUPPORT ANGLE BETWEEN LONGERON 28R AND 28L, STATION 1155. REMOVED CORROSION PER SRM 51-30. (M)SDR ASAA0080107Floor Support · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON THE AFT CARGO COMPARTMENT FRAME ON THE TOP SURFACE OF THE FLOORBOARD SUPPORT ANGLE BETWEEN LONGERON 29R AND 28L, STATION 1079. REMOVED CORROSION PER SRM 51-10. (M)SDR ASAA0080106Beam · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON MID CARGO LOWER DOOR BEAM AROUND THE RIVNUT AT STATION 678, STRINGER 28R. REMOVED CORROSION PER SRM 51-30-6. (M)SDR ASAA0080105Floor Support · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON MID CARGO FLOORBOARD SUPPORT ANGLE AROUND FASTENER HOLE AT STATION 520, LBL 10. REMOVED CORROSION PER SRM 51-10. (M)SDR ASAA0080104Floor Support · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON R1 DOOR ENTRANCE FLOOR SUPPORT AT FLOORBOARD ATTACH FLANGE, STATION 160 TO 205, RBL 55. REPAIRED PER SRM 53-14-1. (M)SDR ASAA0080103Floor Support · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON L1 DOOR ENTRYWAY FLOOR SUPPORT BETWEEN STATION 160 AND 190, LBL 55. REMOVED CORROSION PER SRM 53-01. (M)SDR ASAA0080102Slide · will not testPHX - DURING 15K CHECK, THE L2 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L2 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR ASAA9980286Battery · dischargedSEA - DURING MAINTENANCE CHECK, THE OVERHEAD EMERGENCY LIGHTS FROM ROWS 9 TO 11 WERE FOUND INOPERATIVE. REPLACED THE BATTERIES IN THE POWER SUPPLY AND OPERATED NORMALLY. (X)SDR ASAA9980057Light · inoperativeOAK - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LGIHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9880265Hook · defectiveSEA - DURING MAINTENANCE CHECK, THE L2 DOOR WOULD NOT LATCH OPEN. REPLACED THE DOOR HOLD OPEN HOOK AND OPERATED NORMALLY. (M)SDR ASAA9880178Hold Open Hook · bentSEA - PRIOR TO DEPARTURE OF FLIGHT 288, CREW REPORTED THE L1 DOOR WOULD NOT LATCH OPEN. FOND DOOR HOLD OPEN HOOK BENT, STRAIGHTENED HOOK AND OPERATED NORMALLY. (M)SDR ASAA9880173Light · inoperativeLAX - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9880019Connector · loosePDX - PRIOR TO DEPARTURE OF FLT 520, CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTS IN THE FORWARD CABIN WERE INOPERATIVE. SECURED LOOSE CONNECTOR TO LIGHT ASSY AND OPERATED NORMALLY. (M)SDR ASAA9780280Light · defectiveSEA - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. PART TOTAL CYCLES: 4,650. (X)SDR ASAA9780228Latch Mechanism · out of adjustPDX - AFTER ARRIVAL OF FLT 475 - CREW REPORTED THE FLT COMPARTMENT LEFT SLIDING WINDOW WOULD NOT OPEN. ADJUSTED THE LEFT SLIDING WINDOW LATCH MECHANISM AND OPERATED NORMALLY. (M)SDR ASAA9780180L2 Door · failed testOAK - DURING C-CHECK, THE L2 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L2 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR ASAA9780179Slide · failed testOAK - DURING C-CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMPE TEST. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR ASAA9780178Inflation Bottle · low pressureOAK - DURING C-CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE INFLATION BOTTLE PRESSURE WAS FOUND LOW. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR ASAA9680252Latch · malfunctionedSEA - AFTER ARRIVAL OF FLIGHT 333, CREW REPORTED THE L1 DOOR HOLD OPEN LOCK WOULD NOT RELEASE, HAD TO USE RELEASE BUTTON ON FUSELAGE TO RELEASE DOOR. LUBRICATED THE HOLD OPEN LATCH ASSEMBLY AND DOOR OPERATED NORMALLY. (M)SDR ASAA9680232Light · defectivePDX - DURING MAINTENANCE CHECK, THE FORWARD PORTABLE EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9680144Guide Rod · lack of lubeSJC - PRIOR TO DEPARTURE OF FLIGHT 455, CREW REPORTED THE L2 DOOR WOULD NOT OPEN FROM INSIDE OR OUTSIDE. CLEANED AND LUBED L2 DOOR LOWER GUIDE ROD AND OPERATED NORMALLY. (X)
Back to N979AS