N989AU
Service difficulty reports · 57
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 = 'N989AU' 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 = 'N989AU' 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 AALA201710269018Bottle · low pressureDURING CHECK, FOUND THE L1 DOOR ASSIST BOTTLE LOW. SERVICED THE BOTTLE IAW AMM 52-10-00.SDR AALA20171025001Bottle · low pressureAIRCRAFT WAS NOT GROUNDED. ON CHECK, FOUND L1 DOOR ASSIST BOTTLE LOW. SERVICED DOOR TO PROPER LIMIT PER AMM 52-10-00.SDR AALA20170814006Cylinder · low pressureR4 EMERGENCY DOOR DAMPER CYLINDER PRESSURE READS LOW. SERVICED CYLINDER IAW AMM 52-10-00. OPERATIONAL CHECK GOOD.SDR AALA201707259008Feeder Cable · damagedROWS 35 AND 36 SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. INSTALLED A NEW POWER CABLE HARNESS ASSEMBLY IAW AIPC 33-51-09-37K. ACCOMPLISHED SATISFACTORY LIGHT TEST IAW AMM 33-51-00.SDR AALA201706219003Fan · failedFORWARD GALLEY LEFT OVEN PERODICALLY MAKES VERY LOUD NOISE WHEN THE FAN RUNNING AND THE FAN SPARKS AND SMOKES IN THE AREA BEHIND THE FAN SHROUD ON THE INSIDE OF THE OVEN. MAINTENANCE REPLACED THE OVEN IAW MM 25-35-19-401.SDR AALA201705119004Mechanism · obstructedPRIOR TO PUSH BACK THE 1R DOOR ARMING LEVER WOULD NOT SECURE PROPERLY. AIRCRAFT WAS GROUNDED. MAINTENANCE FOUND DEBRIS ON RIGHT DOOR ARMING AT FLOOR. REMOVED DEBRIS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170221013Battery · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT AT 13WL FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38 AND CARD 2735. OPERATIONAL CHECK GOOD.
Back to N989AU