N746AS
Service difficulty reports not matched to an aircraft · 606
They name N746AS, 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 = 'N746AS' 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 = 'N746AS' 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 ASAA0110335Skin · dentedPAE - DURING SCHEDULED C-CHECK, FOUND FAIRING SKIN AT NACELLE STATION 113.79, NACELLE WATERLINE 126.14 DENTED. REPAIRED PER EA. (M)SDR ASAA0110317Stringer · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND STRINGER 21L AT BS 810, CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110316Stringer · crackedPAE - DURING SCHEDULED C-CHECK, FOUND STRINGER 27R AT BS 490, CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110314Keelbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND KEEL BEAM AT BS 525-530, STRINGER 28R CORRODED. REPAIRED PER EA. (M)SDR ASAA0110315Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND CHORD AT BS 668-670, RBL 25 CORRODED. REPAIRED PER EA. (M)SDR ASAA0110238Control Unit · inoperativeSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHTS IN THE MID CABIN INOPERATIVE. REMOVED AND REPLACED CONTROL MODULE, THEN LIGHTS OPERATED NORMALLY. (M)SDR ASAA0110209Receiver · dischargedANC - DURING MAINTENANCE CHECK, FOUND EMERGENCY TRACK LIGHTS INOPERATIVE ON SEAT PALLET 6-4, ROW 11. REMOVED AND REPLACED REMOTE ASSEMBLY RECEIVER, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0110207Battery · dischargedANC - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHT AT LEFT OVERWING EXIT DOOR INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY AND SIGN OPERATED NORMAL. (M)SDR 20010417SG001Receiver · inoperativeSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHTS ON SEAT PALLET 6-10 INOPERATIVE. REPLACED REMOTE ASSEMBLY BATTERY AND RECEIVER, LIGHTS FUNCTION NORMAL. REF ASAA0110110. (M)SDR ASAA0110110Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHTS ON SEAT PALLET 6-10 INOPERATIVE. REPLACED REMOTE ASSEMBLY BATTERY AND RECEIVER, LIGHTS FUNCTION NORMAL. (M)SDR 20010329SG001Receiver · inoperativeSEA - DURING MAINTENANCE CHECK, FOUND EXIT LIGHTS ON SEAT PALLET 5-7 INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY AND RECEIVER AND LIGHTS OPERATED NORMALLY. REF ASAA0110098. (M)SDR ASAA0110098Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND EXIT LIGHTS ON SEAT PALLET 5-7 INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY AND RECEIVER AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0110066Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHTS ON SMOKE BARRIER AND ROW 9 FAILED OPERATIONS TEST. REPLACED REMOTE ASSEMBLY BATTERY FOR SMOKE BARRIER AND ROW 9, LIGHTS OPERATED NORMALLY. (M)SDR ASAA0110034Battery Pack · dischargedANC - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHTS AT ROW 8 WILL NOT EXTINGUISH. REMOVED AND REPLACED BATTERY PACK, LIGHTS OPERATED NORMALLY. (M)SDR ASAA0110031Battery Pack · dischargedANC - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT OVER L2 DOOR INOPERATIVE. REPLACED EMERGENCY EXIT BATTERY PACK, LIGHTS THEN TESTED NORMAL. (M)SDR ASAA0010181Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, FOUND LEFT OVERWING EMERGENCY TRACK LIGHT EXIT SIGN INOPERATIVE. REPLACED BATTERY PACK, EXIT SIGN TESTED NORMAL. (M)SDR 20010112SG061Light · inoperativeSEA - DURING MAINTENANCE CHECK, FOUND L-1, R-1, AND R-2 DOOR EMERGENCY EXIT IDENTIFIERS INOPERATIVE. REPLACED BATTERIES FOR L-1 AND R-1 DOOR EXIT IDENTIFIERS. REPLACED LIGHT ASSEMBLY FOR R-2 DOOR. ALL OPS CHECK NORMALLY. REF ASAA0010180. (M)SDR 20010112SG060Light · inoperativeSEA - DURING MAINTENANCE CHECK, FOUND L-1, R-1, AND R-2 DOOR EMERGENCY EXIT IDENTIFIERS INOPERATIVE. REPLACED BATTERIES FOR L-1 AND R-1 DOOR EXIT IDENTIFIERS. REPLACED LIGHT ASSEMBLY FOR R-2 DOOR. ALL OPS CHECK NORMALLY. REF ASAA0010180. (M)SDR ASAA0010180Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND L-1, R-1, AND R-2 DOOR EMERGENCY EXIT IDENTIFIERS INOPERATIVE. REPLACED BATTERIES FOR L-1 AND R-1 DOOR EXIT IDENTIFIERS. REPLACED LIGHT ASSEMBLY FOR R-2 DOOR. ALL OPS CHECK NORMALLY. (M)SDR ASAA0010152Battery Pack · dischargedSEA-DURING MAINTENANCE CHECK FOUND EMERGENCY EXIT LIGHTS ON SEAT PALLET INOPERATIVE. REPLACED EMERGENCY EXIT LIGHTS BATTERY PACK AND RECEIVER AND LIGHTS OPERATED NORMALLY.SDR ASAA0010134Sign · inoperativeSEA DURING MAINTENANCE CHECK THE SMOKE BARRIER EXIT TO REAR EXIT IDENTIFIER WAS FOUND TO BE INOPERATIVE. REPLACED EXIT IDENTIFIER AND THE BATTERY PACK SYSTEM OPERATED NORMALLY.SDR ASAA0010131Battery Pack · dischargedANC - PRIOR TO FLT 55, THE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND TO BE DIM OR INOPERATIVE. REPLACED BATTERY PACKS AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0010079Battery Pack · dischargedANC - DURING TAXI OUT FOR FLIGHT 55, THREE EMERGENCY EXIT TRACK LIGHTS ILLUMINATED. RETURNED TO GATE. REPLACED BATTERY PACK AT PALLET 7-2 AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0010076Wire · disconnectedSEA - DURNIG MAINTENANCE CHECK, THE EMERGENCY EXIT TRACK LIGHTS WERE FOUND TO BE INOPERATIVE. REPAIRED AFT EMERGENCY EXIT TRACK LIGHT WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0010068Battery · dischargedANC - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT LIGHT AT ROW 5 WAS FOUND TO BE INOPERATIVE. REPLCED BATTERY AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0010062Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTING FOR SEVERAL PALLET RECEIVERS WAS FOUND INOPERATIVE. REPLACED BATTERY PACK AT ROW 12 AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0010051Wire · disconnectedANC - PRIOR TO FLIGHT 153, AN EMERGENCY EXIT TRACK LIGHT WAS FOUND INOPERATIVE AT ROW 10. RELEASED PER MEL 33-19B. MAINTENANCE SUBSEQUENTLY SLICED WIRING AT LIGHT SOCKET AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0010050Battery Pack · dischargedANC - DURING MAINTENANCE CHECK, SEAT PALLET 6-1 EMERGENCY EXIT LIGHTS WERE FOUND TO BE INOPERATIVE. REPLACED BATTERY PACK AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0010047Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT TRACK LIGHTS AT ROW 16 AND AT THE RIGHT OVERWING EXIT WERE FOUND TO BE INOPERATIVE. REPLACED BATTERY PACKS AT BOTH POSITIONS AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0010044Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, THE R-1 DOOR EMERGENCY EXIT LIGHT WAS FOUND LOW ON POWER. REPLACED BATTERY PACK AND THE LIGHTS OPERATED NORMALLY. (M)SDR ASAA0010022Battery · dischargedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROW 18 WERE FOUND TO BE INOPERATIVE. REPLACED BATTERY AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA0010002Handle · lack of lubeANC - PRIOR TO FLIGHT 153, THE L2 DOOR WAS FOUND DIFFICULT TO CLOSE. LUBRICATED HANDLE AND DOOR OPERATED NORMALLY. (M)SDR ASAA0110010Receiver · inoperativeANC - DURING MAINTENANCE CHECK, FOUND EMERGENCY TRACK LIGHTS INOPERATIVE ON SEAT PALLET 9-1. REMOVED AND REPLACED REMOTE ASSEMBLY RECEIVER. LIGHTS OPERATED NORMALLY. (M)SDR ASAA9910260Battery · dischargedSEA - DURING MAINTENANCE CHECK, THE R1 DOOR LOWER EMERGENCY EXIT IDENTIFIER LIGHT WAS FOUND TO BE INOPERATIVE. REPLACED THE BATTERY AND THE LIGHT OPERATED NORMALLY. (X)SDR ASAA9910249Battery · dischargedSEA - DURING MAINTENANCE CHECK, R1 DOOR LOWER EMERGENCY EXIT LIGHT WAS FOUND INOPERATIVE. REPLACED BATTERY AND LIGHT OPERATED NORMALLY. (X)SDR ASAA9910240Transmitter · failedSEA - PRIOR TO FLT 63, THE EMERGENCY FLOOR TRACK LIGHTING AND THE R1 AND L2 DOOR RECEIVERS WERE FOUND INOPERATIVE. REPLACED THE EMERGENCY FLOOR TRACK LIGHTING MID-CABIN TRANSMITTER, THE R1 DOOR RECEIVER BATTERIES, AND THE L2 DOOR RECEIVER. ALL LIGHTS OPERATESDR ASAA9910239Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK THE R2 DOOR EMERGENCY EXIT LIGHT WAS FOUND INOPERATIVE. REPLACED BATTERY PACK AND LIGHT OPERATED NORMALLY. (X)SDR 99ZZZX4629Battery · dischargedSEA - PRIOR TO FLT 63, THE EMERGENCY FLOOR TRACK LIGHTING AND THE R1 AND L2 DOOR RECEIVERS WERE FOUND INOPERATIVE. REPLACED THE EMERGENCY FLOOR TRACK LIGHTING MID-CABIN TRANSMITTER, THE R1 DOOR RECEIVER BATTERIES, AND THE L2 DOOR RECEIVER. ALL LIGHTS OPERATESDR 99ZZZX4628Receiver · failedSEA - PRIOR TO FLT 63, THE EMERGENCY FLOOR TRACK LIGHTING AND THE R1 AND L2 DOOR RECEIVERS WERE FOUND INOPERATIVE. REPLACED THE EMERGENCY FLOOR TRACK LIGHTING MID-CABIN TRANSMITTER, THE R1 DOOR RECEIVER BATTERIES, AND THE L2 DOOR RECEIVER. ALL LIGHTS OPERATESDR ASAA9910235Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT TRACK LIGHTS AT ROWS 14 AND 15 WERE FOUND TO BE INOPERATIVE. REPLACED BATTERY PACK AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9910234Battery · dischargedANC - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT LIGHT NEAR THE L1 DOOR WAS FOUND TO BE FLASHING CONTINUOUSLY. REPLACED BATTERY AND LIGHT OPERATED NORMALLY. (M)SDR ASAA9910230Receiver · inoperativeSEA - PRIOR TO FLIGHT 65, THE EMERGENCY EXIT LIGHT RECEIVER AT ROW 12 WAS FOUND TO BE INOPERATIVE. REPLACED RECEIVER AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9910223Battery Pack · dischargedANC - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT TRACK LIGHTS AT ROW 5 WERE FOUND TO BE INOPERATIVE. REPLACED BATTERY PACK AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9910217Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, THE L1 DOOR AND RIGHT OVERWING EXIT LIGHTS WERE FOUND TO BE VERY DIM. REPLACED BATTERY PACKS AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9910213Battery · dischargedSEA - PRIOR TO FLIGHT 61, THE SMOKE BARRIER EMERGENCY EXIT LIGHT WAS FOUND TO BE INOPERATIVE. REPLACED BATTERY AND LIGHT OPERATED NORMALLY. (M)SDR ASAA9910215Handle · inoperativeANC - PRIOR TO FLT 41, THE AFT AIRSTAIR DOOR HANDLE WAS FOUND TO BE INOPERATIVE. INSPECTED AND FOUND THE PUSH PULL CABLE SHEAR RIVET BROKEN. REPLACED SHEAR RIVET AND THE DOOR HANDLE OPERATED NORMALLY. (M)SDR ASAA9910136Battery Pack · dischargedJNU - PRIOR TO FLT 61, THE EMERGENCY EXIT FLOOR TRACK LIGHTS ILLUMINATED AT ROWS 14 AND 15. REPLACED BATTERY PACK AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9910135Transmitter · inoperativeSEA - PRIOR TO FLT 65, THE R1 AND L2 DOOR EMERGENCY LIGHTS WOULD NOT TEST. REPLACED R1 DOOR TRANSMITTER AND L2 DOOR RECEIVER, LIGHTS OPERATED NORMALLY. REF: OPER CNTRL NR 99ZZZX2832. (X)SDR 99ZZZX2832Receiver · inoperativeSEA - PRIOR TO FLT 65, THE R1 AND L2 DOOR EMERGENCY LIGHTS WOULD NOT TEST. REPLACED R1 DOOR TRANSMITTER AND L2 DOOR RECEIVER, LIGHTS OPERATED NORMALLY. REF: OPER CNTRL NR ASAA9910135.SDR ASAA9910130Receiver · defectiveSEA - DURING MAINTENANCE CHECK, SEVERAL EMERGENCY EXIT LIGHT RECEIVERS WOULD NOT TEST PROPERLY. REPLACED RECEIVERS AT ROWS 14 AND 20, AND BATTERY AT ROW 18 AND AT THE R-1 DOOR. ALL EMERGENCY EXIT LIGHTS OPERATED NORMALLY. REF: OPER CNTRL NR 99ZZZX2833. (X
Back to N746AS