N834HK, cancelled Apr 3, 2020
Service difficulty reports · 116
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 = 'N834HK' AND deregistration_id = 'N834HK-2020-04-03' 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 = 'N834HK' AND deregistration_id = 'N834HK-2020-04-03' 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 RAIA201509040001Unknown · odorSTRONG ODOR IN COCKPIT AFTER TURNING PACKS ON AT 1000FF AGL. MAINTENANCE PERFORMED, OPS CHECK OF BOTH PACKS WITH BOTH ENGINES RUNNING AND COULD NOT DUPLICATE FAULT AT THIS TIME, NO FUTHER DEFECTS NOTED.SDR RAIA201508200001Bulb · inoperativePASSENGER DOOR HANDRAIL EMERGENCY FLOOD LIGHT NR 1 INOPERATIVE. MAINTENANCE REPLACED BULBS, OPS CHECK GOOD.SDR RAIA201506210002Light · inoperativeSERVICE DOOR EMERGENCY FLOOD LIGHT NR 2 IS INOPERATIVE. MAINTENANCE REPLACED LIGHT, OPS CHECK GOOD.SDR RAIA201506210001Light · inoperativePASSENGER DOOR STAIR EMERGENCY LIGHT NR 1 IS INOPERATIVE. MAINTENANCE REPLACED LIGHT, OPS CHECK GOOD.SDR RAIA201505100002Bulb · inoperativeFWD CEILING EXIT LOCATOR NR 15 IS INOPERATIVE. MAINTENANCE REPLACED BULB, OPS CHECK GOOD.SDR RAIA201505050001Wire · brokenLANDING GEAR, AIR-GROUND FAIL MSG ON CLIMB, RETURNED TO BLOCK. MAINTENANCE INSPECTED AND FOUND BROKEN WIRE ON RT FWD WOW PROXIMITY SENSOR, REPAIRED BROKEN WIRE AND OPS CHECK GOOD.SDR RAIA201505030001Proximity Switch · inoperativeLANDING GEAR AIR GROUND FAIL WHEN LANDING GEAR LEVER WOULD NOT RETRACT GEAR, RETURNED TO BLOCK. MAINTENANCE REPLACED BOTH RT MLG PROXIMITY SWITCH, OPS CHECK GOOD.SDR RAIA201504290001Wire · brokenFLOOR PROXIMITY EMERGENCY PATH LIGHTING HAS BROKEN WIRE AT EMERGENCY EXIT ROW. MAINTENANCE REPAIRED WIRE, OPS CHECK GOOD.SDR RAIA201504230001Warning Message · false activationLANDING GEAR AIR/GROUND MESSAGE IN FLIGHT, ALSO. WOW AND STICK SHAKERS ON GROUND AFTER RETURNING TO BLOCK. MAINTENANCE C/W AIR/GROUND RESET, PERFORMED OPS CHECKS AND FOUND NO DEFECTS. ACFT WAS RELEASED TO SERVICE.SDR RAIA201502230001Bracket · brokenPASSENGER DOOR DOES NOT OPEN PROPERLY. MAINTENANCE INSPECTED AND REPLACED PASSENGER DOOR STEP ROLLER BRACKET AND MADE ADJUSTMENTS, OPS CHECK GOOD.SDR RAIA201411100002Floor Support · corrodedRT FLOOR SUPPORT BETWEEN FR65 AND 68 IS CORRODED. MAINTENANCE REPLACED THE FLOOR SUPPORT.SDR RAIA201411100001Floor Support · corrodedRIGHT FLOOR SUPPORT BETWEEN FR65 AND 66 HAS CORROSION. MAINTENANCE REPLACED FLOOR SUPPORT.SDR RAIA201411020006Support · corrodedRAMP SUPPORT AT FRAME 18 HAS CORROSION. MAINTENANCE REPLACED RAMP AT FRAME 18.SDR RAIA201411050001Floor Support · corrodedCENTER OMEGA BEAM HAS CORROSION AT FR 59 AROUND FASTENER HOLES. MAINTENANCE REPAIRED OMEGA BEAM BY REPLACING THE AFFECTED AREA WITH A FABRICATED BEAM.SDR RAIA201411040004Gusset · corrodedLEFT GUSSET BETWEEN FR59-61 IS CORRODED. MAINTENANCE REPLACED GUSSET.SDR RAIA201411040006Gusset · corrodedRIGHT GUSSET BETWEEN FR59-61 IS CORRODED. MAINTENANCE REPLACED GUSSET.SDR RAIA201411040005Gusset · corrodedCENTER GUSSET BETWEEN FR 59-61 IS CORRODED. MAINTENANCE REPLACED GUSSET.SDR RAIA201411040003Floor Support · corrodedRIGHT FLOOR SUPPORT BETWEEN FR61-65 CORRODED. MAINTENANCE REPLACED FLOOR SUPPORT.SDR RAIA201411040002Floor Support · corrodedLEFT FLOOR SUPPORT BETWEEN FR61-65 IS CORRODED. MAINTENANCE REPLACED FLOOR SUPPORTSDR RAIA201411040001Floor Support · corrodedRIGHT FLOOR SUPPORT BETWEEN FR59-61 CORRODED. MAINTENANCE REPLACED FLOOR SUPPORT.SDR RAIA201411030003Spar · crackedLEFT WING LOWER SPAR 1 IS CRACKED JUST OTBD OF RIB 9. MAINTENANCE PERFORMED MAJOR REPAIR IAW ETD2014-145-092900A AND TI-145-14-402-E, NO LEAKS FOUND DURING LEAK CHECK.SDR RAIA201411020005Plate · corrodedSILL PLATE CORRODED FROM FRAME 19- FRAME 23. MAINTENANCE REPLACED SILL PLATE.SDR RAIA201411020004Bracket · corrodedPASSENGER DOOR BASE AFT U SHAPE BRACKET CORRODED. MAINTENANCE REPLACED BRACKET.SDR RAIA201411020003Plate · corrodedDIGITAL PLATE AT FR14-16 CORRODED. MAINTENANCE REPLACED DIGITAL PLATE.SDR RAIA201410050002Flashlight · inoperativeAFT FLASHLIGHT BY LAVATORY INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT, OPS CHECK.SDR RAIA201409290001Door · openLOUD VIBRATION FROM NOSE AREA AFTER TAKEOFF AND DURING CLIMB, RETURN TO DEPARTURE. MAINTENANCE INSPECTED AND FOUND FWD GPU DOOR OPEN WITH DAMAGED. MAINTENANCE FOUND NO OTHER HIDDEN DAMAGE AND REMOVED DOOR IAW CDL.SDR RAIA201407060001Duct · leakingDESCENDING THROUGH FL 200, CABIN BEGAN TO CLIMB WITH NO EICAS MESSAGE. CREW RESET NR 2 PACK, CABIN STABILIZED. MAINTENANCE INSPECTED AND FOUND DUCT LEAKING IN THE PACK 2 SYS, REPAIRED DUCT, OPS AND LEAK CHECK GOOD.SDR RAIA201403210001Control Panel · inoperativeEMERGENCY LIGHT TEST SWITCH INOPERATIVE AND F/A CONTROL PANEL. MAINTENANCE INSPECTED AND REPLACED CONTROL PANEL, OPS CHECKED GOOD.SDR RAIA201305130001Actuator · malfunctionedDURING CLIMB FLIGHT CREW GOT A PITCH TRIM MAIN AND BACKUP FAIL MESSAGE ON EICAS. CREW DECLARED AN EMERGENCY AND RETURNED TO IAD. MAINTENANCE INSPECTED AND REMOVED AND REPLACED THE HORZ STAB ACTUATOR. SYSTEM OPS CHECKED GOOD.SDR RAIA201305070001Step · looseDURING POST-FLIGHT INSPECTION THE FLIGHT CREW FOUND THE PASSENGER DOOR HARD TO OPEN. MAINTENANCE INSPECTED AND FOUND THE PASSENGER DOOR SIDE STEP LOOSE. MAINTENANCE TIGHTENED THE SIDE STEP AND THE DOOR OPS CHECKED GOOD.SDR RAIA201303070001Sill · corrodedDURING SCHEDULED INSPECTION THE LEFT FLOOR SILL WAS FOUND TO BE CORRODED AT FRAME 18-246. SILL WAS REMOVED AND REPLACED.SDR RAIA201303040001Channel · corrodedDURING SCHEDULED MAINTENANCE TO CARGO COMPARTMENT ENTRY "Z" CHANNEL WAS FOUND TO BE CORRODED. MAINTENANCE REMOVED AND REPLACED CARGO COMPARTMENT ENTRY "Z" CHANNEL.SDR V0XR201004160005Seat Track · corrodedLT UPPER SEAT TRACK AT FR 17-24 IS CORRODED BEYOND LIMITS. R & R LT UPPER SEAT TRACK. W/C 2183.SDR V0XR201004160003Profile · corrodedPROFILE ON LT SIDE BETWEEN LY 479.0 AND LY 780.0 AT FR 17-18 IS CORRODED BEY0ND LIMITS. R & R PROFILE. W/C 1204.SDR V0XR201004160004Seat Track · corrodedLT LOWER SEAT TRACK AT FR 17-24 IS CORRODED BEYOND LIMITS. R & R LT SEAT TRACK. W/C 2182.SDR V0XR201004160002Seat Track · corrodedLT LOWER SEAT TRACK AT FR 17-24 IS CORRODED BEYOND LIMITS. R & R LT SEAT TRACK. W/C 2182.SDR V0XR201004150009Gusset · corrodedGUSSET OMEGA BEAM LY 479.0 FR 23-29 IS CORRODED BEYOND LIMITS. R & R GUSSET. W/C 1167SDR V0XR201004150008Gusset · corrodedCTR GUSSET FR 35-39 IS CORRODED BEYOND LIMITS. R & R CTR GUSSET. W/C 1176.SDR V0XR201004150007Sill · corrodedRT SILL FR 29-35 IS CORRODED BEYOND LIMITS. R & R RT SILL. W/C 1168.SDR V0XR201004150006Angle · corrodedANGLE AT RY 780.0 FR 23 IS CORRODED BEYOND LIMITS. R & R ANGLE. W/C 1163.SDR V0XR201004150005Angle · corrodedSCALLOPED ANGLE AT Y0.0 - RY 780.0 FR 23 IS CORRODED BEYOND LIMITS. R & R ANGLE. W/C 1162.SDR V0XR201004150004Gusset · corrodedGUSSET AT RY 479.0 FR 59-61 IS CORRODED BEYOND LIMITS. R & R GUSSET. W/C 1156.SDR V0XR201004150003Profile · corrodedAFT FLOOR SUPPORT AT LY 479.0 FR 19-20 IS CORRODED BEYOND LIMITS. R & R FLOOR SUPPORT. W/C 1142.SDR V0XR201004150002Floor Support · corrodedFLOOR SUPPORT AT Y0.0 FR 18-20 IS CORRODED BEYOND LIMITS. R & R SUPPORT. W/C 1135.SDR V0XR201004150001Sill · corrodedRT SILL FWD OF SERVICE DOOR AT RY780.0 FR 18-20 IS CORRODED BEYOND LIMITS. R & R RT SILL. W/C 1131.SDR V0XR201004140003Seat Track · corrodedRT UPPER SEAT TRACK SUPPORT FR 48-52 IS CORRODED BEYOND LIMITS. R & R RT SEAT TRACK. W/C 2215.SDR V0XR201004140002Sill · corrodedLT SILL FR 61-65.5 IS CORRODED BEYOND LIMITS. R & R LT SILL. W/C 1193.SDR V0XR201004140001Sill · corrodedLT SILL FR 59-60.5 IS CORRODED BEYOND LIMITS. R & R LT SILL. W/C 1159.SDR V0XR201004130012Doubler · corrodedDOUBLERS THAT COVER RT BEAM RY479.0 AT FR 20-22 IS CORRODED BEYOND LIMITS. R & R DOUBLERS. W/C 1133.SDR V0XR201004130011Gusset · corrodedCTR GUSSET Y0.0 AT FR 18-23 IS CORRODED BEYOND LIMITS. R & R CTR GUSSET. W/C 1134.
Back to N834HK, cancelled Apr 3, 2020