N824AS, cancelled Nov 13, 2017
Service difficulty reports · 226
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 = 'N824AS' AND deregistration_id = 'N824AS-2017-11-13' 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 = 'N824AS' AND deregistration_id = 'N824AS-2017-11-13' 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 ASOA04810Skin Panel · crackedDURING A C-CHECK, THE RT WING PLANK AT APPROXIMATELY WS 148 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE RT WING PLANK AT APPROXIMATELY WS 148 IAW EO600-57-0134A.SDR ASOA04825Handle · crackedDURING A C-CHECK, THE MAIN AVIONICS BAY DOOR HANDLE WAS FOUND CRACKED AROUND THE BASE. MAINTENANCE IS REMOVING AND REPLACING THE MAIN AVIONICS BAY DOOR HANDLE.SDR ASOA04824Step · crackedDURING A C-CHECK, THE TOP STEP ON THE PASSENGER DOOR WAS FOUND CRACKED. MAINTENANCE IS REMOVING AND REPLACING THE TOP STEP ON THE PASSENGER DOOR.SDR ASOA04659Step · brokenFLT 4435 - DURING A GROUND INSPECTION IN ATL, THE BOTTOM STEP ON THE PASSENGER DOOR WAS FOUND BROKEN. MAINTENANCE REMOVED AND REPLACED THE BOTTOM STEP ON THE PASENGER DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA04600Lamp · inoperativeDURING A GROUND INSPECTION IN DFW, THE FORWARD EMERGENCY CEILING LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE FORWARD EMERGENCY CEILING LIGHT LAMP. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA04347Lamp · burned outDURING A GROUND INSPECTION, THE RT CENTER OVERWING EMERGENCY LIGHT WAS INOPERATIVE. MAINTENANCE RELAMPED THE EXTERNAL OVERWING EMERGENCY LIGHT BULB. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR ASOA04237Warning Light · illuminatedFLT 4586 - DURING APPROACH INTO LIT FROM DFW, THE CRWE RECEIVED A FLAPS FAIL MASTER WARNING WHEN THEY SELECTED THE FLAPS TO EIGHT DEGREES. THE QRH WAS COMPLIED WITH THE CREW REQUESTED EMERGENCY EQUIPMENT TO BE ON STANDBY AS A PRECAUTION. THE AIRCRAFT LANDED SDR ASOA04062Step · crackedDURING A HANGAR INSPECTION IN MCN, THE LOWER STEP ON THE PASSENGER DOOR WAS FOUND CRACKED. MAINTENANCE REMOVED AND REPLACED THE LOWER STEP ASSEMBLY ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA03373Light · inoperativeFLT 4629 - DURING A GROUND INSPECTION IN ATL, THE CREW FOUND THE EMERGENCY FLOOR LIGHTS AT ROWS 3 AND 4 C/D TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY FLOOR LIGHT STRIP AT ROWS 3/4 C/D. OPERATIONAL CHECKS GOOD. AIRCRAT OK FOR SERVICE.SDR ASOA03301Circuit Breaker · trippedDURING HANGAR MAINTENANCE IN BTR, THE EMERGENCY LIGHTS REMAINED ON WHEN IN THE ARMED POSITION. MAINTENANCE RESET THE CIRCUIT BREAKER TO THE EMERGENCY LIGHTS. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA03159Floorbeam · corrodedDURING A C-CHECK IN MCN, THE LEFT AND RIGHT FLOORBEAMS AT BL 27 IN THE SERVICE DOOR AREA WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE LEFT AND RIGHT FLOORBEAMS (P/N'S 601R53-037K1A AND 601R53-037K4A) AT BL 27 IN THE SERVISDR ASOA03158Floorbeam · corrodedDURING A C-CHECK IN MCN, THE LEFT AND RIGHT FLOORBEAMS AT BL 9 IN THE SERVICE DOOR AREA WERE FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE LEFT AND RIGHT FLOORBEAMS (P/N'S 601R53-037K2A AND 601R53-037K3A) AT BL 9 IN THE SERVICESDR ASOA03152Floorbeam · crackedDURING A C-CHECK IN MCN, THE FORWARD ATTACHING ANGLE ON THE RIGHT SIDE FLOORBEAM BELOW THE COCKPIT DOOR WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE FORWARD ATTACHING ANGLE ON THE RIGHT SIDE FLOORBEAM BELOW THE COCKPIT DOORSDR ASOA03153Hinge · corrodedDURING A C-CHECK IN MCN, THE UPPER HINGE AT THE TOP STEP OF THE PASSENGER DOOR WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE UPPER HINGE AT THE TOP STEP OF THE PASSENGER DOOR IAW SRM 51-00. (M)SDR ASOA03154Angle · corrodedDURING A C-CHECK IN MCN, THE PASSENGER DOOR TOP STEP UPPER HINGE NUT PLATE ANGLE WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE PASSENGER DOOR TOP STEP UPPER HING NUT PLATE ANGLE IAW SRM 51-00. (M)SDR ASOA03155Angle · corrodedDURING A C-CHECK IN MCN, THE LOWER METAL TRIM PANEL NUT PLATE ANGLE AT THE SERVICE DOOR ENTRANCE WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE IS REMOVING THE LOWER METAL PANEL NUT PLATE ANGLE AT THE SERVICE DOOR ENTRANCE IAW SRM 51-00. (M)SDR ASOA03151Support Beam · crackedDURING A C-CHECK IN MCN, THE RIGHT ENGINE SUPPORT BEAM AT BL 36.20 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE RT ENGINE SUPPORT BEAM AT BL 36.20 IAW ASA EO 600-53-0070. (M)SDR ASOA02643Apu · shutdownFLT 4680 - DURING DESCENT INTO ATL AT APPROXIMATELY 13,000 FEET, THE AUXILIARY POWER UNIT SHUT ITSELF DOWN AUTOMATICALLY. THE CREW WAITED APPROXIMATELY TWO MINUTES AND RE-STARTED IT, AFTER WHICH THE ODOR OF FUEL OCCURRED IN THE COCKPIT AND CABIN. THE AIRCRAFSDR ASOA02345Frame · crackedDURING HANGER MAINTENANCE, A CRACK WAS DISCOVERED ON FRAME 718 ON BOTH THE LEFT AND RIGHT SIDES. MAINTENANCE REPAIRED THE CRACKED FRAME IAW EO.SDR ASOA02344Support · crackedDURING HANGER MAINTENANCE, THE LEFT ENGINE SUPPORT BEAM WAS FOUND TO BE CRACKED. MAINTENANCE REPAIRED THE CRACKED ENGINE SUPPORT BEAM IAW REO. THIS REO GIVES REPAIR SPECIFICATIONS FOR THE ENGINE SUPPORT BEAM CRACK, AS WELL AS OUTLINES A THRESHOLD OF CYCLES FSDR ASOA02320Lamp · burned outDURING GROUND INSPECTION, AN EXTERNAL EMERGENCY LIGHT ON THE RIGHT HAND SIDE OF THE FUSELAGE WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE BURNED OUT EMERGENCY LIGHT BULB. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE.SDR ASOA01304Window · crackedFLT 4325 - DURING LANDING ROLL IN DHN, THE CAPTAINS LEFT SIDE WINDOW SHATTERED. MAINTENANCE REMOVED AND REPLACED THE SHATTERED LEFT SIDE PILOT WINDOW. A LEAK CHECK WAS PERFORMED, AND NO LEAKS WERE NOTED. AIRCRAFT RETURNED TO SERVICE. (M)SDR ASOA01154Windshield · crackedDURING DESCENT INTO DFW AT 25,000 FEET, THE FIRST OFFICERS WINDSHIELD CRACKED. AIRCRAFT LANDED IN DFW WITHOUT FURTHER INCIDENT. MAINTENANCE REMOVED AND REPLACED THE RIGHT WINDSHIELD. AIRCRAFT RETURNED TO SERVICE. (M)SDR ASOA1034Smoke Detector · malfunctionedFLT 4693 - DURING APPROACH INTO MYR FROM ATL, CREW HAD A CARGO SMOKE INDICATION LIGHT. CAPTAIN DECLARED AN EMERGENCY, BUT FIRE BOTTLES WERE NOT BLOWN. MAINTENANCE FOUND NO INDICATION OF CARGO FIRE. MAINTENANCE REMOVED AND REPLACED THE CARGO SMOKE DETECTOR. SDR ASOA99085Bulb · failedDURING INSPECTION, EMERGENCY FLOOR BULB AT 1AB FOUND INOPERATIVE. MAINTENANCE REPLACED EMERGENCY LIGHTING SYSTEM BULB. OPERATIONAL CHECKS WERE GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR 99ZZZX433Actuator · malfunctionedATL/ROA - FLT 7289 - DURING CLIMB-OUT, ELEVATOR TRIM WOULD NOT TRIM BELOW 3 UNITS DOWN. CONTROLABILITY IMPROVED WITH REDUCED AIRSPEED AND FLAPS. CREW DECLARED AN EMERGENCY AND RETURNED TO ATL, WHERE LANDING WAS MADE SAFELY AND WITHOUT FURTHER INCIDENT. ATL
Back to N824AS, cancelled Nov 13, 2017