N863AA, cancelled Mar 13, 2003
Service difficulty reports · 53
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 = 'N863AA' AND deregistration_id = 'N863AA-2003-03-13' 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 = 'N863AA' AND deregistration_id = 'N863AA-2003-03-13' 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 AALA961670Anti-Ice Duct · defectiveMIA - FLT 706 - AFTER TAKEOFF STX, NR 2 ENGINE FIRE WARNING CIRCUIT BREAKER POPPED. RESET CIRCUIT BREAKER AND IT POPPED AGAIN. AIRCRAFT PROCEEDED TO MIA AND LANDED WITHOUT INCIDENT. REPLACED NR 2 ENGINE 6TH STAGE ANTI-ICE DUCT AND ACCOMPLISHED REPAIRS TO NRSDR AALA960208Stringer · corrodedTULE - FOUND CORROSION ON STRINGER 27R, AFT OF STATION 560. CUT OUT CORRODED AREA, INSTALLED REPAIR PER SRM 53-10-3, FIG 1. (M)SDR AALA950960Eel · defectiveDFW - DURING OVERNIGHT CHECK, LEFT AFT GALLEY DOOR OVERHEAD EMERGENCY LIGHT INOPERATIVE. REPLACED LEFT AFT GALLEY DOOR OVERHEAD EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N863AA, cancelled Mar 13, 2003