N447UA
Service difficulty reports · 110
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 = 'N447UA' 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 = 'N447UA' 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 2007UALA02738Power Supply · wrong partROWS 1, 2, 3 & 5 HAVE NO EEL LIGHTS. INSTALLED NEW PWR SUPPLY IN FWD POSITION WITH BORROWED PART FROM US AIRWAYS P/N 3214-54-10, S/N 2016, AND OPS CHECK GOOD.SDR 2007UALA00272Bottle · out of limitsDOOR 2L BOTTLE PRESSURE IS OUT OF LIMITS. [SUP 05-08-07] THE DOOR 2L ASSIST BOTTLE BEING BELOW LIMITS WAS A REGULAR OCCURRENCE ON THIS AIRCRAFT. AT THE NEXT OCCURRENCE OF THE SAME FAULT, IT WAS DETERMINED THAT THE DOOR DAMPER CYLINDER WAS FAULTY AND IT WAS RSDR 2006UALA02071Bottle · underservicedDOOR 2L PRESSURE LOW. SERVICED DOOR ASSIST (CYLINDER-DOOR DAMPER) BOTTLE TO LIMITS.SDR 2006UALA01381Compressor · stalledNR 1 ENG COMPRESSOR STALL AT 7500 FT. FLAME SEEN AT FRONT AND BACK OF ENGINE FROM THE CABIN.SDR 2005UALA01127Epsu · will not testEMERGENCY LIGHT TEST FAILED EPSU INT LOAD FWD L. REPLACED THE FWD LEFT EPSU.SDR 2004UALA00279Windshield · crackedWINDSHIELD ON CAPTAIN'S SIDE STARTED TO CRACK & GOT PROGRESSIVELY WORSE. FLIGHT DIVERTED. WEATHER SEAL DETERIORATION LEAD TO DELAMINATION OF WINDOW ALLOWING WATER INGRESION CAUSING ARCING AT THE BUS BAR RESULTING IN CRACKING OF THE WINDSHIELD. THE WINDSHIELDSDR 2004UALA00265Proximity Switch · out of adjustLEFT FWD OVERWING EXIT SHOWED OPEN ON ECAM. FLIGHT DIVERTED. THE SUBJECT DOOR'S PROXIMITY SWITCH WAS ADJUSTED.SDR 2002UALA01207Controller · failedRETURNED TO FIELD. SMOKE ELECTRICAL SMELL IN CONTROL CABIN. CIRCUIT BREAKERS PHC2, AOA2, PITOT2, TAT2, AND PHC3 ALL POPPED. REPLACED NR 2 PHC AND TESTED ALL PROBE HEATERS FOR PROPER OPERATION. SYSTEM OPERATED NORMAL WITH NO ADDITIONAL FAILURES NOTED ON SUBSDR 2001UALA02383Pump · failedYELLOW HYDRAULIC RESERVOIR OVERHEAT WARNING IN FLIGHT. REPLACED YELLOW SYSTEM ENGINE DRIVEN HYDRAULIC PUMP.SDR 2001UALA01647IndicatorON CLIMB, RECEIVED YELLOW HYDRAULIC RESERVOIR OVERHEAT WARNING. SUPPLEMENTAL DATA UPDATE FOUND YELLOW SYSTEM OVER SERVICED. REMOVED EXCESS HYDRAULIC FLUID AND ALSO REPLACED REMOTE HYDRAULIC QUANTITY INDICATOR FOR A STUCK NEEDLE TO PREVENT RECURRENCE.
Back to N447UA