N110HQ
Service difficulty reports · 110
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 = 'N110HQ' 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 = 'N110HQ' 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 R61A20110329Fitting · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE FORWARD CARGO DOOR, ON THE INSIDE SURFACE OF THE LOWER FORWARD SEAL DEPRESSOR FITTING. MAINTENANCE REMOVED & REPLACED THE FORWARD CARGO DOOR SEAL REST IAW EMB 175 AMM 20-10-01 AND EMB 1SDR R61A20110328Plate · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE RT I/B GUSSET PLATE AT FR 90. MAINTENANCE REMOVED AND REPLACED THE RT I/B GUSSET PLATE AT FR 90 IAW EMB 175 SRM 51-41-02. AIRCRAFT IS STILL CURRENTLY OUT OF SERVICE FOR HEAVY CHECK COMSDR R61A20110327Plate · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE RT O/B GUSSET PLATE AT FR 90. MAINTENANCE REMOVED AND REPLACED THE RT O/B GUSSET PLATE AT FR 90 IAW EMB 175 SRM 51-41-02. AIRCRAFT IS STILL CURRENTLY OUT OF SERVICE FOR HEAVY CHECK COMSDR R61A20110326Shear Plate · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE RT SHEAR PLATE AT FR 88. MAINTENANCE REMOVED AND REPLACED THE RT SHEAR PLATE AT FR 88 IAW EMB 175 SRM 51-42-03, 51-43-03, 53-23-10, 51-31-00, 51-40-02 AND 51-42-01. REF PO 119412 FOR FSDR R61A20110325Panel · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK, LEVEL 2 CORROSION WAS FOUND ON THE CENTER SHEAR PANEL AT FR 88. MAINTENANCE REMOVED AND REPLACED THE CENTER SHEAR PANEL AT FR 88 IAW EMB 175 SRM 51-42-03, 51-43-03, 51-40-02 & 51-42-01. AIRCRAFT IS STILL CURRENTLY OUT OSDR R61A20110315Panel · out of adjustCREW REPORTED R-1 VENT FLAP WOULDN'T CLOSE PROPERLY. MAINTENANCE ADJUSTED INTERNAL PANELING PIECE, AND PERFORMED OPS CHECKS PER EMB AMM, OPS CHECK GOOD.SDR R61A20110116Sensor · failedCREW REPORTED FLAP FAIL MSG ON EICAS DURING CRUISE AND DESCENT, CREW DIDN'T DECLARE AN EMERGENCY BUT EMERGENCY EQUIPMENT WAS ROLLED AS PRECAUTION. A/C LANDED SAFELY AT CLT WITHOUT INCIDENT. MAINTENANCE TROUBLESHOT AND REMOVED AND REPLACED THE RT T3 AND T4 FLSDR R61A20100529Unknown · malfunctionedCREW REPORTED LANDING GEAR WOULDN'T RETRACT AFTER TAKEOFF FROM PHL, CREW DIDN'T DECLARE EMERGENCY BUT RTF AT PHL AND LANDED WITHOUT INCIDENT AND HAD EMERGENCY VEHICLES ON STANDBY. MAINTENANCE WAS DISPATCHED TO THE A/C TO TROUBLESHOOT. MAINTENANCE FOLLOWED EMSDR R61A20100412Bleed Air Sys · malfunctionedCREW REPORTED BLEED 2 OVERPRESSURE IN FLIGHT, DECLARED EMERGENCY AND RETURNED TO FIELD AT PIT, AND LANDED WITHOUT INCIDENT. MAINTENANCE PLACED BLEED NR 1 SYSTEM ON MEL 36-00-00-1 AND THE A/C WAS RETURNED TO SERVICE.SDR R61A20080047Skin · dentedDENT/GOUGE ON THE AFT FUSELAGE BY THE LAVATORY SERVICE PANEL. ACCOMPLISHED MAJOR REPAIR PER EMBRAER ENGINEERING INSTRUCTION.
Back to N110HQ