N977UY
Service difficulty reports · 159
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 = 'N977UY' 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 = 'N977UY' 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 AALA201609269021Floorboard · damagedSOFT FLOORBOARD IN THE FORWARD ENTER WAY INTO THE CABIN. AIRCRAFT WAS GROUNDED. REPLACED FORWARD ENTRY WAY FLOORBOARD IAW TASK 53-12-12-0401.SDR AALA201609029004Lens · crackedAIRCRAFT WAS NOT GROUNDED: EMERGENCY SEAT LIGHT COVER LENS CRACKED AT SEAT 10C. R & R EMERGENCY SEAT LIGHT ASSY AT SEAT 10C IAW CMM 25-22-50. A SATISFACTORY OPS CHECK WAS ACCOMPLISHED.SDR AALA201606099008Warning System · false activationACFT WAS NOT GROUNDED, DURING TAKEOFF AN ECAM MESSAGE REFLECTING AUTOFLIGHT, AUTOTHRUST FAULTS APPEARED AND THE CREW ABORTED THE TAKEOFF AT APPROXIMATELY 80 KNOTS AND RETURNED TO THE GATE WITH NO ADDITIONAL INCIDENTS. MAINTENANCE WAS UNABLE TO DUPLICATE, NO PSDR AALA201602299007Floor Panel · delaminatedAIRCRAFT WAS NOT GNDED. FORWARD CARGO FLOOR PANEL 131AF DELAMINATED. REPLACED FLOOR PANEL 131AF IAW AMM 53-22-14.SDR AALA201602189005Arming Lever · looseAIRCRAFT WAS NOT GNDED. DISARMING LEVER AT 3R LOOSE. SECURE 3R DOOR ARMING LEVER.SDR AALA201601319005Fan · defectiveDIVERTED & ACFT WAS GNDED. VENT EXTRACT FAULT. RUMBLE & BURNT BEARING SMELL WAS NOTED DURING FLIGHT. CREW DECLARED AN EMER & DIVERTED WHERE THE ACFT LANDED WITHOUT FURTHER INCIDENT. REPLACED THE EXTRACT FAN & ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK ISDR AALA201601259008Lens · missingAIRCRAFT WAS NOT GNDED. EMER LIGHT LENS MISSING AT SEAT 3L. REPLACED EMER LIGHT AT SEAT 3L IAW AMM 33-51-00.SDR AALA201512179011Lever · looseFLIGHT ATTENDANTS REPORT, R3 DOOR ARMING LEVER IS LOOSE. SECURED LOOSE ARMING LEVER. OPERATIONAL CHECKED GOOD.SDR AALA201512059001Pump · failedAIRCRAFT WAS NOT GNDED. NR 1 FUEL PUMP RT WING FAULTED AFTER TAKEOFF. LOW PRESS INDICATED ON FUEL ECAM PAGE. REPLACED RT WING NR 1 FUEL PUMP. ACCOMPLISHED A SATISFACTORY LEAK & OPERATIONAL CHECK IAW AMM 28-21-51.
Back to N977UY