N843AS, cancelled Jun 1, 2017
Service difficulty reports · 148
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 = 'N843AS' AND deregistration_id = 'N843AS-2017-06-01' 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 = 'N843AS' AND deregistration_id = 'N843AS-2017-06-01' 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 TRAX200700690Sign · inoperativeEMERGENCY EXIT SIGN AT ROW 8 WILL NOT ILLUMINATE.SDR TRAX200700681Sign · inoperativeEMERGENCY EXIT SIGN IN CENTER CABIN ROOF, FACING FWD, INOP.SDR TRAX200700022Bulkhead · crackedFUSELAGE STATION 621 AFT PRESSURE BULKHEAD IS CRACKED BY UPPER CARGO DOOR CUTOUT STIFFENER ATTACH POINT. CRACK APPROX 0.025 IN LENGTH MARKED.SDR TRAX200601109Warning Message · illuminatedON GEAR EXTENSION RECEIVED -GEAR DISAGREE WARNING MSG-. FOLLOWED QRH PROCEDURE AND ALL GEAR INDICATED DOWN AND LOCK. FLTS 4189, 4800 CX.SDR TRAX200600892Light · inoperativeEMERGENCY LIGHTS INOP.SDR TRAX200600695Caution Message · illuminatedRECEIVED FLAP FAIL CAUTION MSG ON APPROACH INTO ATL, FLAPS WERE SET TO 8 DEG SPEED 210 KTS 5000 FT, (EMERGENCY DECLARED). FLTS 4106,4229 CX.SDR TRAX200600191Step · brokenBOTTOM ASD STEP IS BROKEN.SDR ASOA06201SStructure · corrodedDURING A C-CHECK, THE FS 349 ATTACHMENT, LBL 36, WAS FOUND TO BE CORRODED. AFTER MAINTENANCE BLENDER, ALODINED, AND PRIMED THE FS 349 ATTACHMENT, LBL 36, IT WAS FOUND TO BE WITHIN ACCEPTABLE LIMITS IAW SRM. (K)SDR ASOA06216Elevator · corrodedDURING C-CHECK, THE RT ELEVATOR, AT THE FRONT SPAR AT RIB 1, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RT ELEVATOR, AT THE FRONT SPAR AT RIB 1 IAW AMM. (K)SDR ASOA06223Intercostal · crackedDURING A C-CHECK, THE LT SIDE LOWER FS 625 CLIP WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LT FS 625 INTERCOSTAL IAW SRM. (K)SDR ASOA06206Isolator · brokenDURING C-CHECK, THE AFT PRESSURE BULKHEAD HAS BROKEN NUT PLATE ISOLATORS AT LBL9, RBL9, AND RBL36. THIS MRR WILL REMAIN OPEN PENDING MAINTENANCE DETERMINATION OF AN APPROPRIATE CORRECTIVE ACTION. (K)SDR ASOA06205Seat Track · corrodedDURING C-CHECK, THE LT FLOOR SEAT TRACK, AT FS 364 TO FS 394, WAS FOUND TO BE CORRODED AND DAMAGED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LT SEAT TRACK, AT FS 364 TO FS 394, IAW AMM. (K)SDR ASOA06204Plate · corrodedDURING A C-CHECK, THE PASSENGER DOOR HORIZONTAL PLATE, AT FS358, LBL 45, WAS FOUND TO BE CORRODED. THIS MRR WILL REMAIN OPEN PENDING MAINTENANCES DETERMINATION OF AN APPROPRIATE CORRECTIVE ACTION. (K)SDR ASOA06202Skin · corrodedDURING C-CHECK, THE MIDDLE FUSELAGE AREA FROM FS 409.00+112 TO FS559.00, ON THE LT SIDE, WAS FOUND TO BE CORRODED. THIS MRR WILL REMAIN OPEN PENDING MAINTENANCES DETERMINATION OF AN APPROPRIATE CORRECTIVE ACTION. (K)SDR ASOA06200Clip · crackedDURING AC-CHECK, THE CLIP ON THE FORWARD FACE 654 WAS FOUND TO BE CRACKED. THIS MRR WILL REMAIN OPEN PENDING MAINTENANCES DETERMNATION OF AN APPROPRIATE CORRECTIVE ACTION. (K)SDR ASOA06199Doubler · corrodedDURING AC-CHECK, THE RT PRESSURE FLOOR OB SILL DOUBLER, FROM FS 409+128 TO FS 559, WAS FOUND TO BE CORRODED IN SEVERAL PLACES. THIS MRR WILL REMAIN OPEN PENDING MAINTENANCES DETERMINATION OF AN APPROPRIATE CORRECTIVE ACTION. (K)SDR ASOA06198Handle · corrodedDURING A C-CHECK, THE CREW ESCAPE HATCH DOOR HANDLE WAS FOUND TO HAVE CORROSION INSIDE THE HANDLE. MAINTENANCE REMOVED AND REPLACED THE CREW ESCAPE HATCH DOOR HANLE IAW CMM. (K)SDR ASOA06193Attach Angle · corrodedDURING A C-CHECK, THE FLOOR PANEL 221ALF, LT ATTACH ANGLE, WAS FOUND TO BE CORRODED BEYOND LIMITS. THIS MRR WILL REMAIN OPEN PENDING MAINTENANCES DETERMINATION OF AN APPROPRIATE CORRECTIVE ACTION. (K)SDR ASOA06192Panel · corrodedDURING A C-CHECK, THE FLOOR PANEL 221ALF, RT ATTACH ANGLE WAS FOUND TO BE CORRODED BEYOND LIMITS. THIS MRR WILL REMAIN OPEN PENDING MAINTENANCES DETERMINATION OF AN APPROPRIATE CORRECTIVE ACTION. (K)SDR ASOA06191Angle · corrodedDURING A C-CHECK, THE FLOOR PANEL AFT ATTACH ANGLE, FS 280, WAS FOUND TO BE CORRODED. THIS MRR WILL REMAIN OPEN PENDING MAINTENANCES DETERMINATION OF AN APPROPRIATE CORRECTIVE ACTION. (K)SDR ASOA06190Floorbeam · crackedDURING C-CHECK, THE FS280 BEAM, AT RBL 9, WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE FS 280 BEAM, AT RBL 9, IAW REO. (K)SDR ASOA06189Floorbeam · corrodedDURING A C-CHECK, THE FS 349 HORIZONTAL FLOORBEAM, LBL 36, WAS FOUND TO BE CORRODED. THIS MRR WILL REMAIN OPEN PENDING MAINT DETERMINATION OF AN APPROPRIATE CORRECTIVE ACTION. (K)SDR ASOA06188Attach Bracket · corrodedDURING A C-CHECK, THE FS 349 ATTACHMENT, LBL 36, WAS FOUND TO BE CORRODED. AFTER MAINTENANCE BLENDED, ALODINED, AND PRIMED THE FS 349 ATTACHMENT, LBL 36, IT WAS FOUND TO BE WITHIN ACCEPTABLE LIMITS IAW SRM. (K)SDR ASOA06196Plate · crackedDURING A C-CHECK, THE FORWARD HYDRAULIC ACCESS BAY, AROUND THE BRAKE CABLE HOLE, AT APPROXIAMATELY THE 7 OCLOCK POSITION, WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE FORWARD HYDRAULIC ACCESS BAY, AROUND THE BRAKE CABLE, AT APPROXIMATELY THSDR ASOA06187Floorbeam · corrodedDURING A C-CHECK, THE FS 280 FLOORBEAM, BETWEEN LBL 9 AND RBL 9, FRONT STRINGER, WAS FOUND TO BE CORRODED BEYOND LIMITS. MAINTENANCE REPAIRED THE FS 280 FLOORBEAM, BETWEEN LBL 9 AND RBL 9, FRONT STRINGER IAW REO. (K)SDR ASOA06186Lens · crackedDURING A C-CHECK, THE EMERGENCY EXIT LIGHT COVER, NEAR THE GALLEY, WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY EXIT COVER, NEAR THE GALLEY. (K)SDR ASOA06181Doubler · crackedDURING A C-CHECK, THE RT FS 640 DOUBLER WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE RT FS 640 DOUBLER IAW SRM. (K)SDR ASOA06180Doubler · crackedDURING C-CHECK, THE LT FS 640 DOUBLER WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LT FS 640 DOUBLER IAW SRM. (K)SDR ASOA06179BStrut · malfunctionedDURING APPROACH, AT APPROXIMATELY 1,500 FT, THE CREW RECEIVED A STEERING INOP MESSAGE. THE CREW COMPLIED WITH THE QRH AND REQUESTED THAT THE EMERGENCY VEHICLES BE DISPATCHED. THE AIRCRAFT LANDED SAFELY. (K)SDR ASOA06179AServo Valve · malfunctionedDURING APPROACH, AT APPROXIMATELY 1,500 FT, THE CREW RECEIVED A STEERING INOPERATIVE MESSAGE. THE CREW COMPLIED WITH THE QRH AND REQUESTED THAT THE EMERGENCY VEHICLES BE DISPATCHED. THE AIRCRAFT LANDED SAFELY. MAINTENANCE REMOVED AND REPLACED THE HYDRAULIC SDR ASOA06179Manifold · malfunctionedDURING APPROACH, AT APPROXIMATELY 1,500 FT, THE CREW RECEIVED A STEERING INOPERATIVE MESSAGE. THE CREW COMPLIED WITH THE QRH AND REQUESTED THAT THE EMERGENCY VEHICLES BE DISPATCHED. THE AIRCRAFT LANDED SAFELY. MAINTENANCE REMOVED AND REPLACED THE HYDRAULIC SDR ASOA06133Transducer · malfunctionedDURING CRUISE FROM MLI-ATL, THE CREW RECEIVED AN EICAS HYDRAULIC READOUT OF 1600 PSI WITH A SMALL LOSS OF HYDRAULIC QUANTITY ON SYSTEM NR 1. A MASTER CAUTION `OB GND SPLR` WAS ALSO RECEIVED. THE TOWER ELECTED TO DISPATCH EMERGENCY VEHCILES, AND THE AIRCRAFT SDR ASOA05886Odor · detectedFLT 4523 - DURING CLIMB-OUT FROM BWI-ATL, AT APPROXIMATELY 15,000 FEET, THE F/O NOTICED AN ELECTRIC SMOKE ODOR COMING FROM THE FLOOR NEAR THE F/O`S FEET. AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED INTO IAD, WHERE IT LANDED SAFELY. MAINTENANCE INSPECSDR ASOA05396Light · shortedDURING A GROUND INSPECTION, THE FORWARD SECTION OF EMERGENCY LIGHTS WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED AN EMERGENCY FLOOR LIGHT STRIP IN THE FORWARD SECTION. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (K)SDR ASOA04977Lamp · burned outDURING HANGAR MAINTENANCE IN BTR, THE AFT EMERGENCY CEILING LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE AFT EMERGENCY CEILING LIGHT LAMP. OPS CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA04749Support Beam · crackedDURING A C-CHECK IN MCN, THE CENTER ENGINE SUPPORT BEAM UPPER AND LOWER WEB AT BL 0 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE CENTER ENGINE SUPPORT BEAM UPPER AND LOWER WEB AT BL 0 IAW ASA EO 600-53-0072. (M)SDR ASOA04422Connector · inoperativeDURING HANGAR MAINTENANCE IN BTR, THE EMERGENCY FLOOR LIGHTING AT ROW 7-C/D WAS FOUND TO BE INOPERATIVE. MAINTENANCE RESECURED THE ELECTRICAL CONNECTOR ON THE EMERGENCY FLOOR LIGHT TRACK AT ROW 7-C/D. OPS CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA04421Lamp · burned outFLT 4512 - DURING HANGAR MAINTENANCE IN BTR, THE LOWER LEFT EMERGENCY FLOOD LIGHT NEAR THE PASSENGER DOOR WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE LOWER LEFT EMERGENCY FLOOR LIGHT LAMP NEAR THE PASSENGER DOOR. OPS CHECKS GOOD. AIRCRSDR ASOA03267Lamp · inoperativeDURING A GROUND INSPECTION IN MGM, THE RIGHT FORWARD OVERWING EMERGENCY LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE RIGHT FORWARD OVERWING EMERGENCY LIGHT LAMP. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA03138Bracket · crackedDURING HANGAR MAINTENANCE IN MCN, THE LEFT AND RIGHT ANGLE BRACKETS BELOW THE ENGINE SUPPORT BEAM WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE LEFT AND RIGHT ANGLE BRACKETS BELOW THE ENGINE SUPPORT BEAM IAW SRM 51-00. (M)SDR ASOA02419Windshield · crackedFLT 4843 - DURING TAXI INTO DFW, THE CAPTAINS LEFT WINDSHIELD WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE CRACKED WINDSHIELD. PRESSURE AND OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA02286Light · inoperativeFLT 4505 - DURING A SCHEDULED INSPECTION IN XNA, THE RIGHT EXTERNAL EMERGENCY LIGHT IN THE NR 2 POSITION WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE BURNED OUT EXTERNAL EMERGENCY LIGHT BULB. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA02284Smoke · detectedAPPROXIMATELY TWO MINUTES AFTER TAKEOFF, THE CAPTAIN RECEIVED A SMOKE TOILET MESSAGE. THE FLIGHT ATTENDANT CALLED APPROXIMATELY THREE SECONDS LATER TO REPORT THE SMELL OF SMOKE BUT NO ACTUAL SMOKE IN THE CABIN. AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETSDR ASOA02269Bulb · burned outFLT 4787 - DURING A SCHEDULED INSPECTION IN XNA, THE AFT CEILING EMERGENCY FLOOD LIGHT WAS INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE BURNED OUT CEILING EMERGENCY LIGHT BULB. OPS CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA01228Line · leakingON TAKEOFF FROM ATL, AT 1500 FEET, CAPTAIN NOTED RIGHT ENGINE OIL PRESSURE WAS AT 32 PSI AND FLUCTUATING. THE CAPTAIN THEN RECEIVED A RIGHT ENGINE OIL PRESSURE WARNING. THE ENGINE WAS SECURED, AND AN EMERGENCY WAS DECLARED. AIRCRAFT LANDED SAFELY IN ATL. MSDR ASOA01159Light · inoperativeDURING GROUND INSPECTION IN TOL, CREW REPORTED FLOOR LEVEL EMERGENCY TRACK LIGHTING INOPERATIVE AT ROWS 1-6. MAINTENANCE REMOVED AND REPLACED THE CABLE FLOOR TRACK LIGHTING ASSEMBLY AT ROWS 1-6. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA01035Engine · failedFLT 4742 - DURING FLIGHT FROM AUS TO ATL, CREW RECEIVED A NR 2 ENGINE 'LOW OIL PRESSURE' LIGHT. CREW SHUT DOWN RIGHT ENGINE FOLLOWING QRH AND DECLARED AN EMERGENCY. AIRCRAFT DIVERTED TO JAN AND LANDED SAFELY. MAINTENANCE PERFORMED MAGNETIC CHIP DETECTOR INSSDR ASOA010359Bearing · failedDURING FLIGHT FROM AUS TO ATL, CREW RECEIVED A NR 2 ENGINE 'LOW OIL PRESS' LIGHT. CREW SHUT DOWN RIGHT ENGNIE FOLLOWING QRH AND DECLARED AN EMERGENCY. AIRCRAFT DIVERTED TO JAN AND LANDED SAFELY. MAINTENANCE PERFORMED MAGNETIC CHIP DETECTOR INSPECTION AS PER
Back to N843AS, cancelled Jun 1, 2017