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.

SDR V0XR201008250001Seat Track · corrodedSEAT TRACK C BETWEEN FR 24-30 IS CORRODED BEYOND LIMITS. REMOVED AND REPLACED SEAT TRACK C. W/C 2096Aug 25, 2010 · N851HK · Emb EMB145LR · Fuselage Main, StructureSDR V0XR201008240003Attach Angle · crackedRT NR 1 BOTTOM WING-BODY ATTACHMENT ANGLE IS CRACKED. R & R CRACKED RT WING-BODY ATTACHMENT ANGLE.Aug 24, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR V0XR201008240002Attach Angle · crackedLT NR1 BOTTOM WING-BODY ATTACHMENT ANGLE IS CRACKED. R & R CRACKED WING-BODY ATTACHMENT ANGLE.Aug 24, 2010 · N851HK · Emb EMB145LR · Fuselage Main, Attach FittingsSDR V0XR201008240001Seat Track · corrodedSEAT TRACK D AT FR 24-30 IS CORRODED BEYOND LIMITS. R & R CORRODED SEAT TRACK.Aug 24, 2010 · N851HK · Emb EMB145LR · Fuselage, Seat/Cargo Attach FittingsSDR V0XR201008230010Seat Track · corrodedSEAT TRACK-D AT FR 47-53 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.Aug 23, 2010 · N851HK · Emb EMB145LR · Fuselage, Seat/Cargo Attach FittingsSDR V0XR201008230009Seat Track · corrodedSEAT TRACK A AT FR 47-53 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.Aug 23, 2010 · N851HK · Emb EMB145LR · Fuselage, Seat/Cargo Attach FittingsSDR V0XR201008230008Seat Track · corrodedSEAT TRACK-A AT FR 36-46 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.Aug 23, 2010 · N851HK · Emb EMB145LR · Fuselage, Seat/Cargo Attach FittingsSDR V0XR201008230007Seat Track · corrodedSEAT TRACK-C AT FR 30-36 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.Aug 23, 2010 · N851HK · Emb EMB145LR · Fuselage, Seat/Cargo Attach FittingsSDR V0XR201008230006Seat Track · corrodedSEAT TRACK B AT FR 24-30 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.Aug 23, 2010 · N851HK · Emb EMB145LR · Fuselage, Seat/Cargo Attach FittingsSDR V0XR201008230005Seat Track · corrodedSEAT TRACK AT FR 24-30 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK. W/C 2093Aug 23, 2010 · N851HK · Emb EMB145LR · Fuselage, Seat/Cargo Attach FittingsSDR V0XR201008230004Seat Track · corrodedSEAT TRACK A AT FR 18-24 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.Aug 23, 2010 · N851HK · Emb EMB145LR · Fuselage, Seat/Cargo Attach FittingsSDR V0XR201008230003Seat Track · corrodedSEAT TRACK B AT FR 18-24 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.Aug 23, 2010 · N851HK · Emb EMB145LR · Fuselage, Seat/Cargo Attach FittingsSDR V0XR201008230002Gusset · corrodedGUSSET LY 479.0 FR 59-62 IS CORRODED BEYOND LIMITS. R & R GUSSET.Aug 23, 2010 · N851HK · Emb EMB145LR · Fuselage Main, StructureSDR V0XR201008230001Gusset · corrodedCENTER GUSSET FR 59-62 IS CORRODED BEYOND LIMITS. R & R CTR GUSSET.Aug 23, 2010 · N851HK · Emb EMB145LR · Fuselage Main, StructureSDR V0XR201008200009Seat Track · corrodedSEAT TRACK FR 30-36 IS CORRODED BEYOND LIMITS. R & R SEAT TRACK.Aug 20, 2010 · N851HK · Emb EMB145LR · Fuselage, Seat/Cargo Attach FittingsSDR V0XR201008200008Angle · corrodedSCALLOPED ANGLE AT LY 479.0 FR 19 IS CORRODED BEYOND LIMITS. R & R PROFILE.Aug 20, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR V0XR201008200007Seat Track · corrodedLT UPPER SEAT TRACK SUPPORT FR 47.5 - 52.5 IS CORRODED BEYOND LIMITS. R & R LT UPPER SEAT TRACK SUPPORT.Aug 20, 2010 · N851HK · Emb EMB145LR · Fuselage, Seat/Cargo Attach FittingsSDR V0XR201008200005Beam · damagedBEAM LY 479.0 - Y0.0 FR 65 IS BENT AND DAMAGED. BEAM R & R.Aug 20, 2010 · N851HK · Emb EMB145LR · Fuselage Main, StructureSDR V0XR201008200004Sill · damagedLT SILL FWD OF SERVICE DOOR AT 780.0 FR 17-20 IS REPAIRED AND REQUIRES REPLACEMENT. LT SILL R & R.Aug 20, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR V0XR201008200003Gusset · corrodedRT OMEGA BEAM GUSSET 479.0 AT FR 59-61 IS CORRODED BEYOND LIMITS. R & R GUSSET.Aug 20, 2010 · N851HK · Emb EMB145LR · Fuselage Main, StructureSDR V0XR201008200002Gusset · corrodedDIGITAL AT FR 19-23 Y0.0 TO 479.0 IS CORRODED BEYOND LIMITS. R & R DIGITAL.Aug 20, 2010 · N851HK · Emb EMB145LR · Fuselage Main, StructureSDR V0XR201008200001Gusset · corroded(V0XR) GUSSET ON BEAM LY 479.0 FR 19-23 IS CORRODED BEYOND LIMITS. REMOVED AND REPLACED GUSSET. W/C 1075Aug 20, 2010 · N851HK · Emb EMB145LR · Fuselage Main, StructureSDR V0XR201008190016Seal · deterioratedLT WING INBD FLAP BUTTE DOOR SEAL DETERIORATED. R & R LT WING INBD FLAP BUTTE DOOR SEAL.Aug 19, 2010 · N851HK · Emb EMB145LR · Wing Main, Frame StructureSDR V0XR201008190015Sill · damaged(V0XR) AFT SERVICE DOOR SILL AT 780.0 FR 22-24 HAS 2 REPAIRS. R & R AFT SERVICE DOOR SILL.Aug 19, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR V0XR201008190014Sill · corrodedCENTER BEAM GUSSET 0.0 AT FR 18-24 IS CORRODED BEYOND LIMITS. R & R CTR GUSSET.Aug 19, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR V0XR201008190013Sill · corrodedLT FWD SILL IS CORRODED BEYOND LIMITS. R & R LT FWD SILL.Aug 19, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR V0XR201008190012Sill · corrodedFWD DIGITAL AT FR 14-17 IS CORRODED BEYOND LIMITS. R & R FWD DIGITAL.Aug 19, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR V0XR201008190011Sill · corrodedPAX DOOR SILL AT FR 20 - 22 IS CORRODED BEYOND LIMITS. R & R PAX DOOR SILL.Aug 19, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR V0XR201008190010Sill · corroded(V0XR) SERVICE DOOR SILL AT FR 20 - 22 IS CORRODED BEYOND LIMITS. R & R SERVICE DOOR SILL.Aug 19, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR V0XR201008190009Gusset · bentGUSSET ON RT OMEGA BEAM AT FR 57 IS BENT AND RIVETS PULLED OUT. R & R GUSSET.Aug 19, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR V0XR201008190008Support Angle · corrodedANGLE 479.0 TO 780.0 AT FR 18 IS CORRODED BEYOND LIMITS. R & R SUPPORT ANGLE.Aug 19, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR V0XR201008190007Floor Support · corrodedBOTTOM SUPPORT ANGLE 780.0 TO 479.0 AT FR 18 IS CORRODED BEYOND LIMITS. R & R SUPPORT ANGLE.Aug 19, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR V0XR201008190006Gusset · corrodedRT FWD AND AFT GUSSETS 479.0 AT FR 20 - 22 ARE CORRODED BEYOND LIMITS. R & R RT FWD AND AFT GUSSETS.Aug 19, 2010 · N851HK · Emb EMB145LR · Fuselage Main, StructureSDR V0XR201008190005Floor Support · corrodedCTR OMEGA BEAM SCALLOPED ANGLE FROM FR 18 - 20 IS CORRODED BEYOND LIMITS. R & R CTR OMEGA BEAM.Aug 19, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR 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.Aug 19, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR V0XR201008190003Cable · brokenBAGGAGE DOOR ASSIST CABLE ASSY HAS SEVERAL BROKEN STRANDS. REMOVED BAGGAGE DOOR ASSIST CABLE ASSY.Aug 19, 2010 · N851HK · Emb EMB145LR · Cargo/Baggage DoorsSDR V0XR201008190002Angle · corrodedRT HORIZ ANGLE FROM Y0.0 TO Y 780.0 AT FR 24 IS CORRODED BEYOND LIMITS. R & R RT HORIZ ANGLE.Aug 19, 2010 · N851HK · Emb EMB145 · Fuselage Miscellaneous StructureSDR V0XR201008190001Angle · corrodedRT HORIZ ANGLE FROM Y0.0 TO Y 780.0 AT FR 24 IS CORRODED BEYOND LIMITS. R & R RT HORIZ ANGLE.Aug 19, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR V0XR201008170002Sill · corroded(V0XR) PAX SOOR SILL ANGLES ARE CORRODED BEYOND LIMITS. R & R PAX DOOR SILL ANGLES.Aug 17, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR V0XR201008170001Sill · corrodedPAX DOOR SILL ANGLES ARE CORRODED BEYOND LIMITS. R & R PAX DOOR SILL ANGLES.Aug 17, 2010 · N851HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR 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.Aug 2, 2010 · N851HK · Emb EMB145LR · Emergency LightingSDR 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 GOOJul 16, 2010 · N851HK · Emb EMB145LR · Passenger/Crew DoorsSDR 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.Jul 2, 2010 · N851HK · Emb EMB145LR · Passenger/Crew DoorsSDR 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.Jun 23, 2010 · N851HK · Emb EMB145LR · Passenger/Crew DoorsSDR 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.Jun 12, 2010 · N851HK · Emb EMB145LR · Passenger/Crew DoorsSDR 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.Jun 1, 2010 · N851HK · Emb EMB145LR · Passenger/Crew DoorsSDR 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.May 27, 2010 · N851HK · Emb EMB145LR · Passenger/Crew DoorsSDR 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.May 7, 2010 · N851HK · Emb EMB145LR · Emergency LightingSDR RAIA2010050700001Light · inoperativeDURING PREFLIGHT CREW FOUND GALLEY EMERGENCY LIGHT INOP. MAINTENANCE INSPECTED AND FOUND BULB INOP. REMOVED AND REPLACED BULB. OPS CHECKED GOOD IAW AMM.May 7, 2010 · N851HK · Emb EMB145LR · Emergency LightingSDR 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 REPLACEMay 6, 2010 · N851HK · Emb EMB145LR · Emergency Lighting
Back to N851HK, cancelled Sep 6, 2019