N835HK
Service difficulty reports · 156
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 = 'N835HK' AND registry_match = 'registration' 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 = 'N835HK' AND registry_match = 'registration' 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 RAIA201408140001Angle · corrodedLEFT RAMP ANGLE BY PASSENGER DOOR CORRODED AT FR20. MAINTENANCE REPLACED LT RAMP ANGLE.SDR RAIA201408130001Channel · corrodedCARGO DOOR CHANNEL CORRODED. MAINTENANCE REPLACED CARGO DOOR CHANNEL.SDR RAIA201405020001Proximity Switch · failedLANDING GEAR AIR GROUND FAIL ON EICAS DURING CLIMB, RETURNED TO DEPARTURE. MAINTENANCE INSPECTED AND REPLACED AFT WOW PROXIMITY SWITCH AND AFT DOWNLOCK PROXIMITY SWITCH, OPS CHECKED GOOD.SDR RAIA201311150001Bulb · inoperativeRIGHT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. MAINTENANCE REPLACED BULB, OPS CHECKED GOOD.SDR RAIA201306040001Seal · wornDURING POST FLIGHT INSPECTION, FLIGHT CREW FOUND THE PASSENGER DOOR HARD TO OPEN. MX INSPECTED, R & R PASSENGER DOOR SEAL AND AIRFRAME SEAL. DOOR OPS CHECKED GOOD.SDR RAIA201306030001Seal · dirtyDURING POST FLIGHT INSP THE FLIGHT CREW FOUND THE PASSENGER DOOR HARD TO OPEN. MX INSPECTED, CLEANED AND LUBED THE PASSENGER DOOR SEAL. DOOR OPS CHECKED GOOD.SDR RAIA201305040001Wire Harness · faultyDURING CRUISE FLIGHT THE APU FAILED. AIRCRAFT RETURNED TO STL. MAINTENANCE INSPECTED AND REMOVED AND REPLACED THE APU WIRING HARNESS. AUP OPS CHECKED GOOD.SDR RAIA201305020001Flashlight · inoperativeDURING SCHEDULED MAINTENANCE THE F/O'S FLASHLIGHT WAS FOUND INOP. MAINTENANCE REMOVED AND REPLACED THE FLASHLIGHT. LIGHT OPS CHECKED GOOD.SDR RAIA201212310001Elt · malfunctionedDURING SCHEDULED MAINTENANCE THE ELT WOULD NOT DEACTIVATE. MAINTENANCE INSPECTED AND REMOVED AND REPLACED THE ELT. SYSTEM OPS CHECKED GOOD.SDR RAIA201210080001Glowstrip · damagedDURING PRE-FLIGHT INSPECTION THE FLIGHT CREW FOUND THE PHOTO LUMINESCENT EMERGENCY LIGHT STRIP DAMAGED. MAINTENANCE INSPECTED AND REMOVED AND REPLACED THE LIGHT STRIP. OPS CHECKED GOOD.SDR RAIA201207040001Unknown · odorCREW REPORTED THE A/C HAD STRONG CHEMICAL SMELL POST ANTI ICE ACTIVATION DURING CRUISE. MAINTENANCE PERFORMED ENGINE RUNS AND PERFORMED ANTI ICE TEST AND OPS CHECKED GOOD.SDR RAIA201207030001Door · lack of lubeCREW REPORTED MAIN PASSENGER DOOR HARD TO OPEN. MAINTENANCE PERFORMED LUBRICATION AND OPS CHECKED GOOD.SDR RAIA201207010001Handle · lack of lubeCREW REPORTED MAIN PASSENGER DOOR HANDLE HARD TO OPERATE. MAINTENANCE LUBED HANDLE AND LOCKING MECHANISM, OPS CHECK GOOD.SDR RAIA201110120001Glowstrip · looseDURING POST-FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE PHOTOLUMINESCENT LIGHT STRIP LOOSE AT SEAT 2A. MAINTENANCE INSPECTED AND RE-SECURED THE LIGHT STRIP. SYSTEM OPS CHECKED GOOD.SDR RAIA201108080002Light · faultyDURING PRE-FLIGHT INSPECTION THE FLIGHT CREW REPORTED SMOKE COMING FROM THE LAV LIGHT ASSEMBLY. MAINTENANCE INSPECTED AND DISCONNECTED THE FAULTY LIGHT ASSEMBLY AND PLACED IT ON NEF 25-400-4.SDR RAIA201007310001Linkage · lack of lubeDURING PRE-FLIGHT INSPECTION THE FLIGHT REPORTED THE PASSENGER DOOR WOULD NOT OPEN FROM THE OUTSIDE. MAINTENANCE INSPECTED AND LUBRICATED THE DOOR LINKAGE. DOOR OPS CHECKED GOOD.SDR RAIA201105250001Linkage · out of adjustDURING PRE-FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE PASSENGER DOOR WILL NOT OPEN. MAINTENANCE INSPECTED AND ADJUSTED AND RIGGED THE PASSENGER DOOR. DOOR OPS CHECKED GOOD.SDR RAIA201103050001Strip · missingDURING POST FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE EMERGENCY FLOOR STRIP BY GALLEY MARKING EXIT WAS MISSING. MAINTENANCE INSPECTED AND REPLACED THE EMERGENCY LIGHT STRIP. SYSTEM OPS CHECKED GOOD.SDR RAIA201102200001Light · malfunctionedDURING POST FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE EMERGENCY LIGHT NR 7 INOP. MAINTENANCE INSPECTED AND PERFORMED AN OPS CHECK OF THE SYSTEM AND NO DEFECTS WERE FOUND. SYSTEM OPS CHECKED GOOD.SDR V0XR201102040001Structure · crackedRIGHT MLG LOWER DOOR CRACKED. R & R RT MLG DOOR.SDR V0XR201102010006Gusset · corrodedLEFT GUSSET AT FR 40-46 IS CORRODED BEYOND LIMITS. R & R GUSSET.SDR V0XR201102010005Gusset · corrodedLEFT GUSSET AT FR 46-52 IS CORRODED BEYOND LIMITS. R & R GUSSET.SDR V0XR201102010003CGusset · corrodedLEFT GUSSET AT FR 46-52 IS CORRODED BEYOND LIMITS. R & R GUSSET.SDR V0XR201102010003BSill · corrodedLEFT SILL AT FR 36-42 IS CORRODED BEYOND LIMITS. R & R SILL.SDR V0XR201102010003ADoubler · corrodedDOUBLERS AT FR 20-22 OF Y-479L IS CORRODED BEYOND LIMITS. R & R DOUBLERS.SDR V0XR201102010002Angle · corrodedPROFILE ANGLE AFT OF FR 18 Y-479L IS CORRODED BEYOND LIMITS. R & R ANGLE.SDR V0XR201102010001Support Angle · crackedLEFT NR 2 LOWER WING-BODY SUPPORT ANGLE IS CRACKED. R & R ANGLE.SDR V0XR201101280008Bracket · crackedLEFT ENG BLEED AIR DUCT BRACKET IS CRACKED. R & R SUPPORT.SDR V0XR201101280007Bracket · crackedRT ENG BLEED AIR DUCT BRACKET IS CRACKED. R & R SUPPORT.SDR V0XR201101280006Gusset · corrodedLEFT GUSSET AT FR 35-40 IS CORRODED BEYOND LIMITS. R & R GUSSET.SDR V0XR201101280005Gusset · corrodedFLOOR GUSSET AT FR 53-59, Y-479.0L IS CORRODED BEYOND LIMITS. R & R GUSSET.SDR V0XR201101280004Beam · corrodedBEAM AT FR 22, Y-479.0L TO OTBD SILL IS CORRODED BEYOND LIMITS. R & R BEAM.SDR V0XR201101280003Sill · corrodedSILL AFT OF FWD SERVICE DOOR IS CORRODED BEYOND LIMITS. R & R SILL.SDR V0XR201101280002Support · corrodedSUPPORT AT FR 61 Y-479.0L IS CORRODED BEYOND LIMITS. R & R SUPPORT.SDR V0XR201101280001Support Angle · crackedLEFT NR 1 LOWER WING-BODY SUPPORT ANGLE IS CRACKED. R & R ANGLE.SDR V0XR201101270006Angle · corrodedANGLE (SCALLOPED) AT FR 23 RY 780.0 AND RY O IS CORRODED BEYOND LIMITS. R & R ANGLE. W/C 1118SDR V0XR201101270005Angle · corrodedANGLE AT FR 23 BETWEE RY 780.0 AND RY O IS CORRODED BEYOND LIMITS. R & R ANGLE. W/C 1117SDR V0XR201101270004Angle · corrodedGUSSET SUPPORT ANGLES (2) AT FR 21 LT SIDE OF CTR OMEGA BEAM CORRODED BEYOND LIMITS. R & R ANGLES. W/C 1091SDR V0XR201101270003Gusset · corrodedGUSSET AT FR 20-23 Y0.0 IS CORRODED BEYOND LIMITS. R & R GUSSET. W/C 1088SDR V0XR201101270002Angle · corrodedANGLE AT FR 20 Y0.0 IS CORRODED BEYOND LIMITS. R & R ANGLE. W/C 1085SDR V0XR201101270001Support · corrodedTAPERED SUPPORT AT FR 19-20 Y0.0 IS CORRODED BEYOND LIMITS. R & R SUPPORT. W/C 1077SDR V0XR201101260010Sill · corrodedRIGHT SILL AT FR 61-65 IS CORRODED BEYOND LIMITS. R & R SILL. W/C 1116.SDR V0XR20110126000Sill · corrodedRIGHT SILL AT FR 53-59 IS CORRODED BEYOND LIMITS. R & R SILL. W/C 1097.SDR V0XR201101260009Sill · corrodedLEFT SILL AT FR 53-59 IS CORRODED BEYOND LIMITS. R & R GUSSET. W/C 1095.SDR V0XR201101260008Gusset · corrodedGUSSET AT FR 69-51, Y-479.0 R IS CORRODED BEYOND LIMITS. R & R GUSSET. W/C 1089.SDR V0XR201101260007Sill · corrodedLEFT SILL AT FR 23-29 IS CORRODED BEYOND LIMITS. R & R SILL. W/C 1084.SDR V0XR201101260006Sill · corrodedRT SILL AT FR 29-35 IS CORRODED BEYOND LIMITS. R & R SILL. W/C 1082.SDR V0XR201101260005Sill · corrodedSILL AFT OF PAX DOOR AT FR 19-23L IS CORRODED BEYOND LIMITS. R & R SILL. W/C 1081.SDR V0XR201101260004Floor Support · corrodedOMEGA BEAM AT FR 19-24 YO.O IS CORRODED BEYOND LIMITS. R & R BEAM. W/C 1079.SDR V0XR201101260003Floor Support · corrodedOMEGA BEAM AT FR 19-24 Y479.0 R IS CORRODED BEYOND LIMITS. R & R BEAM. W/C 1078.
Back to N835HK