N119HQ
Service difficulty reports · 91
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 = 'N119HQ' 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.
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 = 'N119HQ' AND registry_match = 'registration' 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 R61A201511010801Floor Support · corrodedDURING HEAVY CHECK, RT FLOOR SUPPORT AT FRAMES 86-90 IS CORRODED. MAINTENANCE R & R RT FLOOR SUPPORT IAW SRM 51-42-01, 51-43-03.SDR R61A201511010799Floorbeam · corrodedDURING HEAVY CHECK, RT AFT FLOORBEAM AT FRAME 17 IS CORRODED. MAINTENANCE R & R RT AFT FLOORBEAM IAW SRM 51-41-02, 51-43-04, PN 170-05661-003, SILL.SDR R61A201511010798Floorbeam · corrodedDURING HEAVY CHECK, RT FLOORBEAM AT FRAME 84 IS CORRODED. MAINTENANCE R & R RT FLOORBEAM IAW SRM 51-41-01, 51-41-02, 51-43-04, PN 170-92908-001, FLOOR SILL.SDR R61A201511010791Shear Plate · corrodedDURING HEAVY CHECK, RT SHEAR PLATE AT FRAME 87-88 IS CORRODED. MAINTENANCE R & R RT SHEAR PLATE AT FRAME 87-88 IAW SRM 51-40-02, 51-23-04, PN 170-66409-001, SHEAR PLATE. ACFT REMAINS UNTIL HEAVY CHECK IS COMPLETED.SDR R61A201511010790Seat Track · corrodedDURING HEAVY CHECK, RT FLOORBEAM AT FRAME 18, AT RIVET IS CORRODED. MAINTENANCE REPAIRED DAMAGE TO RT FLOORBEAM AT FRAME 18 IAW ETD 2015-170-102258, SRM 51-10-03, PN 170-03264-001 SEAT TRACK.SDR R61A201511010788Seat Track · corrodedDURING HEAVY CHECK, WAS REPORTED THAT CENTER SPLICE AT FRAME 90 IS CORRODED. MAINTENANCE R & R CENTER SPLICE AT FRAME 90, PN 170-86119-005, FRAME.SDR R61A201511010786Seat Track · corrodedDURING HEAVY CHECK RT SEAT TRACK Y=10.748 AT FRAME 84 IS CORRODED. MAINTENANCE BLENDED AND FABRICATED DOUBLER AND INSTALLED IAW ETD-170-102078.SDR R61A201511010785Shear Plate · corrodedDURING HEAVY CHECK CENTER SHEAR PLATE FRAME 87-88 IS CORRODED. MAINTENANCE R & R CENTER SHEAR PLATE FRAME 87-88 IAW SRM 51-42-01, 51-21-02, 51-23-05, 51-23-06, PN 170-66408-001, SHEAR PLATE.SDR R61A201509120629Light · looseMAINTENANCE REPORTED THAT THE EMERGENCY LIGHT AT SEAT 1D WAS LOOSE. MAINTENANCE SECURED THE EMERGENCY LIGHT STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201412071221Autopilot Sys · malfunctionedCREW REPORTED THAT THE AUTO PILOT DISENGAGED AND SHORTLY AFTER RECEIVED SLAT FAIL, SHAKER ANTICIPATED, AP FAIL, AOA LIMIT FAIL AND SPOILER FAIL MESSAGES. CREW RAN QRH, CONTACTED MAINTENANCE CONTROL AND ELECTED TO CONTINUE. ABOUT 100 MILES FROM DESTINATION, CRSDR R61A201406230785Flashlight · inoperativeCREW REPORTED THAT THE CAPTAIN`S FLASHLIGHT WAS INOPERATIVE. MAINTENANCE R & R THE FLASHLIGHT IAW AMM AND OPS CHECKED GOOD.SDR R61A201405280703Cradle · brokenCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT HOLDER WAS BROKEN. MAINTENANCE R & R FORWARD F/A FLASHLIGHT HOLDER IAW AMM AND OPS CHECKED GOOD.SDR R61A201310271063Arm · contaminatedCREW REPORTED THAT THE L2 DOOR WOULD NOT CLOSE. MAINTENANCE INSPECTED IAW AMM AND REMOVED DEBRIS FROM THE L2 DOOR SUPPORT ARM. DOOR OPS CHECKED GOOD AND ACFT IS GOOD FOR SERVICE.SDR R61A201310091007Joint · corrodedDURING HEAVY CHECK, AFT GALLEY SPLIT JOINTS CORRODED AND NEEDS REPLACED. MAINTENANCE R & R CORRODED SPLIT JOINT BRACKET AND SPLIT JOINT TRIM ON BOTH HALVES ON AFT GALLEY IAW AMM 20-10-01, 25-00-23, PN CDS82200-11, SPLIT JOINT BRACKET. ACFT REMAINS, UNTIL HEASDR R61A201310101001Rib · crackedDURING HEAVY CHECK, RT HORIZONTAL L/E RIB 4 CRACKED AND TOOL DAMAGE ON 2 OTHER RIBS. MANTENANCE CUT OUT DAMAGE AT RIB 4 AND INSTALLED RIB REPAIR ANGLE AND FILLER IAW ETD 2013-170-048576.SDR R61A201310091006Nut · corrodedDURING HEAVY CHECK, AFT PASSENGER DOOR AFT LOWER DOOR STOP NUT CORRODED. MX REMOVED AND REPLACED STOP SCREW AND NUT IAW AMM 52-12-2-3. NAS5509-7 NUT. ACFT REMAINS UNTIL COMPLETION OF HEAVY CHECK.SDR R61A201310091002Bracket · crackedDURING HEAVY CHECK, LT PACK DUCT BRACKET CRACKED IN SEVERAL PLACES FWD OF LT PACK ASSY. MAINTENANCE R & R NR 2 PACK DUCT BRACKETS IAW SRM 51-40-01. PN 170-92988-401 BRACKET. ACFT REMAINS FOR COMPLETION.SDR R61A201309150876Deflector · wornCREW REPORTED THAT THE L1 DOOR WAS MAKING A LOUD VIBRATION & HUMMING NOISE IN FLIGHT. AN EMERGENCY WAS NOT DECLARED AND CREW LANDED WITHOUT INCIDENT. MX FOUND THE L1 DOOR DEFLECTOR WORN. MX REMOVED DOOR DEFLECTOR AND PLACED ON CDL IAW AMM. ACFT IS GOOD FOR SDR R61A201306250559Battery Pack · dischargedCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT IS DIM. MX REPLACED F/A FLASHLIGHT BATTERY PACK IAW AMM AND OPS CHECKED GOOD.SDR R61A201306250558Battery Pack · dischargedCREW REPORTED THAT THE CAPTAINS FLASHLIGHT IS DIM. MX REPLACED FLASHLIGHT BATTERY PACK IAW AMM AND OPS CHECKED GOOD.SDR R61A201305100456Mask · brokenCREW REPORTED THAT THE FLIGHT ATTENDANT OXYGEN DEMO MASK WAS IN NEED OF REPAIR OR REPLACEMENT. MAINTENANCE REMOVED AND REPLACED O2 DEMO MASK PER EMB AMM AND OPS CHECKED GOOD.SDR R61A201302180171Mask · brokenCREW DISCOVERED AFT FLIGHT ATTENDANTS MASK NEEDED TO BE REPLACED. MAINTENANCE REMOVED AND REPLACED DEMO MASK PER EMB AMM. OPS CHECKED GOOD.SDR R61A201211230698Sensor · damagedCREW REPORTED SUFFERING A LARGE BIRD STRIKE DURING INITIAL CLIMBOUT FROM EYW. CREW REPORTS SLAT FAIL INDICATION ON EICAS, CREW DECLARED EMERGENCY AND LANDED WITHOUT INCIDENT AT RSW.SDR R61A201204300258Servo · faultyCREW REPORTED VIBRATION IN FLIGHT DURING CRUISE. CREW DECLARED AN EMERGENCY AND DIVERTED TO CMH. AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE TROUBLESHOT PER EMB AMM, AND FOUND A/P ELEVATOR SERVO TO BE THE CAUSE. MAINTENANCE REMOVED AND REPLACED A/P ELEV SDR R61A201202160099Liner · out of positionCREW REPORTED R-1 DOOR ARMING LEVER WAS HARD TO OPERATE. MAINTENANCE RE-POSITIONED R-1 DOOR LINING AND PERFORMED OPS CHECKS PER EMB AMM, OPS CHECK GOOD.SDR R61A20120063Fastener · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE RT ENGINE PYLON PANEL 429DT HARDWARE. MAINTENANCE REMOVED AND REPLACED THE HARDWARE ON THE RT ENGINE PYLON PANEL 429DT IAW EMB 170/175 AMM 20-10-07. REF: P/N'S PE21114-3C8 BOLT & PE211SDR R61A20120056Latch · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND FWD CARGO DOOR LATCH ASSY CORRODED. MX REMOVED AND REPLACED FWD CARGO DOOR LOCK CABLE LATCH ASSY IAW EMB 175 AMM 52-31-08, AMD AMM 20-10-02. P/N 170-84599-405. A/C REMAINS IN CMH FOR HEAVY CHECK COMPLETION.SDR R61A20120057Pin · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND AFT CARGO DOOR FWD AND AFT HINGE ARM PIVOT PINS CORRODED. P/N 170-69804-005 MX REMOVED AND REPLACED PINS IAW EMB 175 AMM 52-32-24. A/C REMAINS IN CMH FOR HEAVY CHECK COMPLETION.SDR R61A20120055Door · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND FWD HALF AFT GALLEY ENTIRE METAL STRIPS IN BETWEEN MID SECTION, EVIDENCE OF CORROSION FOUND. MX REMOVED AND REPLACED AFT GALLEY METAL TRIM PIECES IAW EMB 175 AMM 25-00-23, REPLACED SPRINGS FOR TRASH DOOR THAT WAS DAMAGEDSDR R61A20120054Trim Panel · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND AFT HALF AFT GALLEY ENTIRE FRONT STRIPS SHOW EVIDENCE OF CORROSION. P/N 170-59522-001 MX REMOVED AND REPLACED AFT GALLEY FRONT STRIPS IAW EMB 175 25-00-23. CLEANED AREA IAW 51-12-00. A/C REMAINS IN CMH FOR HEAVY CHECK SDR R61A20120053Trim Panel · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND AFT HALF AFT GALLEY ENTIRE METAL STRIPS IN BETWEEN MID SECTION SHOW EVIDENCE OF CORROSION. MX REMOVED AND REPLACED METAL STRIP ON AFT GALLEY IAW EMB 175 AMM 25-00-23, AND REMOVED CORROSION IAW EMB 175 SRM 51-12-01. P/N SDR R61A20120052Tube · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND LT ENGINE FIRE EXT DISCHARGER TUBE HAS LIGHT SURFACE CORROSION IN INBOARD FLAP WELL ABOVE AFT PYLON AND INSIDE PNL 522CB. MX REMOVED AND REPLACED LT ENGINE FIRE EXT DISCHARGER TUBE INSIDE PNL 522CB IAW EMB 175 AMM 20-10SDR R61A20120046Gusset · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND CORROSION ON RIGHT BRACKET AT FRAME 90. MAINTENANCE REMOVED AND REPLACED GUSSET IAW EMB 175 SRM 51-41-02. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A20120045Sill · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND AFT CARGO CUTOUT LOWER SILL CORRODED IN SEVERAL PLACES. MX REMOVED AND REPLACED AFT CARGO LOWER SILL IAW EMB 170/175 SRM 54-40-02, 51-41-01. P/N 170-85251-401. A/C REMAINS IN CMH FOR HEAVY CHECK COMPLETION.SDR R61A20120043Seat Track · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND FORWARD FUSELAGE SEAT TRACK BEAM LT AT FR 19 HAS CORROSION. MX REMOVED AND REPLACED LT FWD FUSELAGE SEAT TRACK IAW EMB 175 SRM 51-40-00, 51-40-02. PN 170-03264-001. A/C REMAINS IN CMH FOR HEAVY CHECK COMPLETION.SDR R61A20120044Fastener · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND FWD PAX DOOR EMERGENCY SLIDE FITTING ON BOTTOM OF DOOR, HARDWARE CORRODED. MX REMOVED AND REPLACED FWD PAX DOOR EMERGENCY SLIDE FITTING HARDWARE ON BOTTOM OF DOOR IAW EMB 175 AMM 52-11-40. P/N MS14144-4, NAS6604D11, MS2SDR R61A20120039Dampener · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE L1 DOOR DAMPNER CORRODED. MAINTENANCE REMOVED AND REPLACED THE L1 DOOR DAMPNER IAW EMB 175 AMM 52-11-27. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A20120058Clamp · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND BRAIDED CONDUIT AND ADEL CLAMPS ON WIRE HARNESS INSIDE INBOARD FLAP WELL HAS SURFACE CORROSION ABOVE AFT PYLON. MX CLEANED BRAIDED CONDUIT AND REPLACED ADEL CLAMP ON BRAIDED HARNESS INSIDE INBOARD FLAP WELL ABOVE AFT PYLSDR R61A20120038Seat Track · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE FORWARD FUSELAGE SEAT TRACK BEAM AT RIGHT FRAME 17 CORRODED. MAINTENANCE REMOVED AND REPLACED RT FORWARD FUSELAGE SEAT TRACK AT FRAME 17 IAW EMB 175 SRM 51-40-02, 51-41-00, 51-43-01, AND 51-43-02. THE ASDR R61A20100466Structure · dentedDENT IN FWD FUSELAGE REQUIRES MAJOR REPAIR. MTX C/W MAJOR REPAIR PER EMB ETD 2010-170-09029.SDR R61A20090035Sensor · failedCREW REPORTED SLAT FAIL DURING SLAT EXTENSION WHILE ON FINAL. CREW DECLARED EMERGENCY AND LANDED WITHOUT INCIDENT INTO PIT. MAINTENANCE WAS DISPATCHED TO THE A/C TO TROUBLESHOOT. MAINTENANCE FOUND BOTH LT O/B SKEW SENSORS TO BE AT FAULT, AND REMOVED AND REP
Back to N119HQ