N590AA
Service difficulty reports · 109
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 = 'N590AA' 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 = 'N590AA' 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 AALA20020359Seat Track · corrodedTUL - FOUND CORROSION SEAT TRACK NR 1 FS 1208-1209. CUT OUT DAMAGED AREA AND INSTALLED PLUG PER AARD-53-70-00-10. (M)SDR AALA20010293Connector · disconnectedDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT SEAT 7D INOPERATIVE. RE-CONNECTED EMERGENCY EXIT LIGHT CONNECTOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20010291Connector · disconnectedDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT SEAT 7D INOPERATIVE. RE-CONNECTED EMERGENCY EXIT LIGHT CONNECTOR AT SEAT 7D. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20000662Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, TAIL COMPARTMENT EMERGENCY ESCAPE LIGHT INOPERATIVE. REPAIRED OPEN CONTACT ON LIGHT ASSEMBLY. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)SDR AALA991367Engine · defectiveSJC - FLT 0740 - ON TAKEOFF SJC/DFW, BOTH LEFT AND RIGHT AIR CONDITIONING SUPPLY HIGH TEMPERATURE LIGHTS ILLUMINATED. HIGH PRESSURE BLEED AIR SUPPLY WAS SHUT OFF AND LIGHTS EXTINGUISHED. STRONG FUEL ODOR DETECTED IN CABIN. AIRCRAFT RETURNED TO SJC AND LANDESDR AALA981708Web · corrodedTUL - FOUND CUSP SECTION FROM RT STATION 598 TO STATION 712 RT, REQUIRES REPLACEMENT DUE TO SEVERAL AREAS OF CORROSION THAT WENT BEYOND LIMITS. REPLACED CUSP SECTION FROM STATION 598 TO STATION 712 PER AARD 53-20-00-16. (M)SDR AALA981709Track · corrodedTUL - FOUND CORROSION IN RT TIE DOWN TRACK AT FASTENERS THAT ATTACH TRACK TO FRAMES. REPLACED TIE DOWN TRACK. (M)SDR AALA980135Light · inoperativeDFW - DURING OVERNIGHT CHECK, DISCOVERED FIRST CLASS EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LIGHT STRIP AT FIRST CLASS EMERGENCY EXIT. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)SDR AALA961223Connector · misinstalledSFO - DURING OVERNIGHT MAINTENANCE, FOUND THE EMERGENCY EXIT FLOOR PATH LIGHTS AT SEAT 22F, LOWER, AND AFT SERVICE DOOR INOPERATIVE. REVERSED POLARITY ON CONNECTOR AT ROW 21. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N590AA