Embraer ERJ 170-100SU
Service difficulty reports · 2,953
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = 'ERJ170100SU' 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 aircraft_model_key = 'ERJ170100SU' 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 R61A20070009Power Supply · inoperativeCREW REPORTED WHILE SETTING UP FOR APPROACH HAD MAU 1B FAIL ALONG WITH A SPOILER FAULT. CREW DECLARED AN EMERGENCY FOLLOWED QRH PROCEDURES LANDED WITHOUT INCIDENCE. MAINTENANCE WAS DISPATCHED TO A/C TROUBLESHOT AND FOUND MAU 1 POWER SUPPLY INOPERATIVE. REMOSDR R61A20070007Sensor · faultyPILOT REPORTED SLAT FAIL MESSAGE ON EICAS DURING APPROACH, DECLARED EMERGENCY FOLLOWED QRH AND LANDED WITH OUT INCIDENT. MAINTENANCE WAS DISPATCHED TO A/C. TROUBLESHOT AND REMOVED AND REPLACED RIGHT HAND OUTBOURD SKEW SENSOR AND HARNESS. OPERATIONAL CHECK GSDR R61A20070008Sensor · faultyPILOT REPORTED SLAT FAIL MESSAGE ON EICAS DURING APPROACH, DECLARED EMERGENCY FOLLOWED QRH AND LANDED WITHOUT INCIDENT. MAINTENANCE WAS DISPATCHED TO A/C. TROUBLESHOT AND REMOVED AND REPLACED RIGHT HAND OUTBOURD SKEW SENSOR AND HARNESS. OPERATIONAL CHECK GO
Back to Embraer ERJ 170-100SU