N904AN
Service difficulty reports · 263
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 = 'N904AN' 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 = 'N904AN' 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 AALA200810156Skin · dentedDENT AND CREASE IN FUSELAGE SKIN AT STATION 500B+13 BETWEEN STRINGER 18L AND 19L. INSTALLED REPAIR PER SRM 53-00-01-2 REPAIR NR 3.SDR AALA200810155Floor Support · corrodedCORROSION ON CABIN FLOOR SUPPORT AROUND NUTPLATE HOLES AT STATION 312 TO 328 RBL 10. INSTALLED NEW FLOOR SUPPORT.SDR AALA200810153Intercostal · crackedTUL - ATTACH FASTENER HOLES AT RIGHT BUTTLINE 30 BETWEEN STATIONS 312 AND 328 HAS ONE HALF INCH CRACK. AREA OF DISCREPANCY IS ONE HALF INCH BY ONE HALF INCH. REPLACED INTERCOSTAL PER SRM 51 10 02 0G.SDR AALA200810160Intercostal · crackedINTERCOSTAL CRACKED AT NUTPLATE HOLE. REPLACED INTERCOSTAL PER SRM 51-10-02-0.SDR AALA200802016Shroud · brokenDFW EMERGENCY LIGHT SHROUD AT SEAT ROW 17DEF BROKEN. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 17DEF. SYSTEM GROUND CHECKED NORMAL OPS. (CLOSED)SDR AALA200802017Shroud · brokenDFW EMERGENCY LIGHT SHROUD AT SEAT ROW 14DEF BROKEN. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT ROW 14DEF. SYSTEM GROUND CHECKED NORMAL OPS. (CLOSED)SDR AALA200802018First Aid Kit · damagedDFW FIRST AID KIT AT FIRST CLASS CABIN OPEN. REPLACED FIRST AID KIT AT FIRST CLASS CABIN. SYSTEM GROUND CHECKED NORMAL OPS. (CLOSED)SDR AALA200801420Electronic Unit · faultedDFW - CREW REPORTED FLAPS STUCK AT 15 DEGREES DURING APPROACH. LANDED DFW WITHOUT INCIDENT. REPLACED FLAP SLAT ELECTRICAL UNIT. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200800334Battery Pack · inoperativeTUL - EMERGENCY LIGHTS AT FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070268Wire Harness · inoperativeMIA - FOUND EMERGENCY LIGHT AT SEAT 3E INOPERATIVE. REPAIRED SEAT HARNESS FOR INOPERATIVE EMERGENCY LIGHT AT SEAT 3E. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070269Connector · disconnectedMIA - EMERGENCY LIGHT AT SEAT 9D INOPERATIVE. RECONNECTED CONNECTOR FOR EMERGENCY LIGHT AT SEAT 9D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061322Transmitter · inoperativeYYZ - FLAPS FAILED TO EXTEND ON APPROACH. EMERGENCY DECLARED AND LANDED WITHOUT INCIDENT. REPLACED RIGHT FLAP POSITION TRANSMITTER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060839Battery Pack · inoperativeTUL - BATTERY PACKS FOR EMERGENCY LIGHTS IN CABIN INOPERATIVE. REPLACED BATTERY PACKS FOR EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N904AN