N717UW
Service difficulty reports · 314
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 = 'N717UW' 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 = 'N717UW' 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 USAA050724Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH AREA, FRAME 17 BLL 18 INCHES. CORROSION LEVEL 2, TASK JA-220-53500. REPLACED FLOORBEAM PER SRM 53-11-14, DWG B2D53112826. (M)SDR SA05044Windshield · crackedON DESCENT INTO BOS, THE FIRST OFFICER'S WINDSHIELD BEGAN TO ARC AND CRACK. CREW FOLLOWED QRH PROCEDURES AND CONTINUED TO BOS. FLIGHT LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED THE FIRST OFFICER'S WINDSHIELD. OPERATIONALLY CHECKS OK.SDR SA05038Epsu · faultyTHE LEFT CENTER EMERGENCY POWER SUPPLY UNIT WOULD NOT TEST. MAINTENANCE REPLACED THE LEFT CENTER EMERGENCY POWER SUPPLY UNIT. OPERATIONALLY CHECKS OK.SDR SA05022Epsu · faultyDCA - DURING TEST, THE EMERGENCY POWER SUPPLY UNIT IN THE MID LEFT CABIN POSITION PRODUCED AN EMER L FAULT MESSAGE. MAINTENANCE REPLACED THE MID LEFT CABIN EMERGENCY POWER SUPPLY UNIT. OPERATIONALLY CHECKS OK.SDR SA05014Epsu · faultyTHE MID CABIN LEFT EMERGENCY POWER SUPPLY UNIT FAILED TEST. MAINTENANCE REPLACED THE LEFT EMERGENCY POWER SUPPLY UNIT. OPERATIONALLY CHECKS OK.SDR SA04109Epsu · faultyPHL - THE EMERGENCY LIGHT SYSTEM FAILED TEST WITH MESSAGE,"EPSU UNIT EMER L". MAINTENANCE REPLACED THE EMERGENCY POWER SUPPLY UNIT BELOW THE LEFT EMERGENCY OVERWING DOOR. OPERATIONALLY TESTS OK.SDR USAASA03098Power Supply · inoperativeAN AFT EMERGENCY POWER SUPPLY UNIT WAS FOUND BAD DURING TEST. MAINTENANCE REPLACED THE EMERGENCY POWER SUPPLY UNIT. (M)SDR USA2002F00085Check Valve · rupturedENROUTE, AFTER TAKEOFF, THE TOWER NOTIFIED THE CREW THAT FUEL WAS STREAMING FROM THE RT WING. CREW OBSERVED THAT THE LT WING FUEL QUANTITY WAS 400 LBS LESS THAN THE RT WING. AFTER CRUISE ALTITUDE WAS REACHED, THE FUEL QUANTITY WAS STABILIZED. FLIGHT RETURNESDR USAASA02054Valve · malfunctionedENROUTE, ON TAKEOFF, FUEL SEEN VENTING FROM RIGHT WING TIP. LEFT TANK FUEL INDICATED 200 LBS LESS THAN RIGHT WING. BY THE END OF THE FLIGHT, UPON LANDING, LEFT TANK FUEL WAS 480 LBS LESS THAN RIGHT WING. MAINTENANCE REPLACED RIGHT WING TANK AIR RELEASE VALVSDR USAASA02027Pseu · faultyRECEIVED AN LEFT INT LOAD EPSU FAULT DURING THE EMERGENCY LIGHTS TEST. MAINTENANCE REPLACED THE EMERGENCY POWER SUPPLY UNIT AT THE LEFT EMERGENCY EXIT ROW. OPERATIONALLY CHECKED OK.SDR USAASA02026Light · inoperativeCLT - THE EMERGENCY LIGHT SYSTEM WAS FOUND INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY POWER SUPPLY IN THE MID CABIN. OPERATIONALLY CHECKED OK. (M)SDR USAASA01052Control Panel · shortedPBI - FLT 270 - EN ROUTE MIA-PIT, AFTER TAKEOFF, RECEIVED A NR 1 RADIO MANAGEMENT PANEL ELECTRICAL FAULT LIGHT, NAVIGATION ILS FAULT, AND GROUND PROXIMITY FAULT. THE RADIOS ALSO BECAME INOPERATIVE. AFTER A RESET OF THE CIRCUIT BREAKERS, A BURNING ELECTRICAL SDR USAASA01033Power Supply · faultyPHL - THE LEFT EMERGENCY POWER SUPPLY UNIT FAULTED. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT. OK FOR SERVICE. (M)SDR USAASA01017Power Supply · inoperativeSFO - THE EMERGENCY POWER SUPPLY UNIT POWER L FAILED THE EMERGENCY LIGHTS TEST. MAINTENANCE REPLACED THE INOPERATIVE EMERGENCY POWER SUPPLY UNIT. OPERATIONALLY CHECKS OK. (M)
Back to N717UW