N851HK, cancelled Sep 6, 2019
Service difficulty reports · 61
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 = 'N851HK' AND deregistration_id = 'N851HK-2019-09-06' 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 = 'N851HK' AND deregistration_id = 'N851HK-2019-09-06' 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 V0XR201008250001Seat Track · corrodedSEAT TRACK C BETWEEN FR 24-30 IS CORRODED BEYOND LIMITS. REMOVED AND REPLACED SEAT TRACK C. W/C 2096SDR V0XR201008240003Attach Angle · crackedRT NR 1 BOTTOM WING-BODY ATTACHMENT ANGLE IS CRACKED. R & R CRACKED RT WING-BODY ATTACHMENT ANGLE.SDR V0XR201008240002Attach Angle · crackedLT NR1 BOTTOM WING-BODY ATTACHMENT ANGLE IS CRACKED. R & R CRACKED WING-BODY ATTACHMENT ANGLE.SDR V0XR201008240001Seat Track · corrodedSEAT TRACK D AT FR 24-30 IS CORRODED BEYOND LIMITS. R & R CORRODED SEAT TRACK.SDR V0XR201008230010Seat Track · corrodedSEAT TRACK-D AT FR 47-53 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.SDR V0XR201008230009Seat Track · corrodedSEAT TRACK A AT FR 47-53 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.SDR V0XR201008230008Seat Track · corrodedSEAT TRACK-A AT FR 36-46 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.SDR V0XR201008230007Seat Track · corrodedSEAT TRACK-C AT FR 30-36 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.SDR V0XR201008230006Seat Track · corrodedSEAT TRACK B AT FR 24-30 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.SDR V0XR201008230005Seat Track · corrodedSEAT TRACK AT FR 24-30 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK. W/C 2093SDR V0XR201008230004Seat Track · corrodedSEAT TRACK A AT FR 18-24 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.SDR V0XR201008230003Seat Track · corrodedSEAT TRACK B AT FR 18-24 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.SDR V0XR201008230002Gusset · corrodedGUSSET LY 479.0 FR 59-62 IS CORRODED BEYOND LIMITS. R & R GUSSET.SDR V0XR201008230001Gusset · corrodedCENTER GUSSET FR 59-62 IS CORRODED BEYOND LIMITS. R & R CTR GUSSET.SDR V0XR201008200009Seat Track · corrodedSEAT TRACK FR 30-36 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.SDR V0XR201008200008Angle · corrodedSCALLOPED ANGLE AT LY 479.0 FR 19 IS CORRODED BEYOND LIMITS. R & R PROFILE.SDR V0XR201008200007Seat Track · corrodedLT UPPER SEAT TRACK SUPPORT FR 47.5 - 52.5 IS CORRODED BEYOND LIMITS. R & R LT UPPER SEAT TRACK SUPPORT.SDR V0XR201008200005Beam · damagedBEAM LY 479.0 - Y0.0 FR 65 IS BENT AND DAMAGED. BEAM R & R.SDR V0XR201008200004Sill · damagedLT SILL FWD OF SERVICE DOOR AT 780.0 FR 17-20 IS REPAIRED AND REQUIRES REPLACEMENT. LT SILL R & R.SDR V0XR201008200003Gusset · corrodedRT OMEGA BEAM GUSSET 479.0 AT FR 59-61 IS CORRODED BEYOND LIMITS. R & R GUSSET.SDR V0XR201008200002Gusset · corrodedDIGITAL AT FR 19-23 Y0.0 TO 479.0 IS CORRODED BEYOND LIMITS. R & R DIGITAL.SDR V0XR201008200001Gusset · corroded(V0XR) GUSSET ON BEAM LY 479.0 FR 19-23 IS CORRODED BEYOND LIMITS. REMOVED AND REPLACED GUSSET. W/C 1075SDR V0XR201008190016Seal · deterioratedLT WING INBD FLAP BUTTE DOOR SEAL DETERIORATED. R & R LT WING INBD FLAP BUTTE DOOR SEAL.SDR V0XR201008190015Sill · damaged(V0XR) AFT SERVICE DOOR SILL AT 780.0 FR 22-24 HAS 2 REPAIRS. R & R AFT SERVICE DOOR SILL.SDR V0XR201008190014Sill · corrodedCENTER BEAM GUSSET 0.0 AT FR 18-24 IS CORRODED BEYOND LIMITS. R & R CTR GUSSET.SDR V0XR201008190013Sill · corrodedLT FWD SILL IS CORRODED BEYOND LIMITS. R & R LT FWD SILL.SDR V0XR201008190012Sill · corrodedFWD DIGITAL AT FR 14-17 IS CORRODED BEYOND LIMITS. R & R FWD DIGITAL.SDR V0XR201008190011Sill · corrodedPAX DOOR SILL AT FR 20 - 22 IS CORRODED BEYOND LIMITS. R & R PAX DOOR SILL.SDR V0XR201008190010Sill · corroded(V0XR) SERVICE DOOR SILL AT FR 20 - 22 IS CORRODED BEYOND LIMITS. R & R SERVICE DOOR SILL.SDR V0XR201008190009Gusset · bentGUSSET ON RT OMEGA BEAM AT FR 57 IS BENT AND RIVETS PULLED OUT. R & R GUSSET.SDR V0XR201008190008Support Angle · corrodedANGLE 479.0 TO 780.0 AT FR 18 IS CORRODED BEYOND LIMITS. R & R SUPPORT ANGLE.SDR V0XR201008190007Floor Support · corrodedBOTTOM SUPPORT ANGLE 780.0 TO 479.0 AT FR 18 IS CORRODED BEYOND LIMITS. R & R SUPPORT ANGLE.SDR V0XR201008190006Gusset · corrodedRT FWD AND AFT GUSSETS 479.0 AT FR 20 - 22 ARE CORRODED BEYOND LIMITS. R & R RT FWD AND AFT GUSSETS.SDR V0XR201008190005Floor Support · corrodedCTR OMEGA BEAM SCALLOPED ANGLE FROM FR 18 - 20 IS CORRODED BEYOND LIMITS. R & R CTR OMEGA BEAM.SDR V0XR201008190004Floor Support · corroded(V0XR) CTR BEAM ANGLE AT CARBON FIBER FLOOR SUPPORT AND SCALLOPED ANGLE AT FR 20 IS CORRODED BEYOND LIMITS. R & R CTR BEAM ANGLE.SDR V0XR201008190003Cable · brokenBAGGAGE DOOR ASSIST CABLE ASSY HAS SEVERAL BROKEN STRANDS. REMOVED BAGGAGE DOOR ASSIST CABLE ASSY.SDR V0XR201008190002Angle · corrodedRT HORIZ ANGLE FROM Y0.0 TO Y 780.0 AT FR 24 IS CORRODED BEYOND LIMITS. R & R RT HORIZ ANGLE.SDR V0XR201008190001Angle · corrodedRT HORIZ ANGLE FROM Y0.0 TO Y 780.0 AT FR 24 IS CORRODED BEYOND LIMITS. R & R RT HORIZ ANGLE.SDR V0XR201008170002Sill · corroded(V0XR) PAX SOOR SILL ANGLES ARE CORRODED BEYOND LIMITS. R & R PAX DOOR SILL ANGLES.SDR V0XR201008170001Sill · corrodedPAX DOOR SILL ANGLES ARE CORRODED BEYOND LIMITS. R & R PAX DOOR SILL ANGLES.SDR RAIA201008020002Power Supply · dischargedDURING PRE-FLIGHT INSPECTION THE FLIGHT CREW REPORTED ALL EMERGENCY LIGHTS POWERED BY POWER SUPPLY NR 3 INOP. MAINTENANCE INSPECTED AND REMOVED AND REPLACED THE EMERGENCY LIGHT POWER SUPPLY. SYSTEM OPS CHECKED GOOD.SDR RAIA201007160001Bolt · looseDURING POST FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE PASSENGER DOOR HARD TO OPEN AND CLOSE. MAINTENANCE INSPECTED AND TIGHTENED PASSENGER DOOR INNER HANDLE BOX BOLTS. PERFORMED PUSH TEST AND FOUND IT TO BE WITHIN LIMITS AT 48 LBS. DOOR OPS CHECKED GOOSDR RAIA201007020003Seal · lack of lubeDURING PRE-FLIGHT THE FLIGHT CREW REPORTED THE PASSENGER DOOR .5 INCH FROM CLOSING. MAINTENANCE INSPECTED AND LUBED THE PASSENGER DOOR SEAL. DOOR OPS CHECKED GOOD.SDR RAIA201006230001Door · bindingDURING POST FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE PASSENGER DOOR HARD TO OPEN. MAINTENANCE INSPECTED AND OPS CHECKED THE PASSENGER DOOR. OPS CHECKED GOOD.SDR RAIA201006120001Seal · obstructedDURING POST FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE PASSENGER DOOR HARD TO OPEN. MAINTENANCE INSPECTED AND REMOVED EXCESS SEALANT OFF OF THE CABIN DOOR SEAL. DOOR OPS CHECKED GOOD.SDR RAIA2010060100001Door · lack of lubeDURING POST FLIGHT INSPECTION THE FLIGHT CREW REPORTED, UNABLE TO OPEN THE PASSENGER DOOR. MAINTENANCE INSPECTED AND LUBED THE PASSENGER DOOR. DOOR OPS CHECKED GOOD.SDR RAIA201005270001Hinge · lack of lubeDURING PRE-FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE PASSENGER DOOR DIFFICULT TO OPEN. MAINTENANCE INSPECTED AND LUBRICATED THE PASSENGER DOOR HINGES AND STOPS. PASSENGER DOOR OPS CHECKED GOOD.SDR RAIA201005070005Light · inoperativeDURING PRE-FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE GALLEY EMERGENCY LIGHT NR 8 INOP. MAINTENANCE INSPECTED AND REMOVED AND REPLACED GALLEY EMERGENCY LIGHT BULB. SYSTEM OPS CHECKED GOOD.SDR RAIA2010050700001Light · inoperativeDURING PREFLIGHT CREW FOUND GALLEY EMERGENCY LIGHT INOP. MAINTENANCE INSPECTED AND FOUND BULB INOP. REMOVED AND REPLACED BULB. OPS CHECKED GOOD IAW AMM.SDR RAIA2010050600001Light · inoperativeDURING THE PREFLIGHT INSPECTION, THE CREW REPORTED THAT EMERGENCY LIGHTS AT THE GALLEY BULKHEAD AND AT THE REAR OF THE CABIN AS BEING INOPERATIVE. MAINTENANCE INSPECTED BOTH LIGHT ASSEMBLIES AND RECONNECTED THE BULKHEAD EMERGENCY LIGHT AND REMOVED AND REPLACE
Back to N851HK, cancelled Sep 6, 2019