N839HK, cancelled Apr 26, 2023
Service difficulty reports · 71
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 = 'N839HK' AND deregistration_id = 'N839HK-2023-04-26' 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 = 'N839HK' AND deregistration_id = 'N839HK-2023-04-26' 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 ASOA202206281003Lamp · inoperativeDEFECT - RH OVER WING EMERGENCY LIGHT INOPERATIVE. CORRECTIVE ACTION - REPLACED LAMP PER EMB-145 AMM 33-50-10 OPS CHECK GOOD.SDR ASOA202206021002Brake · abnormalDISCREPANCY - ON LANDING APPLIED FULL BRAKE PRESSURE AND DIDN'T FEEL ANY BRAKING. BRAKE TEMPS OUTBOARD LEFT - HOT, INBOARD LEFT - COLD, INBOARD RIGHT - COLD, OUTBOARD RIGHT - HOT. CORRECTIVE ACTION - INSPECTED BRAKES AND BLED MAIN LANDING GEAR BRAKES IN ACCORDSDR ASOA202205231001Brake Sys · weakDISCREPANCY - ANTI-SKID CATCHES ON APPLICATION OF BRAKES, FULL BREAKING NOT FELT. LEFT CALIPER ON BOTH MAINS GOT REALLY HOT ( RE BREAK TEMPERATURE INDICATORS) BUT RIGHT CALIPER TEMPERATURES HARDLY ROSE UNDER FULL BREAKING ACTION. CORRECTIVE ACTION - TROUBLESHOSDR RAIA2019062760001Battery Pack · inoperativePAX MAIN DOOR CEILING AND GALLEY CEILING EMERGENCY LIGHTS (LIGHTS # 13 AND #8) ARE INOP. REMOVED AND REPLACED BULBS. NO FIX REMOVED AND REPLACED #1 EMERGENCY BATTERY SUPPLY. OPS CHECK GOOD.SDR RAIA2019040980001Light · inoperativeR/H FWD OVERWING EMERGENCY LIGHT #3 INOP- R/R R/H FWD OVERWING EMERGENCY LIGHT #3 ASSY. OPS CHECK GOOD.SDR RAIA201709120001Bulb · inoperativeRIGHT OVERWING EMERGENCE LIGHT WAS INOPERATIVE. R & R THE BULB, OPS CHECKED GOOD.SDR RAIA201611240001Motor · inoperativeFLAPS FAILED IN FLT. REMOVED & REPLACED FLAP POWER DRIVE IAW AMM 27-53-04. OPS CHECK GOOD AT THIS TIME.SDR RAIA201611140001Clamp · looseBLEED 2 LEAK ON CLIMB OUT. TIGHTEND CLAMPS ON THE NR 2 PRECOOLER. PERFORMED GROUND RUN, OPS CHECKED GOOD IAW AMM 36-11-04 AND 36-00-00.SDR RAIA201611130001Seal · wornNR 2 BLEED LEAK AFTER TAKE OFF. R & R BLEED SEALS 11 & 22 IAW AMM 21-20-00. NO LEAKS NOTED AT THIS TIME.SDR RAIA201608040001Bulb · inoperativeRIGHT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. R & R THE BULB, OPS CHECKED GOOD.SDR RAIA201606160002Light · inoperativeCEILING EMERGENCY EXIT LIGHT AT ROW 7, 16B IS INOP. R&R CEILING EMERGENCY EXIT LIGHT BULB AT ROW 7, 16B. OPS CHECK GOOD.SDR RAIA201603020001Unknown · odorLAV SMOKE INDICATION PILOT INSPECTED SAID THERE WAS A HAZE IN THE LAV WITH A SWEET ODOR. PERFORMED ENGINE GROUND RUNS. NO DEFECTS NOTED. PERFORMED INSPECTION OF LAV LIGHTS AND TOILET SYSTEMS, NO DEFECTS NOTED.SDR RAIA201602150003Smoke Warning · false activationLAVATORY SMOKE WARNING IN FLIGHT WITH SMOKE IN CABIN. UNABLE TO DUPLICATE SMOKE.SDR RAIA201602080003Jackscrew · lack of lubeFLAP FAIL IN FLIGHT SELECTED 9 DEGREES BUT INDICATING 0 DEGREES. PERFORMED FLAP SCREW JACK GEAR LUBRICATION ON ALL FLAPS. OPS CHECKING GOOD.SDR RAIA201601110001Acm · smokeSMOKE IN CABIN ON TAKEOFF. C/W SMOKE IN CABIN TROUBLESHOOTING. FOUND SMOKE TO BE DUE TO PACK 2.SDR RAIA201511210001Connector · dirtyEMERGENCY EXIT LIGHT ON PASSENGER DOOR IS INOPERATIVE. MAINTENANCE CLEANED CONNECTORS AND RELAMPED, OPS CHECKED GOOD.SDR RAIA201507120001Jackscrew · underservicedFLAP FAIL MESSAGE ON EICAS DURING APPROACH, EMERGENCY LANDING. MAINTENANCE INSPECTED AND SERVICED FLAP SCREWJACK ACTUATORS, OPS CHECK GOOD.SDR RAIA201507080001Warning Message · false activationFLAP FAIL ON EICAS. 0 DEGREES INDICATED ON ARRIVAL, EMERGENCY LANDING. MAINTENANCE REVIEWED CMC FOR MESSAGES, NO MESSAGES, CLEANED AND INSPECTED CONNECTORS ON FECU AND LT, RT FDMU, PERFORMED OPS CHECK, OPS CHECK GOOD, NO DEFECTS NOTED.SDR RAIA201506240001Light · inoperativeRIGHT OVERWING EMERGENCY EXIT NR 6 IS INOPERATIVE. MAINTENANCE REPLACED LIGHT, OPS CHECK GOOD.SDR RAIA201501280001Outflow Valve · failedLOSS OF CABIN PRESSURE IN FLIGHT, MADE UNSCHEDULED LANDING. MAINTENANCE INSPECTED ACFT AND SAFE FOR 1 TIME FERRY FLIGHT. MAINTENANCE REPLACED GROUND AIR VALVE, OPS CHECK GOOD.SDR RAIA201410130002Bleed Valve · failedNR 2 BLEED VALVE FAILED MESSAGE DURING FLIGHT, RETURNED. MAINTENANCE REPLACED NR 2 ENG BLEED VALVE, OPS CHECKED GOOD.SDR RAIA201404190001Sensor · dirtyLAVATORY SMOKE INDICATION CAME ON DURING CRUISE, THERE WAS NO SMOKE OR ODOR REPORTED. MAINTENANCE INSPECTED LAVATORY AND NO DEFECTS WERE FOUND. MAINTENANCE CLEANED SENSOR AND OPS CHECK GOOD.SDR RAIA201312070001Bulb · inoperativeEMERGENCY EXIT LIGHT IN CEILING OF ROW 22 INOPERATIVE. MAINTENANCE REPLACED BULB, OPS CHECKED GOOD.SDR RAIA201305180002Pump · leakingDURING CRUISE FLIGHT THE CREW REPORTED HYD SYS 1 HAD A LOW FLUID QTY WARNING MESSAGE. THE SYS SLOWLY DROPPED TO ZERO. AFTER ABOUT 20 MINUTES THE CREW REPORTED HYD SYS 1 WAS LOST. CREW DECLARED AN EMERGENCY AND LANDED WITHOUT INCIDENT. MX INSPECTED AND R SDR RAIA201302120001Linkage · lack of lubeDURING POST FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE PASSENGER DOOR WAS DIFFICULT TO OPEN AND CLOSE. MAINTENANCE INSPECTED AND LUBED THE PASSENGER DOOR HANDLE LINKAGE. DOOR OPS CHECKED GOOD.SDR RAIA201208130001Proximity Switch · failedDURING CLIMBOUT OF KIAD, GEAR WENT FROM DOWN AND LOCKED TO UP AND LOCKED WITHOUT A TRANSIT INDICATION. CREW THEN RETURNED A/C TO KIAD FOR MAINTENANCE TO TROUBLESHOOT. MAINTENANCE INSPECTED AND FOUND THAT THE RIGHT MLG UPLOCK NR 2 PROX SWITCH BAD. REMOVED ANSDR RAIA201207230001Unknown · odorF/A REPORTED FUEL SMELL IN AFT OF CABIN IN FLT, MORE PRONOUNCED AT ROWS 16 - 18. MAINTENANCE INSPECTED AIRCRAFT FOR FUEL LEAKS IN INTERIOR PANELS, CARGO PANELS, EXTERIOR PANELS, LAV AREA, RAN ENGINES AND AIR CONDITIONING PACS, PERFORMED INSPECTION OF PRESSURESDR RAIA201206170001Wire Harness · damagedCREW REPORTED A LANDING GEAR AIR GROUND FAIL MSG, LANDING GEAR WOULD NOT RETRACT ON TAKEOFF CLIMBOUT OF KORD. CREW RETURNED A/C WITH AN UNSCHEDULED LANDING TO KORD. MAINTENANCE INSTALLED GEAR PINS AND FERRIED A/C TO KSTL. MAINTENANCE INSPECTED AND FOUND BADSDR RAIA201205100002Unknown · malfunctionedDURING DESCENT INTO KSTL, THE A/C HAD A FLAP LOW SPEED MSG. THE CREW PERFORMED AN EMERGENCY LANDING. MAINTENANCE REMOVED AND REPLACED A FLAP MOTOR AND THE FLAP ELECTRONIC CONTROL UNIT WITH A NO FIX. MAINTENANCE THEN DEFERRED FLAP CHANNEL 1, OPS CHECK GOOD.SDR RAIA201202260001Proximity Switch · faultyDURING TAKEOFF THE FLIGHT CREW RETRACTED THE LANDING GEAR BUT GOT A LANDING GEAR AIR/GND FAIL MESSAGE AND THE LANDING GEAR WOULD NOT RETRACT. AIRCRAFT RETURNED TO STL. MAINTENANCE INSPECTED AND REMOVED AND REPLACED THE RIGHT WOW PROX SWITCH AND THE LEFT MAINSDR RAIA201110280001Strip · looseDURING PRE-FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE EMERGENCY LIGHT STRIP BY GALLEY WAS LOOSE. MAINTENANCE INSPECTED AND RE-SECURED THE LIGHT STRIP. SYSTEM OPS CHECKED GOOD.SDR RAIA201109090001Floorbeam · corrodedDURING HEAVY CHECK INSPECTION MAINTENANCE FOUND THE CENTER FLOORBEAM AT FRAME 59 HAS LEVEL 2 CORROSION. MAINTENANCE REMOVED THE CORROSION FROM THE CENTER FLOORBEAM AT FRAME 59 AND REPAIRED THE CENTER FLOORBEAM AT FRAME 59 IAW ETD 2011-145-104686.SDR RAIA201109070010Sill · corrodedDURING HEAVY CHECK INSPECTION MAINTENANCE FOUND THE CARGO DOOR SILL BEAM HAS LEVEL 2 CORROSION. MAINTENANCE REMOVED AND REPLACED THE CARGO DOOR SILL BEAM BETWEEN FRAMES 65 THRU 67.SDR RAIA201109070009Gusset · corrodedDURING HEAVY CHECK INSPECTION MAINTENANCE FOUND THE GUSSET ON THE CENTER BEAM AT FRAME 59 HAS LEVEL 2 CORROSION. MAINTENANCE REMOVED AND REPLACED THE GUSSET ON THE CENTER BEAM AT FRAME 59.SDR RAIA201109070008Floor Support · corrodedDURING HEAVY CHECK INSPECTION MAINTENANCE FOUND THE EXISTING REPAIR ON THE LEFT BEAM AT FRAME 20 HAS LEVEL 2 CORROSION. MAINTENANCE REMOVED, FABRICATED, AND INSTALLED THE FABRICATED FILLER TO REPAIR THE LEFT OMEGA BEAM AT FRAME 20.SDR RAIA201109070007Angle · corrodedDURING HEAVY CHECK INSPECTION MAINTENANCE FOUND THE ANGLE SUPPORT ON THE LEFT BEAM BETWEEN FRAMES 19 THRU 20 HAS LEVEL 2 CORROSION. MAINTENANCE REMOVED AND REPLACED THE ANGLE SUPPORT ON THE LEFT BEAM BETWEEN FRAMES 19 THRU 20.SDR RAIA201109070006Track · corrodedDURING HEAVY CHECK INSPECTION MAINTENANCE FOUND THE FIRST FLOOR TRACK SECTION ON LEFT BEAM HAS LEVEL 2 CORROSION AT FRAME 18. MAINTENANCE REMOVED AND REPLACED THE FIRST FLOOR TRACK SECTION ON THE LEFT BEAM.SDR RAIA201109070005Doubler · corrodedDURING HEAVY CHECK INSPECTION MAINTENANCE FOUND A DOUBLER ON RIGHT BEAM AT FRAME 22 HAS LEVEL 2 CORROSION. MAINTENANCE REMOVED AND REPLACED DOUBLER ON RIGHT BEAM AT FRAME 22.SDR RAIA201109070004Doubler · corrodedDURING HEAVY CHECK INSPECTION MAINTENANCE FOUND A DOUBLER ON A BEAM AT FRAME 20 HAS LEVEL 2 CORROSION. MAINTENANCE REMOVED AND REPLACED DOUBLER ON FRAME 20.SDR RAIA201109070003Sill · corrodedDURING HEAVY CHECK INSPECTION MAINTENANCE FOUND THE FORWARD SERVICE DOOR SILL HAS LEVEL 2 CORROSION. MAINTENANCE REMOVED AND REPLACED THE FORWARD SERVICE DOOR SILL.SDR RAIA201109070002Support Angle · corrodedDURING HEAVY CHECK INSPECTION MAINTENANCE FOUND A ANGLE UNDER SUPPORT ANGLE HAS LEVEL 2 CORROSION AT THE CENTER BEAM AND FRAME 20. MAINTENANCE REMOVED AND REPLACED SUPPORT ANGLE ON CENTER BEAM AT FRAME 20.SDR RAIA201109070001Support Angle · corrodedDURING HEAVY CHECK INSPECTION MAINTENANCE FOUND A SUPPORT ANGLE WHERE IT ATTACHES TO THE CENTER BEAM AT FRAME 20 HAS LEVEL 2 CORROSION. MAINTENANCE REMOVED AND REPLACED SUPPORT ANGLE AT FRAME 20.SDR RAIA2011061900001Proximity Switch · malfunctionedDURING CLIMB, CREW REPORTED RECEIVING A NLG RED TRANSIT LIGHT WITH A LG LEVER DISAGREE MESSAGE ON THE EICAS. MAINTENANCE REMOVED AND REPLACD A NLG DOWNLOCK PROXIMITY SWITCH AND PERFORMED MULTIPLE LANDING GEAR EXTENSION AND RETRACTION TEST. OPS CHECKED GOOD.SDR RAIA201104010001Guide · out of adjustMAIN DOOR RELEASE LEVER DIFFICULT TO MOVE. FLIGHT ATTENDANT UNABLE TO OPEN DOOR. MAINTENANCE LUBED DOOR SEAL, FRAME SEAL AND ADJUSTED DOOR FRAME GUIDES IAW AMM PROCEDURE, OPS CHECKED GOOD.SDR RAIA201102280003Strip · looseDURING PRE-FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE EMERGENCY LIGHT STRIP AT ROW 1A WAS LOOSE. MAINTENANCE INSPECTED AND RE-SECURED THE LIGHT STRIP. SYSTEM OPS CHECKED GOOD.SDR RAIA201102100001Seal · looseDURING POST FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE PASSENGER DOOR HARD TO OPEN. MAINTENANCE INSPECTED AND FOUND THE PASSENGER DOOR SEAL LOOSE. RE-SECURED THE SEAL.SDR RAIA201011110001Glowstrip · missingDURING PRE-FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE FLOOR PROXIMITY LIGHTING STRIP MISSING SECTION AT 15A. MAINTENANCE INSPECTED AND DEFERRED THE PHOTOLUMINESCENT FLOOR STRIP AT ROW 15.SDR RAIA201010290001Light · looseDURING PRE-FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE EMERGENCY LIGHT STRIP LOOSE IN THE AFT CABIN. MAINTENANCE INSPECTED AND RE-SECURED THE LIGHT STRIP. SYSTEM OPS CHECKED GOOD.SDR RAIA2010090400002Door · lack of lubeFLT 7971 - IAD - CREW REPORTED THAT THE PASSENGER DOOR WAS DIFFICULT TO OPEN. MAINTENANCE PERFORMED GVI, CLEANING, AND LUBRICATION OF THE MAIN CABIN DOOR AND THE RUBBER SEAL. NO DEFECTS NOTED.SDR RAIA201008200002Seal · dirtyDURING POST FLIGHT THE FLIGHT CREW REPORTED THE PASSENGER DOOR DIFFICULT TO OPEN. MAINTENANCE INSPECTED AND CLEANED THE PASSENGER DOOR SEAL. DOOR OPS CHECKED GOOD.
Back to N839HK, cancelled Apr 26, 2023