N719AN
Service difficulty reports · 112
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 = 'N719AN' 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 = 'N719AN' 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 AALA20150304010Lens · missingFIRST CLASS CABIN BULKHEAD DIVIDER EMER LIGHT COVER MISSING. REPLACED FIRST CLASS CABIN BULKHEAD DIVIDER EMER LIGHT LENS IAW AMM 25-63-02. SYS CHECKED NORMAL.SDR AALA20150209023Smoke Warning · false activationON PUSH BACK, STS MSG DETECTOR IFES SMOKE DISPLAYED ASSOCIATED WITH IFES SMOKE DETECTED & IFE LOSS OF COOLING WARNING LIGHTS ILLUMINATED AT PURSER STATION. INSPECTED ARE NO EVIDENCE OF SMOKE FOUND.SDR AALA20141025002Warning System · false activationINFLIGHT FUEL DISAGREE EICAS MSG DISPLAYED. CREW COMPLETED THE APPROPRIATE CHECKLIST & A FUEL LEAK WAS CONFIRMED WITH A 1000 POUND DIFFERENCE BETWEEN CALCULATED & TOTALIZER WITHIN 30 MINUTES. PERFORMED EXTERNAL FUEL LEAK CHECK, NO LEAKS NOTED. PERFORMED CHESDR AALA20141019006Entertain Sys · malfunctionedINFLIGHT ENTERTAINMENT SYS WOULD NOT BOOT UP & COOLING FAN INOPERATIVE LIGHT & SMOKE DETECTOR ILLUMINATED. NO SMOKE WAS NOTICED. TURNED OFF ENTIRE SYS FOR REMAINDER OF FLIGHT. FLIGHT LANDED WITHOUT INCIDENT. IFE COOLING CB & MAIN A/C POWER CYCLED. ELMS P1SDR AALA20140509009Lens · missingEMERGENCY LIGHT AT SEAT 14G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 14G. OPERATIONS CHECKED NORMAL.SDR AALA20140501006Lens · missingEMERGENCY PROXIMITY LIGHT ON DIVIDER BY LT NR 2 DOOR MISSING LENS. REPLACED LENS FOR EMERGENCY PROXIMITY LIGHT ON DIVIDER BY LT NR 2 DOOR, OPERATIONS CHECKED NORMAL.SDR AALA20140501005Lens · missingEMERGENCY PROXIMITY LIGHT ON DIVIDER BY RT NR 2 DOOR MISSING LENS. REPLACED LENS FOR EMERGENCY PROXIMITY LIGHT ON DIVIDER BY RT NR 2 DOOR, OPERATIONS CHECKED NORMAL.SDR AALA20140501004Lens · missingEMERGENCY PROXIMITY LIGHT ON DIVIDER BY SEAT 4J MISSING LENS. REPLACED LENS FOR EMERGENCY PROXIMITY LIGHT ON DIVIDER BY SEAT 4J, OPERATIONS CHECKED NORMAL.SDR AALA20140105003Light · inoperativeSEAT 8G FWD EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR SEAT 8G FWD EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140105002Light · inoperativeSEAT 13 D AFT EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR SEAT 13D AFT EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20131227001Lens · missingFLOOR PROXIMITY PATH LIGHT LENS MISSING AT SEAT 10G. REPLACED LENS FOR FLOOR PROXIMITY PATH LIGHT AT SEAT 10G. OPERATIONS CHECKED NORMAL.SDR AALA20130524013Shutoff Valve · failedCREW REPORTED LT HIGH PRESSURE SHUTOFF VALVE FAILED TO OPEN. EMERGENCY DECLARED, FLIGHT RETURNED, LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. REPLACED HPSOV. SYS GROUND CHECK NORMAL OPERATION.
Back to N719AN