N760AS
Service difficulty reports not matched to an aircraft · 283
They name N760AS, 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 = 'N760AS' 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 = 'N760AS' 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 ASAA9940157Battery Pack · dischargedANC - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS IN THE FIRST CLASS CABIN OPERATED NORMALLY INITIALLY AND THEN BECAME INOPERATIVE. REPLACED BATTERY PACK AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9940131Support · crackedPHX - DURING SCHEDULED SI CHECK, THE RT AILERON INBOARD HINGE SUPPORT WAS FOUND TO BE CRACKED AT THE NUTPLATE, OUTBOARD SIDE. REPAIRED PER EA 5740-01177. (M)SDR ASAA9940130Chord · corrodedPHX - DURING SCHEDULED SI CHECK, THE RIGHT INNER CHORD AT THE R2 DOOR STATION 947.5 TO 957.5 WAS FOUND TO BE CORRODED. REPAIRED PER SRM 51-40-02. (M)SDR ASAA9940129Floorbeam · corrodedPHX - DURING SCHEDULED SI CHECK, THE FLOORBEAM CAP UPPER SURFACE AT STATION 344, LBL 40-56 WAS FOUND TO BE CORRODED. REPAIRED PER SRM 53-00-51, FIG 203. (M)SDR ASAA9940128Skin · lightning strikePHX - DURING SCHEDULED SI CHECK, THE EXTERNAL FUSELGE SKIN AT BS 360, STRINGER 17L WAS FOUND TO HAVE 2 LIGHTNING STRIKES. REPAIRED PER SRM 53-00-01, FIG 223. (M)SDR ASAA9940127Floorbeam · damagedPHX - DURING SCHEDULED SI CHECK, THE TOP FLANGES OF THE FLOORBEAM AT STATION 986.5, LBL 33 - RBL 30 WERE FOUND TO BE GOUGED AND CORRODED. REPAIRED PER EA 5310-01697. (M)SDR ASAA9940126Floorbeam · corrodedPHX - DURING SCHEDULED SI CHECK, THE FORWARD AND AFT FLANGES OF THE FLOORBEAM AT STATION 947.5, LBL 12-RBL 10 WERE FOUND TO BE CORRODED. REPAIRED PER EA 5310-01702. (M)SDR ASAA9940125Frame · dentedPHX - DURING SCHEDULED SI CHECK, THE AFT CARGO COMPARTMENT TOP OF MAIN FRAME WAS FOUND TO BE DENTED AT BS 727E 30 INCHES BELOW STRINGER 22R AND BS 727F ABOVE STRINGER 25R. REPAIRED PER EA 5310-01701. (M)SDR ASAA9940124Floorbeam · corrodedPHX - DURING SCHEDULED SI CHECK, THE FLOORBEAM CAP UPPER SURFACE AT STATION 312 LBL 12 TO RBL 12 WAS FOUND TO BE CORRODED. REPAIRED PER SRM 53-10-01 FIG 205. (M)SDR ASAA9940123Floorbeam · corrodedPHX - DURING SCHEDULED SI CHECK, THE FORWARD AND AFT TOP FLANGED OF THE FLOORBEAM AT STATION 967, LBL 14-21 AND 23-33 WAS FOUND TO BE CORRODED. REPAIRED PER SRM 53-00-51 FIG 202. (M)SDR ASAA9940058Wire · failedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT TRACK LIGHTING WAS FOUND TO BE INOPERATIVE AT ROWS 6-9. REPLACED WIRING HARNESS AT ROW 6, LIGHTS OPERATED NORMALLY. (M)SDR ASAA9840072Connector · looseKTN - FLT 73 - PRIOR TO FLT, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROW 22-25 WOULD NOT ILLUMINATE DURING TEST. SECURED LOOSE CONNECTOR AT ROW 25 AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9540103Wire · disconnectedSEA - FLT NR 62 - CREW REPORTED AFT 4 EMERGENCY EXIT FLOOR TRACK LIGHTS WERE INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9540101Wire · disconnectedSEA - FLT NR 279 - CREW REPORTED, AFT MOST SECTION OF EMERGENCY EXIT FLOOR TRACK LIGHTING WAS INOPERATIVE. INSTALLED NEW LENS COVER AND SECURED TRACK AND WIRING, LIGHTS OPERATED NORMALLY. (M)SDR ASAA9540094End Stop · defectiveSEA - DURING MAINTENANCE CHECK, THE AFT 5 EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. REPLACED END STOP SECTION AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9540093Eel Wiring · disconnectedSEA - DURING MAINTENANCE CHECK, THE AFT 5 EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9540091Wire · disconnectedJNU - DURING MAINTENANCE CHECK, THE AFT 4 EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9540090Eel Wiring · disconnectedJNU - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROWS 22 THROUGH 26 WERE FOUND INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9540089Eel Wiring · disconnectedSEA - FLT 625 - THE AFT 4 EMERGENCY EXIT FLOOR TRACK LIGHTS WERE INOPERATIVE. RECONNECTED WIRING AT AFT GALLEY NR 3 AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9540087Eel Wiring · disconnectedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE FROM ROW 25 AFT. RECONNECTED WIRING AT ROW 25 AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9540086Eel Wiring · disconnectedSEA - DURING MAINTENANCE CHECK, THE AFT 3 EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. RECONNECTED WIRING ON AFT TRACK AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9540082Eel Wiring · disconnectedJNU - DURING MAINTENANCE CHECK, THE AFT 3 EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. RECONNECTED WIRING ON AFT TRACK AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9540073Eel Wiring · disconnectedSEA - FLT NR 191 - CREW REPORTED AFT SECTION OF EMERGENCY EXIT FLOOR TRACK LIGHTS INOPERATIVE. REPAIRED WIRING CONNECTION ON AFT TRACK AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9540068Eel Wiring · disconnectedSEA - DURING MAINTENANCE CHECK, THE FORWARD AND AFT THREE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. RECONNECTED WIRING AT FORWARD AND AFT TRACKS AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9540059Eel Wiring · disconnectedANC - DURING MAINTENANCE CHECK, THE AFT THREE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. RECONNECTED AFT FLOOR TRACK WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9540042Eel Assy · inoperativeSEA - DURING MAINTENANCE CHECK, THE FORWARD RED EMERGENCY EXIT FLOOR TRACK LIGHT WAS FOUND INOPERATIVE. REPLACED LIGHT ASSEMBLY AND OPERATED NORMALLY. (M)SDR ASAA9540041Eel Wiring · disconnectedSEA - DURING MAINTENANCE CHECK, THE AFT THREE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. RECONNECTED LIGHTS AND OPERATED NORMALLY. (M)SDR ASAA9540039Eel Wiring · disconnectedSEA - CHECK, AFT THREE TRACK LIGHTS INOP. MAINTENANCE RECONNECTED LIGHTS. (W)SDR ASAA9540037Eel Wiring · disconnectedSEA - CHECK, AFT THREE TRACK LIGHTS INOP. MAINTENANCE RECONNECTED WIRING. (W)SDR ASAA9540027Eel Wiring · disconnectedSEA - AFT THREE PEEPLS LIGHTS INOP. MAINTENANCE RECONNECTED WIRING. (M)SDR ASAA9540012Eel Wiring · disconnectedSEA - DURING MAINTENANCE CHECK, THE FORWARD FOUR AND AFT FLOOR TRACK EMERGENCY EXIT LIGHTS WERE FOUND INOPERATIVE. RECONNECTED WIRING AND LIGHTS OPERATED NORMALLY. (W)SDR ASAA9569Eel Track · damagedSEA - PILOT REPORTED, LAST 5 EMERGENCY TRACK LIGHTS DO NOT ILLUMINATE. REPLACED LIGHT SECTION AT ROW 26 AND SECURED LIGHT LENS. (W)SDR ASAA9531Eel Wiring · loosePDX - CHECK, FLOOR TRACK LIGHTS INOP AT ROWS 28-36. MAINTENANCE RECONNECTED LOOSE BUS WIRE IN TRACK. (W)
Back to N760AS