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 ASAA0380069Shear Tie · corrodedOKC - FOUND DURING C-CHECK, SHEAR TIE CORRODED AT FS 1250. REPLACED SHEAR TIE PER SRM 51-10-2, 51-10-3, AND 53-14-3. (M)SDR ASAA0380070Cargo Track · corrodedOKC - FOUND DURING C-CHECK, TIE DOWN TRACK CORRODED IN AFT CARGO BAY. REPLACED TRACK PER SRM 51-10-2, 51-10-4, 51-30-1, AND 51-30-5. (M)SDR ASAA0380074Hinge · crackedOKC - FOUND DURING C-CHECK, AFT CARGO BAY BARRIER DOOR HINGE CRACKED. REPLACED HINGE PER SRM 51-30-1. (M)SDR ASAA0380072Gusset · corrodedOKC - FOUND DURING C-CHECK, GUSSET CORRODED IN AFT CARGO BAY. REPLACED GUSSET PER SRM 51-10-2 AND 51-10-4. (M)SDR ASAA0380071Floor Panel · corrodedOKC - FOUND DURING C-CHECK, FLOOR PANEL CORRODED IN AFT CARGO BAY. REPLACED PANEL PER SRM 51-10-2 AND 51-10-3. (M)SDR ASAA0380068Shear Tie · corrodedOKC - FOUND DURING C-CHECK, SHEAR TIE IS CORRODED AT FS 1287. REMOVED CORROSION AND INSTALLED DOUBLER PER SRM 53-01, 53-03, AND 51-10-3. (M)SDR ASAA0380067Dome Nut · corrodedOKC - FOUND DURING C-CHECK, PANEL LANDING HAS CORRODED DOME NUTS AT FS 786. REPLACED DOME NUTS PER SRM 51-30-2. (M)SDR ASAA0280331Module · disconnectedYVR - DURING PRE-FLIGHT CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS INOPERATIVE AT ROW 26. RECONNECTED LIGHT MODULE. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0280159Battery Pack · dischargedPDX - DURING LINE CHECK, FOUND EXTERIOR OVERWING EMERGENCY EXIT LIGHTS WERE DETERMINED TO BE INOPERATIVE. REPLACED ASSOCIATED BATTERY PACK, POWER SUPPLY. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0280145Power Supply · dischargedPHX - DURING LINE CHECK EXTERIOR, OVERWING EMERGENCY LIGHTS WERE FOUND INOPERATIVE. REPLACED POWER SUPPLY. EMERGENCY LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0180240Module · disconnectedPDX - DURING PREFLIGHT CHECK, 1ST CLASS EMERGENCY FLOOR TRACK LIGHTING WAS DETERMINED TO BE INOPERATIVE. RECONNECTED LOOSE LIGHT MODULE SOCKET. LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0180230Power Supply · dischargedPHX - DURING PREFLIGHT, THE EMERGENCY EXIT LIGHTS IN FIRST CLASS WERE FOUND TO BE INOPERATIVE. REPLACED THE POWER SUPPLY AND THE LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0080688Battery Pack · dischargedSEA - DURING LINE CHECK, OVERWING EMERGENCY LIGHT WAS DETERMINED TO BE INOPERATIVE. REPLACED ASSOCIATED BATTERY ASSEMBLY. LIGHT THEN OPERATED NORMALLY. (M)SDR ASAA0080683Switch · inoperativeSEA - DURING LINE SERVICE CHECK, FLIGHT ATTENDANTS EMERGENCY LIGHTING SWITCH WAS DETERMINED TO BE INOPERATIVE. REPLACE FLIGHT ATTENDANTS EMERGENCY LIGHTING SWITCH. LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0080680Light · disconnectedSEA - DURING LINE CHECK, EMERGENCY TRACK LIGHTS AT CABIN ROW 1 WERE DETERMINED TO BE INOPERATIVE. RECONNECTED LIGHT MODULE. LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0080678Socket · defectiveSFO - DURING LINE CHECK, ONE LEFT OVERWING EMERGENCY LIGHT WAS DETERMINED TO BE INOPERATIVE. REPLACED LIGHT SOCKET ASSEMBLY. LIGHT OPERATED NORMALLY. (M)SDR ASAA0080675Power Supply · dischargedPDX-DURNING LINE CHECK, EXTERIOR OVERWING EMERGENCY LIGHTING WAS DETERMINED TO BE INOPERATIVE. REPLACED EXTERIOR EMERGENCY LIGHTING POWER SUPPLY. LIGHTS OPERATED NORMALLY.SDR ASAA0080640Wire · disconnectedSEA - PRIOR TO FLT 199, THE EMERGENCY TRACK LIGHTS WERE FOUND INOPERATIVE. INSPECTED AND FOUND WIRING AND LIGHT ASSEMBLIES DISCONNECTED. RECONNECTED WIRING AND LIGHTS, SYSTEM OPERATES NORMAL. (M)SDR ASAA0080639Light · inoperativeEMERGENCY EXIT TRACK LIGHTS IN THE FIRST CLASS SECTION WOULD NOT ILLUMINATE WITH THE SWITCH ON.REPLACED INOPERATIVE LAMP ASSEMBLY AT ROW 2 AND LIGHTS OPERATED NORMALLY.SDR ASAA0080634Power Supply · dischargedSEA - DURING MAINTENANCE CHECK, BOTH AFT OVERWING EXIT EMERGENCY LIGHTS INOPERATIVE. REPLACED THE POWER SUPPLY AND THE LIGHTS OPERATED NORMALLY. (M)SDR ASAA0080631Module · inoperativeSEA PRIOR TO FLIGHT 394 THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROWS 21-24 WERE FOUND TO BE INOPERATIVE. REPLACED LIGHT MODULE ASSEMBLY AND THE LIGHTS OPERATED NORMALLY.SDR ASAA0080629Wire · disconnectedSEA - DURING MAINTENANCE CHECK, THE MULTIPLE EMERGENCY EXIT TRACK LIGHTS WERE FOUND INOPERATIVE. RECONNECTED AND REPLACED DAMAGED TRACK SECTIONS AND THE LIGHTS OPERATED NORMALLY. (X)SDR ASAA0080626Hook · bindingPHX - FLT 726 - PRIOR TO FLIGHT, THE L1 DOOR HOLD OPEN WAS FOUND BINDING. INSPECTED AND RELEASED AIRCRAFT FOR FERRY FLIGHT TO OAK FOR REPAIR. OAK MAINTENANCE RIGGED THE L1 DOOR HOLD OPEN HOOK AND THE DOOR OPERATED NORMALLY. (X)SDR ASAA0080521Wire · disconnectedANC - DURING MAINTENANCE CHECK, SEVERAL EMERGENCY EXIT TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING/LIGHTS AND ALL LIGHTS OPERATED NORMALLY. (M)SDR COMA0060954Wire · disconnectedANC - DURING MAINTENANCE CHECK, SEVERAL EMERGENCY EXIT TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. RECONNECTED WIRING/LIGHTS AND ALL LIGHTS OPERATED NORMALLY. (M)SDR ASAA0080499Wire · disconnectedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY FLOOR TRACK LIGHT AT ROW 17 WAS FOUND INOPERATIVE. RECONNECTED WIRES TO LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA0080493Battery · dischargedSEA - DURING MAINTENANCE CHECK, ALL FOUR UPPER OVERWING EXIT LIGHTS WERE FOUND TO BE INOPERATIVE. REPLACED BATTERIES AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0080489Web · corrodedPHX - DURING 30K CHECK, THE FLOOR WEB AT STATION 994, LONGERON 18R WAS FOUND TO BE CORRODED. REPAIRED PER SRM 53-01. (M)SDR ASAA0080488Cargo Track · corrodedPHX - DURING 30K CHECK, THE AFT CARGO COMPARTMENT LEFT CARGO TRACK AT STATION 1220-1309, LONGERON 16L WAS FOUND TO BE EXFOLIATED. REPAIRED PER SRM 51-30-5. (M)SDR ASAA0080485Cargo Track · corrodedPHX - DURING 30K CHECK, THE AFT CARGO COMPARTMENT, RIGHT AFT CARGO TRACK WAS FOUND TO BE CORRODED AROUND THE FASTENER HOLES AT STATION 1212-1307, STRINGER 16R. REPAIRED PER SRM 51-30-0. (M)SDR ASAA0080482Battery · dischargedDURING 30K CHECK THE CABIN OVERHEAD EMERGENCY LIGHTS FROM ROW 13-22 WERE FOUND TO BE INOPERATIVE. REPLACED BATTERIES AND LIGHTS OPERATED NORMALLY.SDR ASAA0080483Relay · failedDURING 30K CHECK THE OVERWING EMERGENCY EXIT LIGHTS ILLUMINATED WHEN GENERATOR BUSSES WERE TRANSFERRED. REPLACED RELAY R2-271 AND LIGHTS OPERATED NORMALLY.SDR ASAA0080484Intercostal · crackedDURING 30K CHECK THE INTERCOSTAL WAS FOUND TO BE CRACKED AT STA 180, LBL 60. REPAIRED PER SRM 51-30-0.SDR ASAA0080486Longeron · corrodedDURING 30K CHECK AFT CARGO COMPARTMENT STA 1220 LONG. 30 WAS FOUND TO BE CORRODED WHERE THE STUB FRAME CONNECTS TO THE LONGERON. REPAIRED PER SRM 51-30-0.SDR ASAA0080487Shear Tie · corrodedDURING 30K CHECK THE AFT CARGO COMPARTMENT STA 1250 AT LONG. 30 BOTH SIDES, SHEAR TIE CLIPS CORRODED. REPAIRED PER SRM 51-30-3.SDR ASAA0080490Frame · corrodedDURING 30K CHECK CORROSION WAS FOUND ON THE AFT SIDE OF THE FRAME AT STA 1250 FROM LONG. 28L TO 28R. REPAIRED PER SRM 53-03.SDR ASAA0080491Skin · dentedDURING 30K CHECK THE LT SIDE OF THE FUSELAGE SKIN WAS FOUND TO BE DENTED ON THE MAINFRAME STA 120 JUST BELOW LONG 18L. REPAIRED PER SRM 53-04.SDR ASAA0080492Frame · gougedDURING 30K CHECK THE LT FRAME WAS FOUND GOUGED AT STA 1041 JUST ABOVE LONG. 18L. REPAIRED PER SRM 53-14-3.SDR AASA0080480Battery · dischargedDURING 30K CHECK EMERGENCY EXIT LIGHT BATTERIES AT OVERHEAD BIN AT ROW 26 R/H SIDE AND AT OVERHEAD PANEL BETWEEN FWD LAV AND FWD GALLEY WERE FOUND TO BE DISCHARGED (WOULD NOT ACCEPT CHARGE) REPLACED BATTERIES AT BOTH LOCATIONS AND SYSTEM OPERATED NORMALLY.SDR ASAA0080481Battery Pack · dischargedDURING 30K CHECK BOTH EMERGENCY OVERWING EVACUATION LIGHTS FAILED TO ILLUMINATE.REPLACED EMERGENCY OVERWING EVACUATION LIGHT BATTERY PACK AND LIGHTS OPERATED NORMALLY.SDR ASAA0080472Slide · failedPHX - DURING 30K CHECK, THE R1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE R1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR ASAA0080430Slide · failedPHX - DURING 30K CHECK, THE L1 DOOR EMERGENCY EVACUATION SLIDE FAILED THE EMERGENCY LIGHT AMP TEST. REPLACED THE L1 DOOR EMERGENCY EVACUATION SLIDE ASSEMBLY. (M)SDR ASAA0080422Web · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON SUB FLOOR WEB, FS 180-200, LBL 6 TO RBL 6. REMOVED DAMAGED MATERIAL AND INSTALLED REPAIR SECTION IAW DC9 SRM 51-30-02 AND 53-01. (M)SDR ASAA0080421Web · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON FLOOR WEB, FS 740, LONGERON 18R. REMOVED AND REPLACED WEB FROM FS 710 TO 788 IAW DC9 SRM 51-30-02 AND 51-30-05. (M)SDR ASAA0080419Web · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON CUSP WEB, FS 598 TO 712, LONGERON 18L. REMOVED AND REPLACED WEB IAW DC9 SRM 51-30-01. (M)SDR ASAA0080426Cargo Track · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON CARGO TRACK, FS 1079-1155, RBL 16. REMOVED CORROSION AND FOUND TRACK OUT OF LIMITS FROM FS 1108 TO 1155. REPLACED CARGO TRACK SECTION IAW DC9 SRM 51-30. (M)SDR ASAA0080425Cargo Track · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON CARGO TRACK, FS 1155-1211, LONGERON 29R. REMOVED AND REPLACED CARGO TRACK SECTION IAW DC9 SRM 51-30. (M)SDR ASAA0080420Service difficultyPHX-DURING 30K CHECK CORROSION WAS FOUND ON SUB FLOOR CUSP WEB, FS 1180, LBL 56.REMOVED DAMAGED MATERIAL AND INSTALLED FILLER AND DOUBLER IAW DC9 SRM 53-14-03.SDR ASAA0080423Seat Track · corrodedPHX-DURING 30K CHECK CORROSION WAS FOUND ON SEAT TRACK, FS 1100-1307, LBL 22.REMOVED CORROSION AND FOUND TRACK OUT OF LIMITS FROM FS1100 TO 1165. REPLACED SEAT TRACK SECTION FROM FS 1040 TO 1165 IAW DC9 SRM 53-05, FIG 4B.SDR ASAA9980187Wire · failedSEA - DURING MAINTENANCE CHECK, THE TWO EMERGENCY FLOOR TRACK RED LIGHTS FOR THE L2 DOOR EXIT WERE FOUND INOPERATIVE. REPLACED THE WIRING IN THE FLOOR TRACK AND OPERATED NORMALLY. (M)
Back to N965AS