N837AS, cancelled Jun 8, 2017
Service difficulty reports · 125
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 = 'N837AS' AND deregistration_id = 'N837AS-2017-06-08' 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 = 'N837AS' AND deregistration_id = 'N837AS-2017-06-08' 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 ASOA06164Step · brokenDURING A GROUND INSPECTION, THE PASSENGER DOOR BOTTOM STEP WAS FOUND TO BE BROKEN. MAINTENANCE REMOVED AND REPLACED THE PASSENGER DOOR BOTTOM STEP. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (K)SDR ASOA051064Torque Link · disconnectedDURING CLIMB-OUT FROM CAE-ATL, UPON GEAR RETRACTION, THE CREW RECEIVED GEAR DISAGREE AND NOSE DOOR OPEN WARNING MESSAGES ALONG WITH STEERING INOP AND WOW INPUT CAUTION MESSAGES. NOSE GEAR STAYED GREEN AND DOWN. THE CREW COMPLIED WITH THE QRH AND DECLARED AN SDR ASOA05978Step · brokenFLT 9970 - DURING A HANGAR INSPECTION IN MCN, THE PASSENGER DOOR BOTTOM STEP WAS FOUND TO BE BROKEN. MAINTENANCE REMOVED AND REPLACED THE PASSENGER DOOR BOTTOM STEP. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA05757Handle · bindingDURING A GROUND INSPECTION IN ATL, THE PASSENGER DOOR WOULD NOT OPEN FROM THE OUTSIDE. MAINTENANCE REMOVED AND REPLACED THE ROLLER ON THE INNER DOOR HANDLE OF THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA04799Step · brokenDURING A HANGAR INSPECTION, THE BOTTOM STEP AT THE ATTACH LINK ON THE PASSENGER DOOR WAS FOUND BROKEN. MAINTENANCE REMOVED AND REPLACED THE BOTTOM STEP ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE.SDR ASOA04792Step · brokenDURING A GROUND INSPECTION, THE BOTTOM STEP ON THE PASSENGER DOOR WAS FOUND BROKEN. MAINTENANCE REMOVED AND REPLACED THE BOTTOM STEP ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE.SDR ASOA04522Step · crackedDURING HANGAR MAINTENANCE IN MCN, THE BOTTOM STEP ON THE PASSENGER DOOR WAS FOUND CRACKED. MAINTENANCE REMOVED AND REPLACED THE BOTTOM STEP ON THE PASSENGER DOOR. (M)SDR ASOA04294Step · crackedDURING A C-CHECK IN MCN, THE PASSENGER DOOR BOTTOM STEP AS FOUND CRACKED. MAINTENANCE IS REPAIRING THE PASSENGER DOOR BOTTOM STEP IAW SRM 51-74-00. (M)SDR ASOA04293Clip · crackedDURING A C-CHECK IN MCN, THE INBOARD AND OUTBOARD CLIPS AT FS 280, LBL 9 AND RBL 9 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE INBOARD AND OUTBOARD CLIPS AT FS 280, LBL 9 AND RBL 9 IAW SRM 51-42-00. (M)SDR ASOA04290Floor Support · crackedDURING A C-CHECK IN MCN, THE CARGO BAY LEFT AND RIGHT FLOOR SUPPORT ANGLES AT FS 621 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE CARGO BAY LEFT AND RIGHT FLOOR SUPPORT ANGLES AT FS 621 IAW ASA EO 600-53-0105. (M)SDR ASOA04291Sill · crackedDURING A C-CHECK IN MCN, THE CARGO BAY FLOOR SILL PLATE AT FS 562.72-589 WAS FOUND TO BE CRACKED AND CORRODED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE CARGO BAY FLOOR SILL PLATE AT FS 562.72-589. (M)SDR ASOA04292Support Beam · crackedDURING A C-CHECK IN MCN, THE ENGINE SUPPORT BEAM UPPER AND LOWER WEB AT BL 0 UNDER THE CLIPS RIGHT SIDE HOLE WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE ENGIEN SUPPORT BEAM UPPER AND LOWER WEB AT BL 0 IAW ASA EO 600-53-0072. (M)SDR ASOA04203Skin · crackedDURING AN A-CHECK IN BTR, THE FS 640, FS 640 DOUBLER AND SKIN BUTT JOINT STRAP ON THE RIGHT SIDE AT STRINGER 9 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE FS 640, FS 640 DOUBLER AND REPAIRING THE SKIN BUTT STRAP ON THE RISDR ASOA03435Connector · dirtyDURING A GROUND INSPECTION IN ATL, THE EMERGENCY FLOOR LIGHT STRIP LEADING FROM THE CLOSET TO THE MAIN DOOR AREA OPERATED INTERMITTENTLY. MAINTENANCE CLEANED THE CONNECTORS TO THE EMERGENCY FLOOR LIGHT STRIP LEADING FROM THE CLOSET TO THE GALLEY AREA. OPS CHSDR ASOA03358Light · inoperativeFLT 4732 - DURING HANGAR MAINTENANCE IN BTR, THE RIGHT SIDE EXTERIOR EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE RIGHT SIDE EXTERIOR EMERGENCY LIGHT LAMP. OPS CHECKED GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA03190Line · chafedFLT 4496 - DURING CLIMB-OUT FROM DFW-CHS, AT APPROXIMATELY 22,000 FEET THE CREW RECEIVED A NR 2 HYDRAULIC LOW PRESSURE WARNING MESSAGE WITH THE SYNOPTIC PAGE SHOWING NO HYDRAULIC FLUID IN THE RESERVOIR. AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DSDR ASOA02620Apu · malfunctionedFLT 4403 - DURING DESCENT INTO GRR, THE CAPTAIN REPORTED A STRONG FUEL SMELL DURING AND AFTER STARTING THE AUXILIARY POWER UNIT. THE AIRCRAFT LANDED SAFELY IN GRR. MAINTENANCE REMOVED AND REPLACED THE AUXILIARY POWER UNIT. OPERATIONAL AND LEAK CHECKS GOOD. SDR ASOA02387Frame · crackedDURING HANGAR MAINTENANCE IN MCN, THE LEFT AND RIGHT SIDES OF FRAME 718 WERE FOUND TO BE CRACKED. MAINTENANCE REPAIRED THE CRACKED FRAME IAW ASA EO 600-53-0066. (M)SDR ASOA02386Support · crackedDURING HANGAR MAINTENANCE IN MCN, A CRACK WAS FOUND IN THE BOX BEAM AREA OF THE LOWER RIGHT ACCESS PANEL ON THE INBOARD SIDE AS VIEWED THROUGHT THE LIGHTENING HOLE. MAINTENANCE REPAIRED THE CRACKED ENGINE SUPPORT BEAM IAW ASA EO 600-53-0070. (M)SDR ASOA02350Lamp · burned outDURING GROUND INSPECTION, THE FORWARD MOST EXTERNAL EMERGENCY LIGHT ON THE RIGHT HAND SIDE OF THE FUSELAGE WAS FOUND INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE BURNED OUT EMERGENCY LIGHT BULB. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE.SDR ASOA02275Light · inoperativeDURING GROUND INSPECTION IN FAY, THE FIRST FOUR FLOOR EMERGENCY LIGHTS WERE INOPERATIVE. MAINTENANCE REPLACED THE FORWARD ORANGE EMERGENCY LIGHTING STRIP. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA02133Sensor · inoperativeFLT 4469 - AFTER TAKEOFF FROM YYZ, THE CAPTAIN RECEIVED A FLAP FAIL MESSAGE WHEN FLAPS WERE SELECTED TO 8 DEGREES LT AND RT. THE CAPTAIN ATTEMPTED TO RETRACT THE FLAPS TO ZERO DEGREES WITH NO RESULTS. AN EMERGENCY WAS DECLARED. AIRCRAFT RETURNED AND LANDED SDR ASOA02132Control Unit · malfunctionedFLT 4468 - DURING APPROACH INTO YYZ, THE CAPTAIN RECEIVED A FLAP FAIL MESSAGE WHEN FLAPS WERE SET TO 8 DEGREES LEFT AND RIGHT. AIRCRAFT WAS AT 7000 FEET AND 200 KKNOTS. AS THE AIRCRAFT SLOWED TO 190 KNOTS THE FLAPS WERE STUCK AT ZERO DEGREES LT AND RT. AN ESDR ASOA01192Light · inoperativeFLT 4414 - DURING GROUND INSPECTION IN MGM, CREW FOUND THE FLOOR PATH LIGHTS AT BOTH WING EMERGENCY EXITS AS WELL AS THE WHITE FLOOR PATH LIGHTING FORWARD INOPERATIVE. THE CREW ALSO NOTED THE LOWER GREEN EXIT LIGHTS FOR THE WING EMERGENCY EXITS WERE INOPERATISDR ASOA01124Wire · defectiveDURING GROUND INSPECTION IN ATL, CREW REPORTED PORTIONS OF THE EMERGENCY FLOOR LIGHTING ARE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE CENTER FLOOR SECTION CABLE ASSEMBLY AT ROWS 2-5. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)
Back to N837AS, cancelled Jun 8, 2017