N539EA
Service difficulty reports · 103
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 = 'N539EA' 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 = 'N539EA' 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 SIMA20120820003Pcu · failedFLIGHT 3729, CREW REPORTED THAT WHILE EXPEDITING A DESCENT WITH FLIGHT SPOILER DEPLOYED, RECEIVED AN EICAS CAUTION FOR MESSAGE INBOARD FLT SPOILERS AND INBOARD SPOILERONS AT 2700 FT PER MIN. MESSAGE STAYED ON. THRUST LEVERS AT FLIGHT IDLE WHEN THE MESSAGE ASDR SIMA20120414004Sign · inoperativeFLIGHT 3730, FLIGHT ATTENDANT REPORTED THE SERVICE DOOR EMERGENCY EXIT SIGN WAS INOPERATIVE. AIRCRAFT REMOVED FROM SERVICE. SECURED EMERGENCY EXIT SIGN IAW EECSPM 20.33-00. OPS CHECKED GOOD. NO OTHER DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE.SDR SIMA201123405Fitting · looseON FLIGHT 3836 THE CREW REPORTED THAT AFTER ROTATION, AN "EDP1A" CAUTION MESSAGE APPEARED HYDRAULIC SYSTEM 1 SHOWS A QUANTITY OF 0%. NOTE: LEFT ENGINE LEAKING HYDRAULIC FLUID. THE CREW ELECTED TO RETURN TO ORD. THE AIRCRAFT LANDED WITHOUT INCIDENT. THE AIR
Back to N539EA