N138HQ

Service difficulty reports · 76

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 = 'N138HQ' 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.

SDR R61A201410221154Structure · corrodedDURING HEAVY CHECK, RT SPOILER, PCU 3 CONNECTING HARDWARE TO SPOILER HAS CORROSION. MAINTENANCE R & R RT SPOILER PCU 3 CONNECTING HARDWARE TO SPOILER, SE NRWC 038120-2014/388 FOR INSTALL OF SPOILER. PN NAS6212-31D BOLT.Oct 22, 2014 · N138HQ · Emb ERJ170200LR · SpoilersSDR R61A201410221153Structure · corrodedDURING HEAVY CHECK, NR 3 SPOILER ON RT WING, HARDWARE ON INBD HINGE IS CORRODED. MX R & R SPOILER 3 ON RT WING HARDWARE ON INBD HINGE SEE NRWC VP-038120/388 FOR INSTALLATION OF NR 3 SPOILER. PN NAS6304-23D, BOLT.Oct 22, 2014 · N138HQ · Emb ERJ170200LR · SpoilersSDR R61A201410221149Crossbeam · corrodedDURING HEAVY CHECK, RAZOR MARKS ON CROSSBEAM AT FRAME 17 BETWEEN LT AND RT FF1 SEAT TRACK BEAMS. MX REMOVED CORRODED UPPER FLANGE 20 MM X 300 MM AND INSTALLED FILLER AND REPAIR DOUBLER IAW ETD 2014-170-089910, ISSUED DMI R54728/1 FOR REPAIR INSPECTION TASK 5Oct 22, 2014 · N138HQ · Emb ERJ170200LR · Fuselage Main, StructureSDR R61A201410221138Seat Track · corrodedDURING HEAVY CHECK, THE RT SEAT TRACK BETWEEN FRAMES 17-18 AFT OF FWD GALLEY HAS SMALL AREA OF CORROSION. MX R & R THE SEAT TRACK IAW SRM 51-43-01.Oct 22, 2014 · N138HQ · Emb ERJ170200LR · Fuselage, Seat/Cargo Attach FittingsSDR R61A201410221136Rib · crackedDURING HEAVY CHECK, THE RT HORIZONTAL STAB L/E SECOND RIB FROM INBD EDGE IS CRACKED. MX REPAIRED THE RIB IAW ETD 2014-170-089286.Oct 22, 2014 · N138HQ · Emb ERJ170200LR · Horizontal Stabilizer, Spar/RibSDR R61A201410221132Shear Plate · corrodedDURING HEAVY CHECK, SHEAR PLATE UNDER FWD LAV AROUND INBD AFT BOLT HOLE IS CORRODED. MAINTENANCE R & R SHEAR PLATE UNDER FWD LAV IAW SRM 51-40-02,51-41-02.Oct 22, 2014 · N138HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201410211156Firewall · crackedDURING HEAVY CHECK WAS REPORTED THAT APU REMOVABLE FIREWALL 351BZ HAS 2 CRACKS IN TOP AND BOTTOM NEAR BEND. MAINTENANCE CUTOUT CRACKS IN 351BZ TOP AND BOTTOM NEAR BEND REPAIRED FIRE WALL IAW ETD 2014-170-089670, REV A, SEE CONTINUATION CARD VP-038120-2014/15Oct 21, 2014 · N138HQ · Emb ERJ170200LR · APU Cowling/ContainmentSDR R61A201410211148Spar · damagedDURING HEAVY CHECK, RT HORIZONTAL L/E MOUNTING FLANGE ON STABILIZER DAMAGED. MAINTENANCE REWORKED SPAR CAP INSTALLED REPAIR ANGLE IAW ETD 2014-170-088757, REV B SEE CONTINUATION CARDS C1-C4 WORK DETAILS ISSUED DMI R54728/2 FOR REPAIR INSPECTION TASK 55-10-01Oct 21, 2014 · N138HQ · Emb ERJ170200LR · Horizontal Stabilizer, Spar/RibSDR R61A201410211137Support Bracket · crackedDURING HEAVY CHECK, THE LT RAM AIR DUCT SUPPORT BRACKET IS CRACKED. R & R THE SUPPORT BRACKET IAW SRM 51-41-01.Oct 21, 2014 · N138HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201409151065Flashlight · inoperativeCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS INOPERATIVE.Sep 15, 2014 · N138HQ · Emb ERJ170200LR · Emergency EquipmentSDR R61A201407280936Slide · unwanted deployF/A FAILED TO DISARM DOOR AND WHEN DOOR WAS OPENED L1 DOOR SLIDE DEPLOYED. JET BRIDGE PREVENTED SLIDE FROM FULL DEPLOYMENT. MAINTENANCE R & R THE L1 DOOR SLIDE IAW AMM AND OPS CHECKED GOOD.Jul 28, 2014 · N138HQ · Emb ERJ170200LR · Escape SlideSDR R61A201304290434Flashlight · inoperativeCREW REPORTED THE FIRST OFFICERS FLASHLIGHT WAS INOPERATIVE. MAINTENANCE RELAMPED FLASHLIGHT PER EMB AMM 33-51-01 AND OPS CHECKED GOOD.Apr 29, 2013 · N138HQ · Emb ERJ170200LR · Emergency EquipmentSDR R61A201304140372Glowstrip · looseCREW REPORTED THAT A SECTION OF PHOTO LUMINESCENT STRIP WAS LOOSE. MAINTENANCE REMOVED AND REPLACED PHOTO LUMINESCENT STRIP PER EMB AMM 33-50-21 AND OPS CHECKED GOOD.Apr 14, 2013 · N138HQ · Emb ERJ170200LR · Emergency EquipmentSDR R61A201303040216Pin · unsecureCREW REPORTED THAT THE R2 SERVICE DOOR WOULD NOT UNARM. MAINTENANCE FOUND PINS ON DOOR SLIDE OUT. MAINTENANCE RE-SECURED PINS IN DOOR SLIDE PER EMB AMM 52-42-40 AND OPS CHECKED GOOD.Mar 4, 2013 · N138HQ · Emb ERJ170200LR · Escape SlideSDR R61A201209290547Spar · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CRACK LIKE INDICATIONS IN A2 HOLE ON RIGHT WING. MAINTENANCE REAMED A2 HOLE TO .362" IAW EMB 175 SRM 51-40-02, AND SB 170-57-0053 TO REMOVE CRACK LIKE INDICATION. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHESep 29, 2012 · N138HQ · Emb ERJ170200LR · Wing SparSDR R61A201209280538Structure · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE LAV BOX CORRODED. MAINTENANCE REMOVED AND REPLACED THE LAV BOX IAW EMB 175 SRM 51-40-02, AND 51-43-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.Sep 28, 2012 · N138HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201209270539Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE DOUBLER AFT OF RIGHT SEAT TRACK EXTENSION FRAME 89 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT SEAT TRACK EXTENSION DOUBLER FRAME 89 IAW EMB 175 SRM 51-43-03. THE AIRCRAFT IS OUT OF SERVICE IN Sep 27, 2012 · N138HQ · Emb ERJ170200LR · Fuselage, Seat/Cargo Attach FittingsSDR R61A201209270537Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT SEAT TRACK EXTENSION DOUBLER FRAME 90 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT SEAT TRACK EXTENSION DOUBLER FRAME 90 IAW EMB 175 SRM 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CSep 27, 2012 · N138HQ · Emb ERJ170200LR · Fuselage, Seat/Cargo Attach FittingsSDR R61A201209270536Doubler · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT OUTBOARD FLOOR DOUBLER FRAME 90 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT FLOOR DOUBLER FRAME 90 IAW EMB 175 SRM 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.Sep 27, 2012 · N138HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201209270535Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE RIGHT SHEAR PANEL AT FRAMES 87-88 CORRODED. MAINTENANCE REMOVED AND REPLACED THE RIGHT SHEAR PANEL AT FRAMES 87-88 IAW EMB 175 SRM 51-42-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.Sep 27, 2012 · N138HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201209270534Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE CENTER SHEAR PANEL AT FRAMES 87-88 CORRODED. MAINTENANCE REMOVED AND REPLACED THE CENTER SHEAR PANEL AT FRAMES 87 -88 IAW EMB 175 SRM 51-42-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.Sep 27, 2012 · N138HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201209270533Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND LEFT SHEAR PANEL AT FRAME 87-88 CORRODED. MAINTENANCE REMOVED AND REPLACED LEFT SHEAR PANEL AT FRAMES 87-88 IAW EMB 175 SRM 51-42-01, AND 51-42-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.Sep 27, 2012 · N138HQ · Emb ERJ170200LR · Fuselage Miscellaneous StructureSDR R61A201204070215Cable · brokenCREW REPORTED R2 DOOR WOULDN'T DISARM. MAINTENANCE REMOVED AND REPLACED THE R-2 DOOR ARM/DISARM SLIDE CABLE PER EMB AMM. THE R-2 DOOR THEN OPERATED NORMALLY PER EMB AMM OPS CHECKS.Apr 7, 2012 · N138HQ · Emb ERJ170200LR · Escape SlideSDR R61A20110181Door · malfunctionedCREW REPORTED L-1 DOOR WOULDN'T OPEN. MAINTENANCE INSPECTED L-1 DOOR AND PERFORMED OPS CHECKS PER EMB AMM, NO FAULTS FOUND.Jul 9, 2011 · N138HQ · Emb ERJ170200LR · Passenger/Crew DoorsSDR R61A20100098Lever · lack of lubeCREW REPORTED L-1 DISARMED INDICATION WAS BARELY SHOWING GREEN. MAINTENANCE WAS DISPATCHED TO THE AIRCRAFT TO TROUBLESHOOT, AND LUBED THE L-1 DOOR LEVER PER EMB AMM, OPS CHECK GOOD. A/C WAS THEN RELEASED BACK INTO SERVICE.Mar 2, 2010 · N138HQ · Emb ERJ170200LR · Passenger/Crew DoorsSDR R61A20100026Pin · disconnectedTHE L-1 DOOR WILL NOT DISARM. MTX DISCOVERED BUSTLE PINS DISCONNECTED FROM THE SLIDE ASSEMBLY. MTX RE-ATTACHED THE PINS TO THE SLIDE ASSEMBLY, AND THE A/C WAS RETURNED TO SERVICE.Jan 17, 2010 · N138HQ · Emb ERJ170200LR · Escape Slide
Back to N138HQ