N634AS
Service difficulty reports not matched to an aircraft · 107
They name N634AS, 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 = 'N634AS' 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 = 'N634AS' 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 TRAX200600767Keelbeam · corrodedKEELBEAM DTW FR 25 & 27 FEW SPOTS CORRODED.SDR TRAX200600766Buttstrap · corrodedBUTT STRAP OF FWD FR 27 RT CORRODED.SDR TRAX200600764Buttstrap · corrodedBUTT STRAP CORRODED ON FR 24 LEFT OF MLG.SDR TRAX200600763Buttstrap · corrodedBUTT STRAP CORRODED ON FWD FR27 LT OF MLG.SDR TRAX200600792Light · inoperativeINSPECT AND REPAIR EMERGENCY LIGHT TRACKS AS REQ'D. (RESOLVED ON W/O: 36809 TASKCARD: N/R-00054 ) EMERGENCY LIGHT TRACKS INSPECTED IAW IPC 33-51-20 PARTS ORDERED. TRACKS 1, 3, 4 REPAIRED USING PARTS FORM TRACKS 5, 6, 8 IAW IPC 33-51-20. EMERGENCY LIGHT TRASDR TRAX200600793Light · inoperativePAX DOOR EMERGENCY FLOOD LIGHT IS INOP.SDR TRAX200600747Cover · missingEMERGENCY (EXIT) LIGHT COVER MISSING AT AFT SERVICE DOOR.SDR TRAX200600345Light · inoperativeEMERGENCY LIGHT TRACK LIGHT INOP. (CLOSED)SDR TRAX200600296Cover · looseF/A REPORT AN EMERGENCY EXIT SIGN COVER IN GALLEY IS COMING LOOSESDR TRAX200600164Light · inoperativeFOUND EMERGENCY LIGHT OUT ON FLOOR TRACKING.SDR ASOA06217Engine · shutdownDURING DESCENT, THE RT ENGINE AUTOMATICALLY SHUTDOWN AND FEATHERED. THE CREW ATTEMPTED TO RESTART THE RT ENGINE BUT WAS UNSUCCESSFUL. THE QRH WAS COMPLIED WITH AN AN EMERGENCY WAS DECLARED. A SINGLE ENGINE LANDING WAS PERFORMED SAFELY. REVEALED THAT THE EESDR ASOA06093Engine · shutdownDURING CRUISE, THE CREW NOTICED THE RT ENGINE SPOOLING DOWN ACCOMPANIED BY THE TORQUE AND THE NP DROPPING TO 20 PERCENT AND THEN PASSING THROUGH 4 PERCENT. THE CREW COMPLIED WITH THE QRH, SHUTDOWN THE RT ENGINE AND MANUALLY FEATHERED THE PROPELLER. AN EMERGESDR ASOA051140Lens · crackedDURING A HANGAR INSPECTION, THE EMERGENCY EXIT LIGHT LENS COVERS, AT ROWS 17, 10, 8 AND 1, WERE FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY EXIT LENS COVERS, AT ROWS 17, 10, 6 AND 1. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. SDR ASOA051141Light · burned outDURING A HANGAR INSPECTION, THE EMERGENCY FLOODLIGHT, ON THE PASSENGER DOOR STEPS, WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY FLOODLIGHT ASSY ON THE PASSENGER DOOR STEPS. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (K)SDR ASOA051123Power Supply · defectiveDURING A GROUND INSPECTION IN ATL, THE EMERGENCY EXIT SIGN, ABOVE THE FORWARD CARGO DOOR, WOULD NOT ILLUMINATE BRIGHT. MAINTENANCE REMOVED AND REPLACED THE LEFT 61WL EMERGENCY POWER SUPPLY. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA051038Fuse · burned outDURING A GROUND INSPECTION, THE EMERGENCY LIGHT, NEAR THE FRONT DOOR, WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE FUSE IN THE POWER SUPPLY UNIT. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (K)SDR ASOA051033Lamp · burned outDURING A GROUND INSPECTION IN MGM, THE EMERGENCY EXIT SIGN, ABOVE THE FLIGHT ATTENDANTS SEAT, WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LAMP IN THE EMERGENCY EXIT SIGN, ABOVE THE FLIGHT ATTENDANTS SEAT. OPS CHECKS GOOD. AIRCRAFT OK FSDR ASOA05880Light · unknownFLT 4103 - DURING A GROUND INSPECTION IN ATL, THE ARMED SWITCH HAD TO BE TURNED ON 3 TIMES FOR THE EMERGENCY LIGHTS TO REMAIN OFF. MAINTENANCE INSPECTED THE EMERGENCY LIGHT SYSTEM WITH NO DEFECTS FOUND. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA05864Light · inoperativeDURING HANGAR MAINTENANCE IN MCN, THE EMERGENCY LIGHT ON THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT ASSEMBLY ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. (M)SDR ASOA05738Engine · failedDURING DESCENT FROM PFN-ATL, AT APPROXIMATELY 13,000 FEET THE LEFT ENGINE FEATHERED UNCOMMANDED WITH AN INITIAL RISE UP TO APPROXIMATELY 120 PERCENT THEN POWER WAS LOST AND THE PROPELLER FEATHERED. THE QRH WAS COMPLIED WITH AND AN EMERGENCY WAS DECLARED. THESDR ASOA05387Power Supply · inoperativeDURING A GROUND INSPECTION, HALF OF THE EMERGENCY LIGHTS IN THE CABIN WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHTS POWER SUPPLY 61WL. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (K)SDR ASOA05272Light · inoperativeDURING HANGAR MAINTENANCE IN MCN, THE EMERGENCY LIGHT ON THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT ASSEMBLY ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA05058Step · brokenFLT 4203 - DURING A GROUND INSPECTION IN ATL, THE TOP STEP ON THE PASSENGER DOOR WAS FOUND BROKEN. MAINTENANCE REMOVED AND REPLACED THE TOP STEP ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA05032Wire · brokenDURING A GROUND INSPECTION, THE EMERGENCY FLOOR TRACK LIGHT AT ROW 14 WAS FOUND TO BE INOPERATIVE. MAINTENANCE REPAIRED A BROKEN WIRE TO THE EMERGENCY FLOOR TRACK LIGHT AT ROW 14. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (K)SDR ASOA05025Light · missingDURING HANGAR MAINTENANCE, THE EMERGENCY FLOOR LIGHT STRIP BULB AT ROW 14-B WAS FOUND MISSING FROM THE END OF THE WIRE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY FLOOR LIGHT STRIP AT ROW 14-B. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (K)SDR ASOA04467Cover · brokenDURING A GROUND INSPECTION, THE EMERGENCY EXIT LIGHT COVER AT THE BOTTOM OF THE SERVICE DOOR WAS FOUND BROKEN. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY EXIT LIGHT COVER AT THE BOTTOM OF THE SERVICE DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICSDR ASOA04390Power Supply · inoperativeDURING AN A-CHECK, THE RIGHT AFT EXTERIOR EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT POWER SUPPLY AT 73WL. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE.SDR ASOA04089Light · inoperativeDURING HANGAR MAINTENANCE IN MCN, THE PASSENGER DOOR EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE CLEANED THE PASSENGER DOOR EMEREGNCY LIGHT SOCKET. OPS CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA03602SActuator · leakingFLAP ACTUATOR LEAKING.SDR ASOA03671Switch · dirtyFLT 4187 - DURING FILGHT FROM ATL-CSG, THE AFT ONE-THIRD PORTIONS OF EMERGENCY FLOOR LIGHTS ILLUMINATED UNCOMMANDED. AFTER THE CAPTAIN RESET THE FLT DECK, THE AFT FLT ATTENDANT STATION SWITCHES, AND RESET THE MFC'S THE LIGHTS WENT OUT. THE SYSTEM CHECKED NORSDR ASOA03602Valve · failedFLT 4874 - DURING APPROACH INTO TYS FROM ATL, THE CREW RECEIVED A FLAPS UNLOCK MESSAGE. IN COMPLIANCE WITH THE PILOT'S OPERATING HANDBOOK, THEY COMPLETED A GO AROUND AND PERFORMED A ZERO FLAPS LANDING. DUE TO WEATHER CONDITIONS, AS A PRECAUTION THE CREW REQUSDR ASOA03563Lamp · inoperativeDURING HANGAR MAINTENANCE IN MCN, THE PAX DOOR EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE PASSENGER DOOR EMERGENCY LIGHT LAMP. OPS CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA03515Odor · detectedDURING APPROACH INTO VPS FROM ATL, THE CREW NOTICED AN ELECTRICAL SMOKE ODOR IN THE CABIN. THE AIRCRAFT LANDED SAFELY IN VPS. MAINTENANCE INSPECTED BEHIND THE RELAY, MULTIFUNCTIONAL COMPUTER AND AVIONICS PANELS WITH NO EVIDENCE OF BURNED WIRING. GROUND RUNSSDR ASOA03470Light · inoperativeDURING AN A-CHECK IN MCN, THE PASSENGER DOOR EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE PASSENGER DOOR EMERGENCY LIGHT ASSEMBLY. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA03241Floor Support · corrodedDURING A C-CHECK, THE FLOOR SUPPORT FLANGE INBOARD OF THE SERVICE DOOR THRESHOLD PLATE BETWEEN FRAMES 36 AND 39 ON THE OTP AND BOTTOM SIDES AROUND THE NUT PLATES WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOOR SUPPORT FLANGESDR ASOA03239Seat Track · corrodedDURING A C-CHECK IN BNA, THE LEFT SEAT TRACK BETWEEN FRAMES 36 AND 41 ON THE TOP AND BOTTOM SIDES AROUND THE NUT PLATES WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE CORRODED LEFT SEAT TRACK BETWEEN FRAMES 36 AND 41 ON THE OTP ASDR ASOA03242Sill · corrodedDURING A C-CHECK IN BNA, FLOOR SILL PLATE AT THE RIGHT SIDEWALL BETWEEN FRAMES 39 AND 41 ON THE TOP AND BOTTOM SIDES AROUND THE NUT PLATES WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOOR SILL PLATE AT THE RIGHT SIDEWALL BETWSDR ASOA03240Seat Track · corrodedDURING A C-CHECK IN BNA, THE RIGHT SEAT TRACK BETWEEN FRAMES 39 AND 40 ON THE TOP AND BOTTOM SIDES AROUND THE NUT PLATES WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RIGHT SEAT TRACK BETWEEN FRAMES 39 AND 40 ON THE TOP AND BOTTSDR ASOA03243Support · corrodedDURING A C-CHECK IN BNA, THE FLOOR SUPPORT FLANGE AT FRAME 36 FROM THE LEFT SIDEWALL TO THE RIGHT SIDEWALL ON THE OTP AND BOTTOM SIDES AROUND THE NUT PLATES, AND AT FRAME 40 BETWEEN THE LEFT SEAT TRACK AND THE RIGHT SIDEWALL ON THE TOP AND BOTTOM SIDES AROUND SDR ASOA02514Power Supply · dischargedDURING HANGAR INSPECTION AT MCN, THE PASSENGER DOOR EMERGENCY DOOR EMERGENCY EXIT LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT BATTERY POWER SUPPLY AT THE 61W POSITION. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVSDR ASOA02380Power Supply · dischargedFLT 4125 - DURING FLIGHT FROM MGM TO ATL, THE FORWARD PART OF THE EMERGENCY LIGHTS CAME ON WHEN THE EMERGENCY LIGHTS WERE SWITCHED TO THE ARM POSITION. AIRCRAFT CONTINUED AND LANDED SAFELY IN ATL. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT POWER SUSDR ASOA02280Power Supply · inoperativeFLT 4134 - DURING GROUND INSPECTION IN ATL, THE FLIGHT ATTENDANT REPORTED THE LIGHTED EXIT SIGN OVER THE FORWARD FLIGHT ATTENDANT SEAT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHTING POWER SUPPLY IN THE 61WL POSITION. OPERATIONAL CHESDR ASOA02266Bulb · burned outDURING A HANGAR INSPECTION IN MCN, THE EMERGENCY FLOOR LIGHT BETWEEN ROW 7B AND 8B WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED A BURNED OUT LIGHT BULB IN EMERGENCY FLOOR TRACK BETWEEN ROWS 7B AND 8B. OPERATIONAL CHECK GOOD. AIRCRAFT OK FORSDR ASOA01189Power Supply · dischargedFLT 4100 - DURING GROUND INSPECTION IN ATL, CREW REPORTED THE FORWARD EMERGENCY EXIT SIGN LIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY POWER SUPPLY AT POSITION 61WL. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA01071Light · inoperativeON GROUND IN ATL, CREW REPORTED THE AIRSTAIR DOOR EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EMERGENCY LIGHT BULB ON AIRSTAIR DOOR. OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR ASOA00055Frame · corrodedDURING C-CHECK, FOUND CORROSION ON FRAME 38 BENEATH FLOOR PANEL 256HF. MAINTENANCE REPAIRED CORRODED FRAME IAW SRM 51-21-42, 51-10-10, 51-21-17, AND 51-21-31. OPERATIONAL CHECKS WERE GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR ASOA00054Frame · corrodedDURING C-CHECK, FOUND CORROSION ON FRAME 39 BENEATH FLOOR PANEL 262AF. MAINTENANCE REPAIRED CORRODED FRAME IAW SRM 51-21-42, 51-10-10, 51-21-17, AND 51-21-31. OPERATIONAL CHECKS WERE GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR ASOA00052Frame · corrodedDURNG C-CHECK, FOUND CORROSION ON FRAME 41 BENEATH FLOOR PANEL 261BF. MAINTENANCE REPAIRED CORRODED FRAME IAW SRM 51-21-42, 51-10-10, 51-21-17, AND 51-21-31. OPERATIONAL CHECKS WERE GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR ASOA00053Frame · corrodedDURING C-CHECK, FOUND CORROSION ON FRAME 40 BENEATH FLOOR PANEL 262AF. MAINTENANCE REPAIRED CORRODED FRAME IAW SRM 51-21-42, 51-10-10, 51-21-17, AND 51-21-31. OPERATIONAL CHECKS WERE GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR ASOA99083SGearbox · fracturedEN ROUTE TO ATL, LEFT ENGINE OIL PRESSURE DROPPED TO 0 PSI. CAPTAIN PERFORMED ENGINE FAILURE IN FLIGHT CHECKLIST, DECLARED AN EMERGENCY, AND PERFORMED A SAFE SINGLE ENGINE LANDING AT CSG. MCN MAINTENANCE CREW FOUND NR 3/4 BEARING OIL TUBE CRACKED. MAINTENAN
Back to N634AS