N612AE
Service difficulty reports · 208
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 = 'N612AE' 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 = 'N612AE' 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 SIMA200212111Sill · corrodedABI - THIS IS A LEVEL 2 FINDING. LEFT SILL BETWEEN 18 AND 21 CORRODED. INSTALLED NEW SILL IAW EMB 145 SRM 51-40-02, 51-40-06, 51-20-02. M)SDR SIMA200127807Power Supply · dischargedORD - FLT 4370 - CREW REPORTED THAT DURING POST FLIGHT CHECK, THE EMERGENCY LIGHTS ON INSIDE OF SERVICE DOOR WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE NR 2 BATTERY POWER SUPPLY AND BATTERY CHARGER. OPERATIONAL CHECK WAS GOOD AND AIRCSDR SIMA200114703Control Unit · inoperativeDFW - FLT 3331 - CREW REPORTED THE NR 1 PITCH TRIM INOPERATIVE MESSAGE ON EICAS. MAINTENANCE REMOVED AND REPLACED THE HORIZONTAL STABILIZER CONTROL UNIT IAW EMB MM. OPS CHECK WAS GOOD AND AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA0185Control Unit · failedMSN - FLT 3431 - CREW REPORTED PITCH TRIM NR 1 FAIL DURING APPROACH. MAINTENANCE REMOVED AND REPLACED HSCU IAW EMB MM. OPERATIONAL CHECK WAS GOOD AND AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA2523Warning Light · illuminatedMAF - FLT 3824 - CREW SERVICE DOOR WARNING MESSAGE ON EICAS. CREW RETURNED TO MAF AND LANDED WITHOUT INCIDENT. PUT ON MEL AT THIS TIME. MAINTENANCE PERFORMED OPERATIONAL CHECK OF SERVICE DOOR WARNING SYSTEM IAW EMB MM. COLD NOT DUPLICATE DISCREPANCY. AIRCSDR SIMA2182Light · inoperativeDFW - FLT 3526 - LEFT AFT WING EXIT EMERGENCY EXIT LIGHT INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EMERGENCY LIGHT ASSEMBLY FOR LEFT AFT WING EXIT. OPERATIONAL CHECK WAS GOOD AND AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR SIMA993451Module · failedDFW - FLT 3664 - FLIGHT ATTENDANT EMERGENCY LIGHT SWITCH DOES NOT FUNCTION. REMOVED AND REPLACED CONTROL MODULE ASSEMBLY. OPERATIONAL CHECK GOOD. AIRCRAFT RETURNED TO SERVICE. (M)SDR SIMA991613Light · inoperativeORD - FLT 4201 - RIGHT WING EXTERIOR EMERGENCY LIGHT DOES NOT ILLUMINATE. REMOVED AND REPLACED RIGHT WING EXXTERIOR EMERGENCY LIGHT ASSEMBLY. OPERATIONAL CHECK GOOD. (X)
Back to N612AE