N636AS
Service difficulty reports not matched to an aircraft · 93
They name N636AS, 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 = 'N636AS' 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 = 'N636AS' 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 ASOA051012Light · malfunctionedDURING A GROUND INSPECTION IN ATL, THE EMERGENCY LIGHTS CAME ON THREE TIMES. MAINTENANCE PERFORMED OPERATIONAL CHECKS WITH NO DEFECTS NOTED. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA05932Generator · malfunctionedDURING CRUISE FROM ATL-PFN, THE CREW REPORTED AN ELECTRICAL ODOR WITH A RIGHT AC WILD GENERATOR FAULT. AIRCRAFT CONTINUED TO PFN WHERE IT LANDED SAFELY. MAINTENANCE REMOVED AND REPLACED THE RIGHT AC WILD GENERATOR. OPERATIONAL CHECK GOOD. AIRCRAFT OK FOR SSDR ASOA05866Lamp · burned outFLT 4223 - DURING A GROUND INSPECTION IN MGM, THE EMERGENCY LIGHT ON THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LAMP IN THE EMERGENCY LIGHT ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (SDR ASOA05714Bracket · crackedDURING A C-CHECK IN YUL, FOUR OMEGA BRACKETS ON THE LEFT WING AT THE NR 4 FLAP HINGE, RIB 8 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED FOUR OMEGA BRACKETS ON THE LEFT WING AT THE NR 4 FLAP HINGE, RIB 8 IAW ATR 72 SRM 51-25-01. (SDR ASOA05710Seat Track · corrodedDURING A C-CHECK IN YUL, THE SEAT TRACKS BETWEEN FRAME 36 TO FRAME 39 LEFT/RIGHT WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACKS BETWEEN FRAME 36 TO FRAME 39 LEFT/RIGHT IAW ATR72 SRM 51-21-42 AND 51-25-04. (M)SDR ASOA05711Seat Track · corrodedDURING A C-CHECK IN YUL, THE SEAT TRACK BETWEEN FRAME 39 TO FRAME 40 RIGHT WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK BETWEEN FRAME 39 TO FRAME 40 RIGHT IAW ATR 72 SRM 51-25-04. (M)SDR ASOA05712Seat Track · corrodedDURING A C-CHECK IN YUL, THE SEAT TRACK BETWEEN FRAME 39 TO FRAME 41 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SEAT TRACK BETWEEN FRAME 39 TO FRAME 41 IAW ATR 72 SRM 51-25-04. (M)SDR ASOA05713Plate · corrodedDURING A C-CHECK, THE SUPPORT PLATES BETWEEN FRAME 13 TO FRAME 17, LBL 47 FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE SUPPORT PLATED BETWEEN FRAME 13 TO FRAME 17, LBL 47 IAW ATR-72 SRM 51-25-01.SDR ASOA05706Intercostal · corrodedDURING A C-CHECK IN YUL, THE INTERCOSTAL BETWEEN FRAME 36 AND FRAME 38 LEFT WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE INTERCOSTAL BETWEEN FRAME 36 AND 38 LEFT IAW ATR-72 SRM 51-25-01. (M)SDR ASOA05707Doubler · corrodedDURING A C-CHECK IN YUL, THE DOUBLER AT FRAME 39, STRINGER 14 RIGHT WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE DOUBLER AT FRAME 39, STRINGER 14 RIGHT IAW ATR-72 SRM 51-21-42 AND 51-25-01. (M)SDR ASOA05709Floor Support · corrodedDURING A C-CHECK IN YUL, THE Z-FLOOR SUPPORTS AT FRAME 39, STRINGER 14 LEFT AND FRAME 39 TO FRAME 41 RIGHT WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE Z-FLOOR SUPPORTS AT FRAME 39, STRINGER 14 LEFT AND FRAME 39 TO FRAME 41 RISDR ASOA05705Attach Fitting · crackedDURING A C-CHECK IN YUL, THE FUSELAGE TO WEB ATTACH FITTING BRACKET AT FRAME 27, STRINGER 14 RIGHT WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FUSELAGE TO WEB ATTACH FITTING BRACKET AT FRAME 27, STRINGER 14 RT IAW ATR-72 SRM 51SDR ASOA04567Odor · detectedDURING TAKEOFF FROM PFN-ATL, THE AIRCRAFT RECEIVED MULTIPLE BIRD STRIKES WITH ONE HITTING THE CAPTAINS WINDSHIELD AND ANOTHER ENTERING THE LT ENGINE INTAKE, FOLLOWED BY A STRONG ODOR IN THE AIRCRAFT. THE FLIGHT CONTINUED TO ATL WITH NO OTHER PROBLEMS NOTED. SDR ASOA04082Support Beam · crackedDURING HANGAR MAINTENANCE IN MCN, THE RIGHT FORWARD NOSE LANDING GEAR DOOR AFT SUPPORT FRAME WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE WEB ON THE RIGHT FORWARD NOSE LANDING GEAR DOOR AFT SUPPORT FRAME BY STOP DRILLING THE CRACK AND INSTASDR ASOA03613Channel · corrodedDURING A C-CHECK IN BNA, THE FLOOR LEVEL U-CHANNEL JUST INBOARD OF THE PASSENGER DOOR SPRINGS BETWEEN FRAMES 39 AND 40 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOOR LEVEL U-CHANNEL JUST INBOARD OF THE PASSENGER DOOR SPRINGSDR ASOA03614Channel · corrodedDURING A C-CHECK IN BNA, THE TEE CHANNEL AT THE INBOARD SIDE OF THE ENTRANCE SILL AREA BETWEEN FRAMES 36 AND 38 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED THE CORROSION AND INSTALLED A DOUBLER UNER THE T-CHANNEL AT THE INBOARD SIDE OF TEH ENTSDR ASOA03615Floor Support · corrodedDURING A C-CHECK IN BNA, THE FLOOR FLANGE AT THE RT SIDE WALL BETWEEN FRAMES 39 AND 41 WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE FLOOR FLANGE AT THE RIGHT SIDE WALL BETWEEN FRAMES 39 AND 41 IAW SRM 51-25-01. (M)SDR ASOA03616Seat Track · corrodedDURING A C-CHECK IN BNA, THE LT AND RT SEAT TRACKS BETWEEN FRAMES 36 AND 39 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LT AND RT SEAT TRACKS BETWEEN FRAMES 36 AND 39 IAW SRM 51-25-04. (M)SDR ASOA03617Seat Track · corrodedDURING A C-CHECK IN BNA, THE LT AND RT SEAT TRACKS BETWEEN FRAMES 39 AND 41 WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LT AND RT SEAT TRACKS BETWEEN FRAMES 39 AND 41 IAW SRM 51-25-04. (M)SDR ASOA03180Computer · inoperativeFLT 4331 - DURING APPROACH INTO GPT FROM ATL, THE CREW RECEIVED A FLAP UNLOCK MESSAGE WITH THE FLAPS SELECTED AT THIRTY DEGREES. A GO AROUND WAS INITIATED WITH THE FLAPS RETRACTED TO FIFTEEN DEGREES AND THE MESSAGE EXTINGUISHED. AN EMERGENCY WAS DECLARED ANDSDR ASOA03047Light · inoperativeDURING A GROUND INSPECTION IN VPS, THE FORWARD EMERGENCY EXIT LAMPS WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE FORWARD EMERGENCY EXT LIGHT LAMPS. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA02594Battery Pack · dischargedFLT 4154 - DURING GROUND INSPECTION IN ATL, THE EMERGENCY EXIT LIGHT OVER THE SERVICE DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY LIGHT BATTERY PACK ASSEMBLY. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA02319Lamp · burned outDURING HANGER INSPECTION, THE EMERGENCY LIGHT ON THE PASSENGER DOOR WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE BURNT OUT LIGHT BULB ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE.SDR ASOA02116Bulb · burned outDURING A HANGAR INSPECTION IN MCN, THE EMERGENCY EXIT LIGHTED SIGN BY THE AIRSTAIR DOOR WAS BURNED OUT. MAINTENANCE REMOVED AND REPLACED THE BURNED OUT BULB. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA01255Frame · crackedDURING C-CHECK INSPECTION IN BNA, FRAME 26 WAS CRACKED AT BL0. MAINTENANCE REPAIRED CRACK IAW ASA EO72-53-0118. THIS EO REF SB 72-53-1078 AND INCLUDES REPAIR SPECIFICATIONS FOR CRACK ON AIRCRAFT. AIRCRAFT RETURNED TO SERVICE. (M)SDR ASOA01225Floorbeam · corrodedDURING C-CHECK INSPECTION IN BNA, BOTH TOP AND BOTTOM SURFACES OF THE FLOORBEAM TOP FLANGE WAS FOUND CORRODED AT FRAMES 36, 38, 39, 40 AND 41. MAINTENANCE REPAIRED CORROSION IAW ASA EO72-53-0119. THE EO REF FORM 8110-3, REPORT NR 01-286, WHICH INCLUDES REPAISDR ASOA01236Skin · corrodedDURING C-CHECK INSPECTION IN BNA, A CRACK WAS DISCOVERED AT THE RIGHT LAP SEAM BETWEEN STRINGER 10 RIGHT AND 11 RIGHT AT FRAMES 25-29. MAINTENANCE REPAIRED THE CRACK IAW ASA EO72-53-0120. THIS EO REF ATR SRM 53-00-00, FIGURE 425. AIRCRAFT RETURNED TO SERVICSDR ASOA01227Seat Track · corrodedDURING C-CHECK INSPECTION IN BNA, THE LEFT NR 1 SEAT TRACK HAD CORROSION ON THE CLIP NUT HOLE FORWARD OF FRAME 16. CORROSION WAS ALSO FOUND ON THREE CENTER CLIP NUT HOLES BETWEEN FRAMES 16 AND 17 AND TWO CENTER CLIP HOLES BETWEEN FRAMES 19 AND 20. MAINTENANCSDR ASOA01197Power Supply · dischargedDURING GROUND INSPECTION IN ATL, CREW REPORTED THE EMERGENCY EXIT LIGHT OVER THE AFT SERVICE DOOR WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY POWER SUPPLY. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA01125Power Supply · inoperativeDURING HANGAR MAINTENANCE IN MCN, EMERGENCY LIGHT ON PASSENGER DOOR WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EMERGENCY LIGHT BATTERY. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA01043Brake Assy · overheatedFLT 4100 - AFTER LANDING ROLL OUT AT ATL AND CLEAR OF RUNWAY ON TAXI WAY, A HOT BRAKE LIGHT CAME ON. GROUND CREW DECLARED AN EMERGENCY. MFC SHOWS RIGHT INBOARD BRAKE HOT. RIGHT BRAKE COOLED AND NO DEFECTS WERE NOTED BY MAINTENANCE. AIRCRAFT RETURNED TO SERSDR 98ZZZX2071Panel · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED RT WING PANEL 622CT CORRODED BEYOND LIMITS. INSTALLED NEW PANEL 622CT IAW ATR72 JIC 57-00-00 OAC 10000-001. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX2070Plate · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED PASSENGER DOOR FOLDING STEP STRIKER PLATE CORRODED. REPLACED STRIKER PLATE AS REQUIRED IAW JIC STANDARD PRACTICE CHAPTER 20. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX2066Nut Plate Flange · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED LT WING FUEL ACCESS PANEL 522CT NUT PLATE FLANGE CORRODED BEYOND LIMITS. INSTALLED NEW FLANGE IAW ATR72 JIC 57-00-00 OAC 100000-001. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX2065Panel · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED LT WING FUEL PANEL 522CT CORRODED BYEOND LIMITS. INSTALLED NEW PANEL IAW JIC 57-00-00 OAC 100000-001. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX2064Support · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED AFT CARGO RT Z-MEMBER CORRODED. REPLACED RT Z-MEMBER IAW ATR72 SRM 51-25-01. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX2063Drain Track · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED SERVICE DOOR SILL DRAIN TRACK CORRODED. INSTALLED NEW DRAIN TRACK IAW ATR72 SRM 53-61-00. AIRCRAFT RETURNED TO SERVICE. (X)SDR 98ZZZX2062Floor Channel · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED SERVICE DOOR SILL PLATE FLOOR CHANNEL CORRODED. INSTALLED NEW FLOOR CHANNEL IAW ATR72 SRM 53-61-01. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX2061Nut Plate Flange · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED RT WING PANEL 622CT NUT PLATE FLANGE CORRODED. REPLACED PANEL 622CT NUT PLATE COLLAR IAW ATR72 JIC 57-00-00 OAC 100000-001. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX2069Bracket · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED PASSENGER DOOR HANDRAIL SUPPORT CORRODED. INSTALLED NEW SUPPORT IAW ATR72 SRM 53-67-20 FIG 5. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX2068Intercostal · corrodedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED RT INTERCOSTAL AT STR 17 CORRODED BYEOND LIMITS. INSTALLED NEW INTERCOSTAL AT STR 17 IAW ATR72 SRM 53-61-01. AIRCRAFT RETURNED TO SERVICE.SDR 98ZZZX2067Hinge · crackedSAW - DURING C-CHECK INSPECTION, MAINTENANCE REPORTED FORWARD CARGO DOOR 'PIANO' HINGE CRACKED AND DENTED ON 2 LUGS. MAINTENANCE REPLACED THE 'PIANO' HINGE IAW ATR72 SRM 51-25-03. AIRCRAFT RETURNED TO SERVICE.SDR ASOA95003Nh Sensor · defectiveDFW/HOU - FLT 7719 - DURING CLIMB PASSING THROUGH 4500 FEET, THE NR 2 ENGINE SURGED WITH TORQUE SHOWING IN EXCESS OF 110 PERCENT THEN DROPPING TO 10 PERCENT WITH POWER LEVER IN NOTCH CLIMB MODE. NP NOTED AT 86 PERCENT. RETURNED FLIGHT TO DFW WHERE LANDING WA
Back to N636AS