N821AN
Service difficulty reports · 64
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 = 'N821AN' 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 = 'N821AN' 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 AALA201712089026Light · damagedAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT SEAT 14H RIGHT HAND AISLE DAMAGED. INSTALLED EMERGENCY EXIT LIGHT SEAT 14H RIGHT HAND AISLE PER ESO 41072.SDR AALA201708169030Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED. SMOKE DETECTOR IN LAVATORY 3R HAD A FALSE INDICATOR LIGHT AND EICAS MESSAGE. ACCOMPLISHED INSPECTION OF FIRE EXTINGUISHER PER AMM 26-24-01, TEMPERATURE INDICATOR STRIP PER AMM 26-24-02, AND LAVATORY SMOKE DETECTOR OPERATIONAL CHECKSDR AALA201706299004Controller · inoperativeR3 DOOR MOUNTED ELECTRICAL DIMMABLE WINDOW CONTROLLER IS INOPERATIVE. ACCOMPLISHED RESET IAW DMC-B787-A-56-20-F1-58A-421A-A. OPERATIONAL CHECKED GOOD.SDR AALA201706159032Controller · inoperativeL1 AND R1 DOOR MOUNTED ELECTRICALLY DIMMABLE WINDOW CONTROLLERS ARE INOPERATIVE. ACCOMPLISHED A RESET IAW AMM DMC-B787-A-56-21-03. OPS CHECKED GOOD.SDR AALA20170529017Drive Unit · failedEMERGENCY DECLARED. FLIGHT RETURNED TO DEPARTURE DUE TO THE WEATHER RADAR FAILED. LANDING UNEVENTFUL. REMOVED AND REPLACED WEATHER RADAR ANTENNA DRIVE UNIT IAW DMC-B787-A-34-42-03-00A. OPERATIONAL CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA201705169073Controller · inoperativeL1 DOOR MOUNTED ELECTRICALLY DIMMABLE WINDOW CONTROLLER IS INOPERATIVE. ACCOMPLISHED RESET IAW FIM 56-20-F1-58A. OPERATIONAL CHECKED GOOD.SDR AALA201705129032Controller · inoperativeL4 DOOR MOUNTED ELECTRICALLY DIMMABLE WINDOW CONTROLLER IS INOPERATIVE. ACCOMPLISHED RESET IAW FIM 56-20-F1-58A. OPS CHECKED GOOD.SDR AALA201705129028Controller · inoperativeR4 DOOR MOUNTED ELECTRICALLY DIMMABLE WINDOW CONTROLLER IS INOPERATIVE. ACCOMPLISHED RESET IAW FIM 56-20-F1-58A. OPERATIONAL CHECKED GOOD.SDR AALA201705119005Control Unit · faultedACFT HEALTH MONITORING ALERTS RECEIVED FOR THE WIRELESS EMERGENCY LIGHTING SYSTEM. REMOVED AND REPLACED THE CONTROL UNIT AT THE L4 DOOR IAW B7 87-A-33-51-07-00A. OPS CHECKED GOOD.SDR AALA201704289028Actuator · faultedON ARRIVAL, EICAS MESSAGE RECEIVED NOTING NUMBER 3 ELECTRIC BRAKE ACTUATOR ON THE NUMBER 1 BRAKE IS INOPERATIVE. REMOVED AND REPLACED WHEEL 1, NUMBER 3 ELECTRIC BRAKE ACTUATOR IAW AMM 32-45-08. OPS CHECKED GOOD.SDR AALA201704289027Actuator · faultedON ARRIVAL, EICAS MESSAGE RECEIVED NOTING NUMBER 2 ELECTRIC BRAKE ACTUATOR ON THE NUMBER 6 BRAKE IS INOPERATIVE. REMOVED AND REPLACED WHEEL 6 NUMBER 2 ELECTRIC BRAKE ACTUATOR IAWAMM 32-45-08. OPS CHECKED GOOD.SDR AALA20170213006Flashlight · inoperativeFLIGHT ATTENDANT EMERGENCY FLASHLIGHT UNDER FORWARD JUMPSEAT BESIDE L2 DOOR IS INOPERATIVE. REMOVED AND REPLACED THE FLASHLIGHT. OPS CHECKED GOOD.SDR AALA20161107003Sensor · faultySLAT DRIVE FAILURE BETWEEN FLAPS 1-5 WITH EICAS. EMERGENCY DECLARED. LANDING UNEVENTFUL. REMOVED AND REPLACED THE NR 7 OUTBOARD SKEW SENSOR IAW AMM B787-A-27-89-01. AIRCRAFT WAS GROUNDED.SDR AALA20161028013Sensor · faultyDURING APPROACH, CREW RECEIVED EICAS SLAT DRIVE MESSAGE PRIOR TO ANY FLAP/SLAT SELECTION AND WERE UNABLE TO EXTEND SLATS OR FLAPS. EMERGENCY DECLARED. LAINDING UNEVENTFUL. AIRCRAFT WAS GROUNDED. REMOVED AND REPLACED THE NR 7 SLAT INBOARD SKEW SENSOR IAW 27-
Back to N821AN