N917AN
Service difficulty reports · 171
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 = 'N917AN' 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 = 'N917AN' 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 AALA2009012700382Connector · wornDFW - PATH LIGHT AT SEAT 27D INOPERATIVE. REPLACED CONNECTOR FOR PATH LIGHT AT SEAT 27D.SDR AALA2009012700381Connector · not seatedDFW - PATH LIGHT AT SEAT 24D INOPERATIVE. RESEATED CONNECTOR FOR PATH LIGHT AT SEAT 24D.SDR AALA2009012700380Pin · not seatedDFW - PATH LIGHT AT SEAT 23D INOPERATIVE. RESEATED PUSH BACK PIN FOR PATH LIGHT AT SEAT 23D.SDR AALA2009012700379Wire · wornDFW - PATH LIGHT AT SEAT 5E INOPERATIVE. REPAIRED WIRING AT SEAT 5E.SDR AALA200802355ASensor · failedIAD INFLIGHT - LEADING EDGE SLATS WOULD NOT EXTEND. LANDED AT IAD WITHOUT INCIDENT DUE TO LONGER RUNWAY. REPLACED NUMBER FOUR LEADING EDGE RETRACT SENSOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802343AFseu · failedDFW INFLIGHT - ON APPROACH FLAPS WOULD NOT EXTEND. GAUGE SHOWED NEEDLE SPLIT AT ZERO DEGREES. LEADING EDGE DEVICES EXTENDED BY ALTERNATE FLAP SWITCH. LANDED DFW WITHOUT INCIDENT. REPLACED FLAP SLAT ELECTRONIC UNIT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801999Light · inoperativeDFW EMERGENCY LIGHT AT RT HAND EXTERIOR OVERWING INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT RT AND EXTERIOR OVERWING. SYSTEM GROUND CHECKED NORMAL OPS. (CLOSED)SDR AALA200802000Lamp · inoperativeDFS EMERGENCY FLOOD LIGHT AT FIRST CLASS OVERHEAD INOPERATIVE. REPLACED LAMP FOR EMERGENCY FLOOD LIGHT AT FIRST CLASS OVERHEAD. SYSTEM GROUND CHECKED NORMAL OPS. (CLOSED)SDR AALA200801703Connector · looseJFK - EMERGENCY LIGHT AT SEAT 27D INOPERATIVE. SECURED LOOSE CONNECTOR FOR EMERGENCY LIGHT AT SEAT 27D. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801702Connector · looseJFK - EMERGENCY LIGHT AT SEAT 19D INOPERATIVE. SECURED LOOSE CONNECTOR FOR EMERGENCY LIGHT AT SEAT 19D. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801576Actuator · malfunctionedCUN INFLIGHT T364/10JUN CZM TO DFW. CREW REPORTED STABILIZER TRIM FAULT DURING CLIMB. LANDED CUN WITHOUT INCIDENT. CAPTAIN REPORTED NO SIGNIFICANT CONTROL PROBLEMS. REPLACED STABILIZER TRIM ACTUATOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801008Tab · missingMIA - EMERGENCY FLASHLIGHT AT LEFT NUMBER ONE DOOR TAMPER TAB MISSING. REPLACED TAMPER TAB FOR EMERGENCY FLASHLIGHT AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800074Sensor · inoperativeDEN INFLIGHT T357/16JAN - TRAILING EDGE FLAPS SPLIT AT TWO DEGREES DURING APPROACH. LANDED DEN WITHOUT INCIDENT. REPLACED NUMBER SIX SKEW SENSOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072095Probe · inoperativeMIA INFLIGHT T651/31OCT - NUMBER TWO ENGINE INDICATED HIGH ENGINE GAS TEMPERATURE ON TAKEOFF. RETURNED TO MIA AND LANDED WITHOUT INCIDENT. REPLACED TOP LEFT T49.5 PROBE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070884Battery Pack · inoperativeMIA - EMERGENCY LIGHT AT AFT CABIN LEFT SIDE INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT AFT CABIN LEFT SIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070883Battery Pack · inoperativeMIA - EMERGENCY LIGHT AT SEAT 22A INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT SEAT 22A. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070505Bulb · burned outMIA - EMERGENCY LIGHT AT LEFT NUMBER TWO DOOR SLIDE INOPERTIVE. RELAMPED EMERGENCY LIGHT AT LEFT NUMBER TWO DOOR SLIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070033Control Circuit · inoperativeMIA - EMERGENCY EXIT LIGHT AT LEFT AFT DOOR AND AFT GALLEY CEILING INOPERATIVE. RESET SYSTEM FOR INOPERATIVE EMERGENCY EXIT LIGHT AT LEFT AFT DOOR AND AFT GALLEY CEILING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061375Connector · looseMIA - EMERGENCY LIGHT AT SEAT ROW 16DEF INOPERATIVE. SECURED CONNECTOR FOR EMERGENCY LIGHT AT SEAT ROW 16DEF. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060657Cover · missingMIA - EMERGENCY LIGHT AT RIGHT AFT LAVATORY MISSING COVER. REPLACED MISSING COVER FOR EMERGENCY LIGHT AT RIGHT AFT LAVATORY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050399Battery Pack · inoperativeALL EMERGENCY LIGHTS IN CABIN FAILED BLEED DOWN TEST. REPLACED BATTERY PACKS FOR ALL EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N917AN