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 UALA2013071604999Radio · malfunctionedVHF RADIO TRANSMISSION PROBLEMS. CANNOT TRANSMIT ON LEFT BOOM MICROPHONE. HAND MICROPHONE OK. REPLACED CAPTAIN`S BOOM MICROPHONE, NO HELP. ASSOCIATED HAND MICROPHONE OPERATES NORMALLY. REPLACED CAPTAIN`S RADIO, OPS CHECKED NORMAL.SDR UALA2013071604998Unknown · unknownEXPOSED METAL BOLT HEAD ELECTRIC CONNECTOR LOWER RT CORNER, RT WINDSHIELD. RIGHT WINDSHIELD LOWER RT CORNER BOLTHEAD COVER INSTALLED.SDR CALA2013082790796Lens · brokenAFT GALLEY EMERGENCY LIGHT LENS BROKE LOWER RIGHT CORNER. REPLACED LIGHT ASSEMBLY, OPERATIONS NORMAL.SDR UALA2013060503889Oxygen Mask · unwanted deployOXYGEN MASKS DROPPED 9G. MASKS STOWED AND SECURED CLOSE.SDR UALA2013052903731Window · crackedWINDOW INNER PANE HAS TWO CRACKS AT SEAT 35A. REPLACED INNER PANE ON WINDOW REVEAL ASSY AND OK.SDR UALA2013050903265Radome · erodedRADOME ERODED WITH POSSIBLE DELAMINATION. REPAIRED IAW SRM 53-10-72.SDR UALA2013032802013Mask · unknownOXYGEN DEMO MASK AT 45C NEEDS REPLACING. REPLACED MASK-AY-DEMO OXYGEN.SDR UALA2012102906232Housing · missingLEFT PACK FAN INLET DIFFUSER HOUSING SUPPORT BRACKET EXITED PACK EXHAUST. REPLACED DIFFUSER HOUSING PER MM, OPS CHECK NORMAL AND LEAK CHECK OK.SDR UALA2012091305162Rivet · looseLEFT ENGINE HAS LOOSE RIVET IN EXHAUST CONE AT 6 O'CLOCK POSITION ON DATA PLATE.SDR UALA2012091005094Panel · malfunctionedELMS P310 CHANNEL ONE, BUT NOT BOTH, OF THE ELECTRICAL LOAD MANAGEMENT SYSTEM (ELMS) 310 PANEL CHANNEL IS FAULTY. RPL- :GOT MSG 24-13092. REPLACED M24406A1 PER MM, OPS TEST NORMAL, NO STATUS MSG PRESENT.SDR UALA2012090404993Coupler · failedRT HF TUNING. DUE TO CHRONIC REPORTS OF RT HF RADIO WILL NOT TUNE, PERFORM THE FOLLOWING TASKS. COUPLER MR23167-10 WAS INSTALLED ON 8-26 AND HAD PREVIOUS HISTORY FOR SAME PROBLEM. PREVIOUS PROBLEM ON THIS AC WAS RECEPTION. TUNING PROBLEM ONLY APPEARED AFTESDR UALA2012082704810Transceiver · faultyHF SYSTEM FAILURE, RTFL HF COMM RT INOP. RADIO TUNES BUT NO VOX XMIT ORRCV. CYCLED C-B NO HELP. REPLACED RIGHT HF TRANSCEIVER PER MM. CONFIRMED REC-TRANSMIT FUNCTION RIGHT HF SYSTEM OPERATES NORMAL.SDR UALA2012082704809Transceiver · faultyHF COMM RT INOP. RADIO TUNES BUT NO VOX XMIT ORRCV. CYCLED C-B, NO HELP. REPLACED RIGHT HF TRANSCEIVER PER MM. CONFIRMED REC-TRANSMIT FUNCTION RIGHT HF SYSTEM OPERATES NORMAL.SDR UALA2012081304444Engine · overtempLT ENGINE EGT EXCEEDANCE, IN AREA C, BEFORE NEXT FLIGHT ACCOMPLISH VISUAL CHECKS AND HOT SECTION BORESCOPE PER AMM 72-00-00. REPLACED NR 1 ENGINE.SDR UALA2012080604185Engine · faultyREF L ENG EGT EXCEEDANCE. REPLACED NR 1 ENGINE IAW AMM 72-00-00 PAGE 623 CONFIG 2.SDR UALA2012050402634Charger · faultyBATTERY CHARGER APU MESSAGE. REPLACED APU CHARGER AND BATTERY PER MM, CKS OKAY.SDR UALA2012042002373Battery Pack · no testLLAR BACKUP LIGHT BATTERY FAILS CAPACITY CHECK. REF A CHECK JC 2-2018 ITEM 3 AND MM. REPLACED M023 BATTERY PACK POWER SUPPLY ASSY PER AMM. SYSTEM CHECKS NORMAL.SDR UALA2012031401691Connector · defectiveSIDEWALL LIGHT BALLAST CONNECTOR DM33084E WON'T LOCK AT 41ABC. REPLACED SIDEWALL LIGHT ASSY AT ROW 41ABC PER AMM, OPERATIONAL CHECK OK.SDR UALA2012031401690Connector · faultyLIGHTING HARNESS ON STR CLIP BETWEEN STA 1970 AND 1990 LT STR 12L CONNECTOR DM33036C INS NON-COMPLIANT PER FCD 3321-01019. NEED TO SEND OLD CONNECTOR TO SFOEG. REPLACED CONNECTOR DM33036C REF FCD 3321-01019.SDR UALA2012031401689Connector · improper partLIGHTING HARNESS ON STR CLIP BETWEEN STA 1970 1990 LT STR 12L CONNECTOR DM33036B IS NON-COMPLIANT PER FCD 3321- 01019. NEED TO SEND OLD CONNECTOR TO SFOEG. REPLACED CONNECTOR DM33036B REF FCD 3321-01019.SDR UALA2012031401688Connector · faultyLIGHTING HARNESS ON STR CLIP BETWEEN STA 1970 AND 1990 LT STR 12L CONNECTOR DM33036A IS NON COMPLIANT PER FCD 3321-01019 STEP 12 PG 34. REPLACED CONNECTOR DM33036A REF FCD 3321-01019. REPLACED CONNECTOR DM33036A REF FCD 3321-01019. ACCOMPLISHED INSPECTION ASDR UALA2012031401686Connector · faultySIDE WALL LIGHTING CONNECTOR DM33084E LOCATED AT STA 1840 LBL 90, CONNECTOR IS NON COMPLIANT PER FCD 3321- 01019 REV C PG 32 STEP 8. REPLACED CONNECTOR DM33084E REF FCD 3321-01019. ACCOMPLISHED INSPECTION AS REQUIRED REF FCD 3321-01019.SDR UALA2012031401685Connector · faultyLIGHTING HARNESS LOCATED BETWEEN STA 1580 & 1601 STR 12R, CONNECTOR D5188P IS NON COMPLIANT PER FCD3321-0101 9 REV C PG 34 STEP 13. REPLACED CONNECTOR D5188P REF FCD3321-01019. ACCOMPLISHED INSPECTION AS REQUIRED REF FCD 3321-01019.SDR UALA2012031401684Connector · faultyLIGHTING HARNESS LOCATED ON STR CLIP BETWEEN STA 1580 & 1601 STR 12R CONNECTOR D5188J IS NON COMPLIANT PER FCD 3321-01019 REV C PG 34 STEP 13. REPLACED CONNECTOR. ACCOMPLISHED INSPECTION AS REQUIRED REF FCD 3321-01019.SDR UALA2012030701492Display · faultyF-O RT DISPLAY BLANK. SELECTOR PANEL INOP. REPLACED NR 2 AIMS DISPLAY UNIT PER MM.SDR UALA2011122707127Fuel/Oil Cooler · leakingRETURN TO GATE DUE TO NR 1 ENGINE FUEL LEAK. FUEL OIL COOLER LEAKING FUEL FROM DRAIN MAST. TROUBLESHOT & RAN ENGINE 2X5 MIN IDLE TO INSPECT FOR LEAKS ON NR 11 DRAIN MAST NR 1 ENG. AFTER IDLE RUNS, CHECKED FOR LEAKAGE FOR OVER 5 MIN, AND NO DROPS NOTED ON NR 1SDR UALA2011121406854Battery · failedON ARRIVAL RECEIVED MESSAGE 24-50243, & STATUS MESSAGE FOR FLIGHT CONTROL SYS. PER FIM 24-35 TASK 802 CHK FOUND FCDC CENTER BATTERY IS BAD PER MM. REPLACED WITH NEW BATTERY, MSG GONE. OPERATION TEST FINE, NO FAULT FOUND.SDR UALA2011120606690Liner · delaminatedNR 2 ENGINE EXIT LINER SEGMENT AT 7 O'CLOCK POSITION HAS WIRE MESH DELAMINATED FROM THE LEADING EDGE IN 2 LOCATIONS. REMOVED EXIT LINER AT 7 O'CLOCK POSITION PER MM. INSTALLED NEW SECTION OF LINER AND APPLIED SEALANT.SDR UALA2011120606691Structure · damagedLEFT FLAP INBD TRAILING EDGE HAS DAMAGE. CUT OUT DAMAGE, POTTED IN REPLACEMENT CORE. REPAIRED WITH 250 DEGREE OVERLAY REPAIRS PER SRM.SDR UALA2011120606689Seal · damagedLEFT FLAPERON SEAL DAMAGED AT T/E. FLAPERON REMOVED, REPLACED DAMAGED SEAL WITH NEW SEAL.SDR UALA2011111606273Seal · damagedNR 2 ENGINE LT THERMAL INSULATION BLANKET DAMAGED FROM AIR LEAK. REPLACED DAMAGED BLANKET. REMOVED NR 2 ENGINE PRSOV. REPLACED SEALS AND RE-INSTALLED PRSOV, LEAK CHECKED GOOD.SDR UALA2011111606272Pressure Switch · damagedNR 1 ENGINE MAIN FUEL PUMP PRESS SWITCH ELECTRICAL CONNECTOR DAMAGED. REMOVED AND REPLACED NR 1 ENG FUEL PUMP DIFFERENTIAL SWITCH IAW MM. OPS AND LEAK NORMAL IAW MM.SDR UALA2011110405976Starter · damagedENG START VALVE L LEFT STARTER AIR VALVE POSITION DISAGREES WITH COMMANDED POSITION OR STARTER AIR VALVE POSITION INDICATION IS LOST. STARTER ON LEFT ENGINE DAMAGED, METAL FOUND ON CHIP DETECTOR. REPLACED LEFT ENGINE STARTER PER AMM. MOTORED ENGINE. ALSO RSDR UALA2011101305566Lock · defectiveCREW REST DOOR STUCK, UNABLE 2 OPEN. FCR DOOR LOCK IS DEACTIVATED IN UNLOCKED POSITION. DOOR OPENS & CLOSED NORMALLY. CAN BE USED. LOCK ASSY PART # 023-1394 OUT OF STOCK AT ORD.SDR UALA2011100505386Electrical Box · malfunctionedPILOT CREW REST SEAT INOPERATIVE. STUCK PARTIALLY RECLINED, RESET UNDERSEAT ELECTRONICS CONTROL BOX.SDR UALA2011092905284Structure · loosePILOT CREW REST AREA DOOR FRAME TRIM AT FWD BOTTOM IS STICKING OUT. SECURED TRIM WITH TAPE.SDR UALA2011092705209Fire Loop · shortedFIRE HANDLE WAS PULLED BY FLIGHT CREW DUE TO APU AUTO SHUT DOWN. BEFORE DEPARTURE APU AUTO SHUT DOWN, APU CONSIDERED INOPERATIVE. CREW PULLED HANDLE AND DISCHARGED FIRE EXTINGUISHER. REPLACED APU FIRE EXTINGUISHING BOTTLE AND SQUIB PER MM. BOTTLE PRESSURESDR UALA2011090704848Precooler · crackedNR 2 ENGINE PRECOOLER CRACKED AT BOTTOM. COMPLETE INSTALLATION OF NR 2 PRECOOLER. INSTALLATION THRU ITEM G. NEED TO COMPLETE INSTALLATION FROM 3H TO END - ACCOMPLISHED.SDR UALA2011090204740Battery · faultyMAIN BATT DISCHARGE EICAS ADVISORY MSG. EICAS MAINTENANCE PAGE INDICATES MAIN BATT VOLTAGE AT 24 VDC AND 11AMP DISCHARGE. REPLACED MAIN BATT AND MAIN BATT CHARGER.SDR UALA2011083104671Interface Unit · faultyCREW REPORTS WITH NR 1 ENGINE OFF SITTING AT GATE N2 INDICATION FLUX'S BETWEEN 4.5 AND 5.5 PERCENT WITH EEC GRD POWER ON N2 READS 11.1 PERCENT. REST AIMS AND SWAPPED EDIU'S S/N 99080051 IS IN THE LT POSITION AND S/N 99076300 IS IN THE RT POSITION. WITH CREW SDR UALA2011081504327Chiller · inoperativeCHILLER - INOPERATIVE 212. (LOCATION NOT DEFINED - CHK CABIN FORM FOR SPECIFIC LOCATIONS). CREW COMMENTS: FIRST CLASS CHILLER INOP MEALS WERE WARM. THE CHILLER DID NOT PRODUCE CHILLED AIR. NOTIFIED CATERING SERVICE TO PUT DRY ICE INTO FOOD CART. REPLACEDSDR UALA2011071903663Control Unit · faultyFUEL QTY AND IMBALANCE GRIPE. ACPD DISCHARGE CHECK VLV. ND TO CONT TO ACP LOW LEVEL SCAVENGE SYSTEM, R&E'S ASSISTING. FUELED AC FOR HIGH LEVEL SCAVENGE CHECKS. CONT T-S. *DOR*. ACFT DROPPED OFF AT GATE WITH MSG FUEL PUMP CENTER RIGHT MSG, NO TIME SFO. REPSDR UALA2011071103406Striker · missingFLIGHT CREW REST DOOR LOWER STRIKER PLATE ROBBED. DOOR SECURED IN CLOSED POSITION PER MEL 2529B. REPLACED DOOR LOWER STRIKER.SDR UALA2011042502001Switch · out of positionEMERENCY LIGHTS ADVISORY ON EICAS. COCKPIT EMER SWX CONFIRMED OFF. FOUND ARMING DEVICE NOT IN THE CORRECT POSITION OF SWITCH IN FLIGHT DECK P5 OVERHEAD PANEL. SECURED ARMING DEVICE OVER TOGGLE SWITCH. EMERGENCY LIGHTS OPS CHECKED OKAY.SDR UALA2011040701677Idg · failedELEC GEN DRIVE L LEFT IDG FAULT (LOW INTERNAL OIL PRESSURE). INSTALLED NEW IDG AT LT ENGINE. ACCOMPLISHED IDG TEST PER MM. OPS CHECK GOOD.SDR UALA2011040501633Sensor · faultyRIGHT ENG BLEED INOP, FLIGHT DIVERTED. REPLACED DUAL MAIN TEMP SENSOR AND MAT TEST PASSED. ACCOMPLISHED PNEU TEST AT ALL POWER SETTINGS, BLEEDS AND PACKS ON AND OFF AND NO OPERATIONAL PROBLEMS NOTED.SDR UALA2011021000697Lamp · inoperativeDOOR 2R EXTERIOR EMERGENCY LIGHT INOP. RELAMPED, OPS GOOD.SDR UALA2011011200177Window · leakingCONTINUOUS LOUD AIR NOISE ON FIRST OFFICERS SIDE WINDOW. REPLACED RIGHT SIDE COCKPIT WINDOW SEAL PER MM. SEAL REPLACED. DUE TO REPEAT PILOT REPORTS OF WINDOW SQUEAL, AND SEAL WAS PREVIOUSLY REPLACED NEED TO REPLACE F/O SLIDING WINDOW. POSSIBLE ADJUSTMENT ISDR UALA2011010400061Circuit Card · faultyCARD ASSY-AIRFOIL AND COWL ICE NEEDS REPLACEMENT. REPLACED CARD ASSY.SDR UALA2011010400060Controller · failedON ACCT OF REPLACEMENT OF LT ENG ANTI-ICE VALVE, ACCOMPLISH A TEST (ENGINE RUNNING) OF THE ENGINE ANTI-ICE SYSTEM. ACCOMPLISHED ENGINE ANTI-ICE ENGINE RUNNING SYSTEM TEST. TEST FAILED MAINTENANCE MESSAGE 30-10-101. REPLACED EAI VALVE CONTROLLER HEATER. OPS
Back to N209UA