N109HQ
Service difficulty reports · 73
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 = 'N109HQ' 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 = 'N109HQ' 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 R61A201502020073Skin · canningDURING HEAVY CHECK FWD SKIN AREA FROM FRAME 1-7 REQUIRES REPLACEMENT DUE TO OIL CANNING. MAINTENANCE R & R SKIN AREA FROM FRAME 1-7 IAW SRM 51-41-02, SKIN PN 170-03922-001.SDR R61A201502010074Rudder · damagedRUDDER DAMAGED. MAINTENANCE R & R RUDDER IAW AMM 27-21-05.SDR R61A201410111106Actuator · malfunctionedCREW LOWERED GEAR AND RECEIVED MESSAGES INDICATING HYD 2 FAILURE. GEAR EXTENDED NORMALLY, HOWEVER HYD SYS INDICATED TOTAL LOSS OF FLUID IN NR 2 SYSTEM. CREW WENT AROUND TO RUN CHECKLISTS AND DECLARED AN EMERGENCY. WITH EMERGENCY VEHICLES ROLLING AND PASSENGESDR R61A201408231008Battery Pack · weakCREW REPORTED THAT THE FORWARD F/A FLASHLIGHT WAS VERY WEAK. MAINTENANCE R & R FORWARD F/A FLASHLIGHT BATTERY IAW AMM AND OPS CHECKED GOOD.SDR R61A201312231345Cable · deterioratedDURING PREFLIGHT, THE R1 SERVICE DOOR WAS FOUND TO BE DIFFICULT TO ARM AND DISARM. REMOVED AND REPLACED R1 SLIDE ARMING FLEX CABLE IAW AMM 52-41-40. OPS CHECKED GOOD.SDR R61A201309140871Bottle · dischargedCREW REPORTED THAT THE L1 DOOR WAS NOT CLOSING ALL THE WAY. MX FOUND THE L1 DOOR ASSIST BOTTLE DISCHARGED AND THE GIRT BAR WAS ENGAGED WITH THE HANDLE IN THE OPEN POSITION. MX WAS ABLE TO GET THE DOOR CLOSED BUT DID NOT HAVE ENOUGH NITROGEN TO SERVICE THE DOSDR R61A201307020568Glowstrip · detachedCREW REPORTED THAT THE PHOTO LUMINESCENT STRIP BETWEEN ROWS 13 AND 16 ON THE RT SIDE OF THE ACFT WAS NOT ATTACHED. ATTACHED STRIP IAW AMM AND OPS CHECKED GOOD.SDR R61A201306120534Bulb · looseCREW REPORTED THAT THE AFT FLASHLIGHT INOPERATIVE. MX FOUND THE BULB VERY LOOSE. ADJUSTED IAW AMM AND OPS CHECKED GOOD.SDR R61A201306050511Warning System · false activationCREW REPORTED STEER FAIL EICAS MESSAGE ON GEAR EXTENSION. CREW ALERTED TOWER, TOWER DECLARED AN EMERGENCY, FLIGHT LANDED SAFELY AND WAS TOWED TO GATE. MX PERFORMED FIM TASK 45-45-00-810-973-A00, IAW AMM, THE FAULT CLEARED AND WAS FOUND TO BE A TRANSITORY FAUSDR R61A201305190470Indicator · unsecureCREW REPORTED THAT THE R2 DOOR DISARM INDICATOR WAS NOT SHOWING GREEN. MAINTENANCE SECURED R2 DOOR LATCH INDICATOR PER EMB AMM AND OPS CHECKED GOOD.SDR R61A201305030443Rib · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND RIB 52 CRACKED AT PREVIOUS REPAIR. MAINTENANCE REMOVED AND REPLACED THE RIB 52 PANEL IAW EMB 170 SRM 51-40-02, AND 51-41-01. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR R61A201304270453Glowstrip · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND PHOTO LUMINESCENT LIGHT STRIP CABIN CENTER AISLE CRACKED AND DIRTY. MAINTENANCE REMOVED AND REPLACED THE PHOTO LUMINESCENT LIGHT STRIP CABIN CENTER AISLE IAW EMB 175 AMM 33-50-21. THE AIRCRAFT WAS RETURNED SDR R61A201304270452Glowstrip · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE PHOTO LUMINESCENT LIGHT STRIP CABIN CENTER AISLE CRACKED AND DIRTY. MAINTENANCE REMOVED AND REPLACED 3EA PHOTO LUMINESCENT LIGHT STRIP CABIN CENTER AISLE IAW EMB 175 AMM 33-50-21. THE AIRCRAFT WAS RETURSDR R61A201304270451Glowstrip · crackedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE PHOTO LUMINESCENT STRIP LIGHT CABIN CENTER AISLE CRACKED AND DIRTY. MAINTENANCE REPLACED 4EA PHOTO LUMINESCENT STRIP LIGHT CABIN CENTER AISLE IAW EMB 175 AMM 33-50-21. THE AIRCRAFT WAS RETURNED TO SERVISDR R61A20130128075Flashlight · brokenAFT FLIGHT ATTENDANT FLASHLIGHT WOULD NOT HOLD A CHARGE. MAINTENANCE REMOVED AND REPLACED FLASHLIGHT PER EMB AMM.SDR R61A201301130059Control Handle · inoperativeCREW REPORTED LANDING GEAR WOULD NOT COME UP, LANDING GEAR HANDLE WOULD NOT MOVE. CREW DECLARED EMERGENCY. MAINTENANCE TROUBLESHOT AND REMOVED AND REPLACED LANDING GEAR HANDLE PER EMB AMM.SDR R61A201205250297Panel · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND SHEAR PANEL CORRODED BETWEEN FRAMES 87 AND 88. MAINTENANCE REMOVED AND REPLACED SHEAR PANEL BETWEEN FRAMES 87AND 88 IAW EMB175 SRM 51-40-02, 51-42-01, 51-42-02, AND 51-43-01. THE AIRCRAFT IS OUT OF SERVICE SDR R61A20110281Oxygen Mask · out of positionCREW REPORTED FWD FA OXYGEN MASK DEPLOYED. MAINTENANCE RE-PACKED FWD FA GALLEY MASK PER EMB AMM, NO DEFECTS NOTED.SDR R61A20110280Oxygen Mask · out of positionCREW REPORTED FWD F/A OXYGEN MASK DROPPED. MAINTENANCE RE-STOWED FWD GALLEY O2 MASK PER EMB AMM.SDR R61A20110190Flange · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE REPORTED POTABLE WATER TANK FILL BOX FLANGE HAS CORROSION. MAINTENANCE REMOVED AND REPLACED WATER TANK FILL BOX FLANGE IAW EMB SRM 51-43-02. THE AIRCRAFT WAS RETURNED TO SERVICE 7-23-11.SDR R61A20110035A/C Pack · malfunctionedCREW REPORTED PACK 2 FAIL WHILE ON THE GROUND ALONG WITH BURNING SMELL IN THE COCKPIT AND CABIN AFTER PUSHBACK. EMERGENCY VEHICLES DID RESPOND, AND REPORTED NO ABNORMALITIES WERE NOTED OUTSIDE OF THE AIRCRAFT. MAINTENANCE TROUBLESHOT PER EMB AMM AND PLACED PSDR R61A20100092Hose · leakingFLIGHT CREW RECEIVED A WING ANTI-ICE MESSAGE WHILE IN DESCENT, THEN DECLARED EMERGENCY INTO PHL. AC LANDED SAFELY, NO INCIDENT. MAINTENANCE WAS CALLED OUT TO AC TO TROUBLESHOOT ISSUE. MAINTENANCE FOUND A BAD SLAT TO SLAT CONNECTION HOSE ON RT SLATS 2 AND 3,SDR R61A200800003Warning System · malfunctionedCREW REPORTED ON CLIMBOUT HAD THE FOLLOWING EICAS MESSAGES, ADSP1 FAIL TAT1 FAIL, AOA LIMIT FAIL GROUND SPOILER FAIL AND ENGINE 2 NI AN ITT INDICATIONS FLASHING ALONG WITH THE CAPTAIN’S PFD WAS FLASHING. CREW DECLARED AN EMERGENCY AND DIVERTED TO WINDSOR LOCK
Back to N109HQ