N209UA
Service difficulty reports · 166
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 = 'N209UA' 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 = 'N209UA' 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 2008UALA04281Unknown · unknownCREW REPORT: FUEL APPEARS TO TRANSFER TO THE RT TANK AT 600-HR OR MORE.SDR 2008UALA03650Light · trippedAPU REMOTE FIRE IND-AUTO DISC ARM CIRCUIT BREAKER FOUND POPPED AND WILL NOT RESET. FOUND APU FIRE BOTTLE ARMED LIGHT SHORTED. REPLACED LIGHT ASSEMBLY OP CHECKED GOOD. AC OK FOR SERVICE.
SDR 2008UALA03361Filter · dirtyEQUIPMENT COOLING FAN WARNING HORN KEEPS GOING OFF. *S/D* SUSPECT DIRTY FILTER. REPLACED FILTER, OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA02767Air Filter · dirtyEQUIPMENT COOLING HORN ON AND EQUIP COOLING EICAS. FOUND DIRTY AIR FILTER. REPLACED AIR FILTER PER MM -21-27-02. OP CHECK GOOD. AC OK FOR SERVICE.SDR 2008UALA02331Lamp · inoperativeFOUND DOOR 3L EXTERIOR EMERGENCY LIGHT INOP. FOUND FAULTY LAMP. REPLACED LAMP OP CHECKED GOOD. AC OK FOR SERVICE.SDR 2008UALA01810Oil Filter · cloggedENG OIL FILTER R RIGHT ENGINE PRIMARY OIL FILTER APPROACHES BYPASS (LARGE PRESSURE DIFFERENTIAL ACROSS NORMAL FILTER) WITH ENGINE RUNNING. REPLACED OIL FILTER & CHANGED OIL.SDR 2008UALA01672Extinguisher · faultyTRASH CAN EXTINGUISHER AT LAV 4R DISCHARGED WITH NO SIGN OF FIRE.SDR 2008UALA00274Lamp · inoperativeEEL(S) INOP AT FIRST CLASS SEAT 3E AFT & BUSINESS CLASS SEATS 11F & 13D. RELAMPED.SDR 2008UALA00273Lamp · inoperativeEMERGENCY LIGHT OUT AT MID GALLEY NR 2 RIGHT SIDEWALL. RELAMPED.SDR 2007UALA02377Oven · fumesFLIGHT DIVERTED DUE TO FUMES COMING FROM A BUSINESS CLASS OVEN. [07-27-07] FOUND ODOR TO BE STRONGEST IN MID GALLEY AREA. APPEARED TO BE ACIDY SMELL. WHEN WARMING OVEN W33 WAS OPENED, ODOR BECAME MUCH STRONGER. FOUND PAPER TOWEL AND RESIDUE OF MELTED PLASTSDR 2007UALA01463Idg · failedCREW REPORTS RIGHT GENERATOR FAILURE. APU BEING USED & APU INLET DOOR OPEN. APU AUTO SHUTDOWN AT 16500 FT 310K & AGAIN AT 14500 FT 250K IDLE POWER. [SUP 06-06-07] NR 2 ENGINE IDG WAS REPLACED, BUT CAUSE OF W-U WAS APU AUTO SHUTDOWN. AFTER TROUBLESHOOTING,SDR 2007UALA00952Light · damagedSEAT 2F EVACUATION LIGHT IS DAMAGED. REPAIRED LIGHT. OP CHECKS OK.SDR 2005UALA00819Lamp · burned outNR 3 LT DOOR EMERGENCY SLIDE LIGHT INOP. REPLACED LAMP.SDR 2004UALA01187Skin · dentedDOOR 4R HAS 2 EA DENTS ON EXT SKIN AT BOTTOM EDGE. DOOR SKIN ON PASSENGER ENTRY DOOR (PED) WAS FOUND DAMAGED. THE DAMAGE CONSISTED OF TWO DENTS AT THE LOWER DOOR EDGE. THE DAMAGE WAS REPAIRED PER SRM. MAJOR REPAIR ACCOMPLISHED.SDR 2003UALA00862Floorbeam · crackedSTA 246 FLOORBEAM LBL 7.88 VERTICAL STIFFENER CRACKED. MAJOR REPAIR ACCOMPLISHED. STIFFENER REPLACED.SDR 2002UALA01845Flaperon · malfunctionedAIRCRAFT EXPERIENCED FISHTAILING, LASTING 30 SECONDS. SYNOPTIC INDICATED INDEPENDENT CYCLING OF LT & RT FLAPERONS NEAR FULL UP DEFLECTION. AFTER 3-4 CYCLES OPS NORMAL. AUTOPILOT ENGAGED DURING ENCOUNTER, FL380. NO FMC DIRECTED TURNS.
Back to N209UA