N845HK, cancelled Apr 12, 2021

Service difficulty reports · 149

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 = 'N845HK' AND deregistration_id = 'N845HK-2021-04-12'
  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 RAIA2020021280001Plate · crackedPLATE @ FR 6 CRACKED IN NLG W/W- REMOVED NOSE WHEELWELL PLATE. REMOVED THE DAMAGE FROM THE NLG W/W UPPER FWD AVI BAY FLOOR PLATE, EDDY CURRENT REQUIRED AROUND CUT-OUT AND AWAITING REPLY FROM EMBRAER TO PROCEED WITH REPAIR. INSPECTED DAMAGE AREA AFTER Feb 8, 2020 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201811020001Crossbeam · corrodedCROSSBEAM BETWEEN FRAMES 16 FRAME 18 LT SIDE ATTACHED TO CARBON SUPPORT HAS CORROSION. REMOVED AND REPLACED CROSSBEAM BETWEEN FRAMES 16-18.Nov 2, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018111130005Attach Fitting · cracked#4 R/H UPPER WING TO FUSELAGE ATTACHMEBNT FITTING IS CRACKED ..............REMOVED AND REPLACED #4 R/H SIDE UPPER WING TO FUSELAGE ATTACHMENT FITTINGOct 31, 2018 · N845HK · Emb EMB145LR · Fuselage, Wing Attach FittingsSDR RAIA2018110810003Attach Fitting · cracked#3 L/H SIDE UPPER WING TO FUSELAGE ATTACHMENT FITTING IS CRACKED.................REPAIRED #3 L/SIDE UPPER WING TO FUSELAGE ATTACHMENT FITTINGOct 31, 2018 · N845HK · Emb EMB145LR · Fuselage, Wing Attach FittingsSDR RAIA2018110810002Attach Fitting · cracked#2L/H SIDE UPPER WING TO FUSELAGE ATTACHMENT FITTING IS CRACKED ........REMOVED AND REPLACED #2 L/H SIDE UPPER WING TO FUSELAGE ATTACHMENT FITTINGOct 31, 2018 · N845HK · Emb EMB145LR · Fuselage, Wing Attach FittingsSDR RAIA2018110630001Rib · corrodedCARGO BAY DOOR AT FRAME 65 RIB CORRODED..................REMOVED AND REPLACED CARGO BAY DOOR AT FRAME 65 RIBOct 30, 2018 · N845HK · Emb EMB145LR · Fuselage Internal Mounting StructureSDR RAIA2018110529003Floor Support · corrodedLEFT OMEGA BEAM BETWEEN FRAMES 52 - 59 HAD CORROSION. REMOVED AND REPLACED THE OMEGA BEAM ASSY.Oct 29, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201810290002Floor Support · corrodedCENTER OMEGA BEAM BETWEEN FRAMES 52-59 HAS CORROSION. REMOVED AND REPLACED CENTER OMEGA ASSY BETWEEN FRAMES 52-59 INCLUDES CENTER OMEGA GUSSET AT FRAMES 52-59.Oct 29, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201810250002Splice · crackedLT SILL SPLICE BETWEEN FRAMES 23-24 IS CRACKED. REMOVED AND REPLACED LT SILL BETWEEN FRAMES 23-24.Oct 25, 2018 · N845HK · Emb EMB135LR · Fuselage Miscellaneous StructureSDR RAIA201810250001Floor Support · corrodedAT FRAME 61 BETWEEN CENTER AND RT OMEGA BEAM T PROFILE IS CORRODED. REMOVED AND REPLACED AT FRAME 61 BETWEEN CENTER AND RT OMEGA BEAM T PROFILE.Oct 25, 2018 · N845HK · Emb EMB135LR · Fuselage Miscellaneous StructureSDR RAIA2018110624001Structure · corrodedSTRUCTURE ON TOP OF LAV CUP HAS CORROSION................REMOVED AND REPLACED STRUCTURE ON TOP OF LAV CUPOct 24, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018110518004Angle · corrodedLOWER Z ANGLE AT CARGO DOOR SHEAR CLIP AT FRAME 65 IS CORRODED................REMOVED AND REPLACED LOWER Z ANGLE AT CARGO BAY DOOR SHEAR CLIP AT FRAME 65Oct 18, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201810180003Floor Support · corrodedOMEGA BEAM AT FRAME 61 HAS CRACKS AT NUTPLATE. FABRICATED AND INSTALLED DOUBLER ON OMEGA BEAM AT FRAME 61.Oct 18, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018111170013Floor Support · corrodedL PROFILE AT FRAME 53 O/B OF R/H OMEGA BEAM HAS CORROSION.............REMOVED AND REPLACED L PROFILE AT FRAME 53 O/B OF R/H OMEGA BEAMOct 17, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018111170012Floor Support · corrodedL PROFILE AT FRAME 30 O/B R/H OMEGA BEAM HAS CORROSION................REMOVED AND REPLACED L PROFILE AT FRAME 30 O/B R/H OMEGA BEAMOct 17, 2018 · N845HK · Emb EMB145LR · Fuselage Internal Mounting StructureSDR RAIA2018110870011Floor Support · corrodedL PROFILE AT FRAME 34 O/B OF R/H OMEGA BEAM HAS CORROSION.................REMOVED AND REPLACED L PROFILE AT FRAME 34 O/B OF R/H OMEGA BEAMOct 17, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018111067010Profile · corrodedL PROFILE AT FRAME 39 O/ OF R/H OMEGA BEAM HAS CORROSION............REMOVED AND REPLACED L PROFILE AT FRAME 39 O/B OF R/H OMEGA BEAM THIS IS A SUPPLEMENTAL REPORT CONTOL # AND DATE WHERE WRONGOct 17, 2018 · N845HK · Emb EMB145LR · Fuselage Internal Mounting StructureSDR RAIA201810170009Support · corrodedFRAME 62 RT LOWER CARBON RING SUPPORT HAS CORROSION. REMOVED AND REPLACED FRAME 62 RT LOWER CARBON RING SUPPORT.Oct 17, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201810170008Floor Support · corrodedFRAME 60 CENTER OMEGA BEAM HAS CORROSION. FABRICATED AND INSTALLED DOUBLER AT FRAME 60 CENTER OMEGA BEAM AT FRAME 60.Oct 17, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201810170007Floor Support · corrodedFRAME 62 CENTER OMEGA BEAM HAS CORROSION. FABRICATED AND INSTALLED DOUBLER ON CENTER OMEGA BEAM AT FRAME 62.Oct 17, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201810170006Floor Support · corrodedFRAME 60 RT OMEGA BEAM HAS CORROSION. FABRICATED AND INSTALLED DOUBLER ON RT OMEGA BEAM AT FRAME 60.Oct 17, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201810170005Floor Support · corrodedFRAME 62 RT OMEGA BEAM HAS CORROSION. FABRICATED AND INSTALLED DOUBLER ON RT OMEGA BEAM AT FRAME 62.Oct 17, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201810170004Floor Support · corrodedL PROFILE AT FRAME 44 O/B OF RT OMEGA BEAM HAS CORROSION. REMOVED AND REPLACED L PROFILE AT FRAME 44 O/B OF RT OMEGA BEAM.Oct 17, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018103070003Structure · corrodedL PROFILE AT FRAME 44 I/B OF RT OMEGA BEAM HAS CORROSION. REMOVED AND REPLACED L PROFILE AT FRAME 44 I/B OF RT OMEGA BEAM.Oct 17, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018103070002Structure · corrodedL PROFILE AT FRAME 49 I/B OF RT OMEGA BEAM HAS CORROSION. REMOVED AND REPLACED L PROFILE AT FRAME 49 I/B OF RT OMEGA BEAM.Oct 17, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018111350004Floor Support · corrodedCENTER OMEGA BEAM FROM FRAMES 38-46 HAS CORROSION..........REMOVED AND REPLACED CENTER OMEGA BEAM FROM FRAMES 38-45Oct 15, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018111250003Floor Support · corrodedCENTER OMEGA BEAM FROM FRAMES 45-52 HAS CORROSION.............REMOVED AND REPLACED CENTER OMEGA BEAM ASSY FROM FRAMES 45-52 THIS IN CLUDES CENTER OMEGA BEAM GUSSETT FROM FRAMES 45-52Oct 15, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201810150001Floor Support · corrodedLT OMEGA BEAM FROM FRAMES 46-52 HAS CORROSION. REMOVED AND REPLACED LT OMEGA BEAM FROM FRAMES 46-52.Oct 15, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018103030005Doubler · corrodedLT DOUBLER AT FRAME 61 HAS SIGNS OF CORROSION. REMOVED AND REPLACED LT DOUBLER AT FRAME 61.Oct 13, 2018 · N845HK · Emb EMB145LR · Fuselage Main, Plate/SkinSDR RAIA2018103030004Doubler · corrodedRT DOUBLER AT FRAME 61 HAS CORROSION. REMOVED AND REPLACED RT DOUBLER AT FRAME 61.Oct 13, 2018 · N845HK · Emb EMB145LR · Fuselage Main, Plate/SkinSDR RAIA2018103030003Door Sill · corrodedREMOVE AND REPLACE SILL AT FRAME 61-65 IS CORRODED. REMOVED AND REPLACED LT SILL BETWEEN FRAMES 61-65.Oct 13, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201810110004Door Sill · corrodedRT SILL FROM FRAME 61-65 HAS CORROSION. REMOVED AND REPLACED RT SILL FROM FRAMES 61-65.Oct 11, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018111350006Static Port · corrodedR/H AFT STATIC PORT HAS SIGNS OF CORROSION...............REMOVED AND REPLACED STATIC PORT FITTINGOct 10, 2018 · N845HK · Emb EMB145LR · Pitot/Static SystemSDR RAIA201810090040Floor Support · corrodedLT OMEGA BEAM BETWEEN FRAMES 24-30HAS SIGNS OF CORROSION. REMOVED AND REPLACED LT OMEGA BEAM ASSY BETWEEN FRAMES 24-30 ALSO INCLUDES GUSSETS BETWEEN FRAMES 24-30.Oct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018111390040Floor Support · corrodedCENTER OMEGA BEAM GUSSETT AT FRAME 40-45 HAS SIGNS OF CORROSION...........REMOVED AND REPLACED CENTER OMEGA BEAM GUSSETT AT FRAME 40-45Oct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201810090039Floor Support · corrodedL/H OMEGA BEAM FROM FRAMES 29-35 HAS SIGNS OF CORROSION...............REMOVED AND REPLACED OMEGA BEAM FROM FRAMES 29-35Oct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Internal Mounting StructureSDR RAIA2018111390038Gusset · corrodedL/H GUSSETT FROM FRAMES 29-35 HAS SIGNS OF CORROSION............REMOVED AND REPLACED L/H GUSSETT FROM FRAMES 29-35Oct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018111190037Floor Support · corrodedL/H OMEGA BEAM I/B L ANGLE CRACKED AT FRAMES 16-17...........REMOVED AND REPLACED L/H OMEGA BEAM I/B L ANGLE AT FRAMES 16-17Oct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Internal Mounting StructureSDR RAIA2018111190036Floor Support · corrodedL/H OMEGA BEAM FROM FRAMES 35-38 SHOWS SIGNS OF CORROSION ...........REMOVED AND REPLCED L/H OMEGA BEAM FROM FRAMES 35-38Oct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018111090035Gusset · corrodedL/H GUSSETT FROM FRAMES 35-38 HAS SIGNS OF CORROSION........REMOVED AND REPLACED L/H GUSSETT FROM FRAMES 35-38Oct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201811089034Door Sill · corrodedAFT SERVICE DOOR SILL AT FRAME 23 HAS CORROSION........REMOVED AND REPLACED AFT SERVICE DOOR SILLOct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201811069033Support Angle · corrodedL ANGLE SUPPORT AT FRAME 23 FROM AFT SILL TO CENTERGUSSETT SIGNS OF CORROSION....REMOVED AND REPLACED L ANGLE SUPPORT AT FRAME 23 FROM AFT SILL TO CENTER GUSSETTOct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018110570032Profile · corrodedPROFILE AT FRAME 39, OTBD OF RT OMEGA BEAM HAD CORROSION. REMOVED AND REPLACED THE PROFILE.Oct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018110590032Gusset · corrodedLEFT OMEGA BEAM BETWEEN FRAMES 20-23 GUSSET HAD SIGNS OF CORROSION. REMOVED AND REPLACED THE OMEGA BEAM GUSSET.Oct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201811059031Support · corrodedLEFT SILL BETWEEN FRAMES 29 - 34 WAS CORRODED. REMOVED AND REPLACED THE SILL.Oct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201810090030Door Sill · corrodedLT SILL FROM FRAME 24-29 HAS CORROSION. REMOVED AND REPLACED LT SILL FROM FRAME 24-29.Oct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201810090029Floor Support · corrodedRT COCKPIT FLOOR SUPPORT AT FRAME 9 IS CORRODED. REMOVED AND REPLACED RT COCKPIT FLOOR SUPPORT AT FRAME 9.Oct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201810090028Door Sill · corrodedRT SILL BETWEEN FRAME 23-36 IS CORRODED. REMOVED AND REPLACED RT SILL BETWEEN FRAMES 23-36.Oct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA201810090026Floor Support · corrodedLT OMEGA BEAM AT FRAME 45-52 SHOWS SIGNS OF CORROSION. REMOVED AND REPLACED LT OMEGA BEAM AT FRAME 45-52.Oct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous StructureSDR RAIA2018103090025Door Sill · corrodedRT FLOOR SILL AT FRAME 48-52 IS CORRODED. REMOVED AND REPLACED RT FLOOR SILL AT FRAME 48-52.Oct 9, 2018 · N845HK · Emb EMB145LR · Fuselage Miscellaneous Structure
Back to N845HK, cancelled Apr 12, 2021