N635AS
Service difficulty reports not matched to an aircraft · 87
They name N635AS, 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 = 'N635AS' 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 = 'N635AS' 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 ASOA05300Housing · corrodedDURING A C-CHECK, THE HOUSING ON FUEL PANEL 622CT BETWEEN RIBS 4 AND 5 ON THE RT WING WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED THE HOUSING ON FUEL PANEL 622CT BETWEEN RIBS 4 AND 5 ON THE RT WING IAW EO. (K)SDR ASOA05301Frame · corrodedDURING A C-CHECK, THE FAIL SAFE FRAME SEGMENT IN THE AFT AVIONICS COMPARTMENT AT FR46, STRINGER 19L AND 19R WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FAIL SAFE FRAME SEGMENT IN THE AFT AVIONICS COMPARTMENT AT FR 46, STRINGERSDR ASOA04881Skin · crackedDURING HANGAR MAINTENANCE, THE FUSELAGE SKIN AT THE T/E OF THE AFT EQUIPMENT COMPARTMENT ACCESS WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE PERFORMED A TEMPORARY REPAIR TO THE FUSELAGE SKIN AT THE T/E OF THE AFT EQUIPMENT COMPARTMENT ACCESS BY STOP DRISDR ASOA04667Module · shortedFLT 4258 - FOLLOWING TAKEOFF FROM ATL-DHN, THE FLIGHT ATTENDANT NOTICED SMOKE IN THE CABIN. THE PILOT VERIFIED WITH THE FILGHT ATTENDANT THAT NO FIRE WAS PRESENT. AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO ATL, LANDING SAFELY. MAINTENANCE FOUND SDR ASOA04581Wire · brokenFLT 4276 - DURING A GROUND INSPECTION IN ATL, THE WIRING TO THE TWO AFT EMERGENCY FLOOR LIGHTS WAS FOUND BROKEN AND THE LENS COVER LOOSE. MAINTENANCE RESECURED THE WIRING AND LENS COVER ONTHE TWO AFT EMERGENCY FLOOR LIGHT TRACKS. OPERATIONAL CHECKS GOOD. AISDR ASOA04508Light · inoperativeDURING AN A-CHECK IN MCN, THE EMERGENCY LIGHT ON THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT ASSEMBLY ON TH PASSENGER DOOR. OPS CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA04377Lamp · burned outDURING A GROUND INSPECTION, THE EMERGENCY LIGHT ON THE PASENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT LAMP ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE.SDR ASOA04206Warning Light · illuminatedDURING APPROACH INTO AVL FROM ATL, THE CREW RECEIVED A FLAP UNLOCK MESSAGE WITH A MASTER WARNING. A GO-AROUND WAS INITIATED AND THE CREW REQUESTED EMERGENCY EQUIPMENT AS A PRECAUTION. A ZERO DEGREE FLAP LANDING WAS ACCOMPLISHED AND THE AIRCRAFT LANDED SAFELYSDR ASOA03639Lamp · burned outDURING HANGAR INSPECTION, THE PASSENGER DOOR EMERGENCY LIGHT WAS FOUND INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE PASSENGER DOOR EMERGENCY LIGHT LAMP. OPS CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA03444Seat Track · corrodedDURING A C-CHECK IN BNA, THE LEFT AND RIGHT SEAT TRACKS AT FS 36 TO FS 39 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT AND RIGHT SEAT TRACKS AT FS 36 TO FS 39 IAW SRM 51-25-02. (M)SDR ASOA03445Seat Track · corrodedDURING A C-CHECK IN BNA, THE LEFT SEAT TRACK AT FS 39 TO FS 41 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT SEAT TRACK AT FS 39 TO FS 41 IAW SRM 51-25-02. (M)SDR ASOA03446Seat Track · corrodedDURING A C-CHECK IN BNA, THE RT SEAT TRACK AT FS 39 TO FS 40 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT SEAT TRACK AT FS 39 TO FS 40 IAW SRM 51-25-02. (M)SDR ASOA03443Bracket · corrodedDURING A C-CHECK IN BNA, THE TAIL CONE MOUNTING BRACKETS AND SEAL RETAINERS WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE TAIL CONE MOUNTING BRACKETS AND SEAL RETAINERS IAW SRM 51-25-01. (M)SDR ASOA03321Cover · looseDURING A GROUND INSPECTION IN ATL, THE EMERGENCY EXIT LIGHT COVER AT THE SERVICE DOOR WAS FOUND TO BE UNSECURED. MAINTENANCE RESECURED THE EMERGENCY EXIT LIGHT COVER AT THE SERVICE DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA03263Doubler · crackedDURING AN A-CHECK IN MCN, THE FORWARD PASSENGER/CREW DOOR FIRST STEP DOUBLER WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE PERFORMED A TEMPORARY REPAIR OF THE FORWARD PASSENGER/CREW DOOR FIRST STEP DOUBLER IAW ASA EO 72-52-0072. (M)SDR ASOA03104Light · inoperativeDURING HANGAR MAINTENANCE IN MCN, THE PASSENGER DOOR EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE PASSENGER DOOR EMERGENCY LIGHT ASSEMLBY. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA03058Light · inoperativeDURING A HANGAR CHECK IN MCN, THE FLOOR EMERGENCY LIGHT AT SEATS 14 A-B WAS FOUND TO BE INOPERATIVE. MAINTENANCE REPAIRED A FLOOR EMERGENCY LIGHT GROUND WIRE AT SEATS 14 A-B. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA01283Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE RIGHT INBOARD SEAT TRACK, AT FRAME 35 TO 36, WAS FOUND TO HAVE CORROSION. MAINTENANCE REPAIRED CORRODED IAW ASA E072-53-0123. THIS EO REF FAA FROM 8110-3, REPORT NR 01-295, WHICH INCLUDES REPAIR SPECIFICATIONS FOR AIRCRASDR ASOA01282Floorboard · corrodedDURING C-CHECK INSPECTION IN BNA, THE FLOORBOARD SCREW HOLES AT FRAMES 9 AND 10 SHOWED SIGNS OF CORROSION AND SEVERAL ELONGATED HOLES WERE FOUND. MAINTENANCE REMOVED CORROSION AND REPAIRED ELONGATED HOLES WERE FOUND. MAINTENANCE REMOVED CORROSION AND REPAIRESDR ASOA01281Floorboard · corrodedDURING C-CHECK INSPECTION IN BNA, THE TOP AND BOTTOM SURFACES OF THE FLOORBOARDS TOP FLANGE WERE FOUND TO BE CORRODED AT FRAMES 36, 38, 39, AND 40. MAINTENANCE REPAIRED CORROSION IAW WITH ASA EO72-53-0123. THIS EO REFERENCE FAA FORM 8110-3, REPORT NR 01-295,SDR ASOA01277Attach Fitting · damagedDURING C-CHECK INSPECTION IN BNA, THE LEFT AFT WING FITTING AT FRAME 27 WAS FOUND TO BE ELONGATED. THE HOLE IN THE FRAME WAS ALSO ELONGATED. MAINTENANCE FABRICATED A NEW FITTING AND REPAIRED THE ELONGATED HOLE IAW ASA EO 72-53-0122. THIS EO REF SRM 51- AND SDR ASOA01276Frame · crackedDURING C-CHECK INSPECTION IN BNA, A CRACK WAS FOUND ON FRAME 26 AT BL 0. MAINTENANCE REPAIRED THE CRACK IN FRAME 26 IAW ASA E072-53-0121. THIS AIRCRAFT WILL RETURN TO SERVICE UPON COMPLETION OF C-CHECK. (M)SDR ASOA01062Battery PackON GROUND IN ATL, CAPTAIN REPORTS RIGHT FRONT EMERGENCY EXIT LIGHT IS OUT. MAINTNANCE REMOVED AND REPLACED EMERGENCY EXIT LIGHT ON THE RIGHT SIDE AND THE BATTERY PACK AT 43VU. AIRCRAFT RETURNED TO SERVICE. (M)SDR ASOA00120Line · inoperativeFLT 4082 - IN FLIGHT FROM CSG-ATL, CREW REPORTED WHEN THE LANDING GEAR WAS LOWERED A MASTER CAUTION MESSAGE ON THE GREEN HYDRAULIC SYSTEM. THE LANDING GEAR WAS SHOWING DOWN AND LOCKED WITH THE GREEN HYDRAULIC PRESSURE SHOWING ZERO. CREW DECLARED AND EMERGENCSDR ASOA98023Igniters · malfunctionedIN CRUISE FLIGHT CSG-ATL, WITH CONTINUOUS RELIGHT ON, RIGHT ENGINE TORQUE DROPPED TO ZERO FOR 8-10 SECONDS. ENGINE RELIT ON ITS OWN AND CONTINUED FOR THE REMAINDER OF THE FLIGHT. UPON LANDING, CONTINUOUS RELIGHT COULD NOT BE EXTINGUISHED. ATL MAINTENANCE BOSDR 98ZZZX1570Support · corrodedDURING C-CHECK INSPECTION, MAINTENANCE REPORTED RT Z-MEMBER CORRODED AT FRAMES 39-41. INSTALLED NEW RT Z-MEMBER IAW ATR 72 SRM 51-25-03. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX1567Filler · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED FILLER PLATE ON SILL PLATE CORRODED. FABRICATED AND INSTALLED NEW PLATE IAW BASIC SHEET METAL PRACTICES AND INSTALLED IAW ASA EO 72-43-011. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX1566Seat Track · corrodedSAW - DURING '4 C' CHECK INSPECTION, MAITNENANCE REPORTED RT AFT CARGO SEAT TRACK CORRODED BEYOND LIMITS. INSTALLED NEW RT AFT CARGO SEAT TRACK IAW ASA EO 72-53-0036. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX1565Seat Track · corrodedSAW - DURING '4 C' CHECK INSPECTION, MAINTENANCE REPORTED RT FA SEAT TRACK CORRODED. INSTALLED NEW RT FA SEAT TRACK IAW ASA EO 72-53-0035. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX1564Seat Track · corrodedSAW - DURING '4 C' CHECK INSPECTION, MAINTENANCE REPORTED LT FA SEAT TRACK CORRODED. INSTALLED NEW LT FA SEAT TRACK IAW ASA EO 72-53-0035. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX1569Support · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED SERVICE DOOR FLOOR SUPPORT CORRODED FRAMES 38-39. REPLACED FLOOR SUPPORT IAW ATR 72 SRM 51-25-03. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX1563Channel · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED PASSENGER DOOR FLOOR SUPPORT CORRODED FRAMES 38 - 39. REPLACED FLOOR SUPPORT AT PASSENGER DOOR BETWEEN FRAMES 38 AND 39 IAW SRM 51-25-01. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX1562Seat Track · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED RIGHT INBOARD AFT SEAT TRACK TO BE CORRODED. REPLACED RIGHT AFT INBOARD SEAT TRACK IAW ASA E.O. 72-53-0036. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX1568Sill · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED SERVICE DOOR SILL PLATE CORRODED. INSTALLED SERVICE DOOR SILL PLATE KIT A01 IAW EO 72-53-0011 AND SB ATR 72-53-1048. AIRCRAFT RETURNED TO SERVICE.SDR ASOA97041Latch · not latchedON FINAL APPROACH AGS-ATL, RECEIVED A RIGHT ENG FIRE WARNING AT 200'. CREW ADVISED THE TOWER AND TOWER REPORTED VISIBLE FLAME. THE CREW DECLARED AN EMERGENCY, LANDED THE A/C AND PULLED THE T-HANDLE, THE WARNING REMAINED. THE F/O FIRED OFF THE ENG FIRE BOTTLSDR ASOA97006Batteries · dischargedCAPTAIN TESTED THE EMERGENCY LIGHT SYSTEM WITH A/C ON BATTERY POWER ONLY AND FOUND SEVERAL FLOOR LIGHTS AND OVERHEAD DOME LIGHTS FLICKERING. REMOVED AND REPLACED EMERGENCY LIGHT BATTERIES IAW MM. OPERATIONAL CHECKS WERE GOOD AND THE AIRCRAFT WAS RETURNED TO SDR ASOA97003Actuator · failedRECEIVED A 'PITCH MISTRIM' MESSAGE ON ADU IN FLIGHT ATL-TRI. PILOT DISCONNECTED THE AUTOPILOT AND ATTEMPTED TO TRIM MANUALLY AS WELL AS USING THE STANDBY SYSTEM. NO TRIM LESS THAN 1/4 NOSE DOWN TRIM WAS AVAILABLE. AIRCRAFT RETURNED TO ATL WHERE LANDING WAS
Back to N635AS