N108UW
Service difficulty reports · 329
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 = 'N108UW' 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 = 'N108UW' 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 USAA050857Floor Support · corrodedPIT - FOUND FLOORBEAM CORRODED 4 INCHES BY 18 INCHES BY .050 INCH, FLOOR SUPPORT Y1732 FRAME 69-70. DEFECTIVE PART REPLACED WITH IDENT PART NR PER SRM 53-00-15 FIG 201. (M)SDR USAA050858Sill · corrodedPIT - FOUND DOOR SILL CORRODED 1 INCH, -1732 FLOORBEAM/DOORSILL AT FRAME 66. REMOVED AND REPLACED DOORSILL/FLOORBEAM PER SRM 51-72-11. CORROSION LEVEL 1, TASK JA-260-53500. (M)SDR USAA050859Floorbeam · corrodedPIT - FOUND FLOORBEAMS CORRODED .5 INCH DIAMETER AROUND 12 NUTPLATES, STATION Y1292 FRAME 66-68. REPLACED FLOORBEAM SECTIONS FROM FRAME 64-70 PER SRM 51-72-11. (M)SDR USAA050860Seat Track · corrodedPIT - FOUND FLOOR SUPPORT SEAT TRACK CORRODED 2 FT BY .5 INCH, BETWEEN C18 AND C20. REPLACED BEAM SECTION PER DWG D53110900. CORROSION LEVEL 1, TASK JA-220-53500. (M)SDR USAA050861Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1 INCH BY .75 INCH, FRAME 68 Y 254. REMOVED OLD FLOORBEAM AND INSTALLED NEW PER AIRBUS DWG 18D53472780. (M)SDR USAA050862Floor Support · corrodedPIT - FOUND FLOOR SUPPORT CORRODED 1 INCH BY 1 INCH BY .070 INCH DEEP, Y495 ABOVE CROSSBEAM C16. REMOVED AND REPLACED IDENTICAL FLOOR SUPPORT PER SRM 51-72-11. CORROSION LEVEL 1, TASK JA-220-53500. (M)SDR USAA050797Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 2 INCHES BY 36 INCHES, Y765 PLUS FRAME 66-70. REPLACED FLOORBEAM PER SRM 51-72-11 TYPICAL 51-40-01. CORROSION LEVEL 1, TASK JA-260-53500. (M)SDR USAA050796Frame · corrodedFOUND FRAME CORRODED 6 INCHES BY 2 INCHES, FRAME 66 LEFT AT NUT PLATE HOLES. SPLICE AND DOUBLER REPAIR PER SRM 53-41-14 FIG 201. CORROSION LEVEL 1, TASK JA-26-53500. (M)SDR SA05078Cable · misinstalledDURING INSPECTION OF RT FRONT DOOR ESCAPE SLIDE ASSEMBLY, CABLE FOUND INCORRECTLY INSTALLED. MAINTENANCE INSTALLED CABLE CORRECTLY.SDR SA05077Line · misinstalledDURING INSPECTION OF AFT LT DOOR ESCAPE SLIDE, GREEN MOORING LINE FOUND INCORRECTLY INSTALLED. MAINTENANCE CORRECTLY INSTALLED GREEN MOORING LINE.SDR SA05033Light · damagedCLT - THE ROW 5C EMERGENCY EXIT LIGHT HOUSING WAS FOUND DAMAGED. MAINTENANCE REPLACED THE EMERGENCY LIGHT ASSEMBLY AT SEAT ROW 5C. OPERATIONALLY CHECKS OK.SDR USAASA03049Girt Bar · damagedBOS - DURING INSPECTION, THE L1 GIRT BAR WAS FOUND TO HAVE IMPROPER CLEARANCE WITH THE DOUBLER/STOP. MAINTENANCE REPLACED THE GIRT BAR. THE INSTALLATION WAS INSPECTED AND FOUND SERVICEABLE. (M)SDR USAASA02096Power Supply · dischargedCLT - FOUND THE EMERGENCY LIGHTS SYSTEM FAILED THE OPERATIONAL TEST. MAINTENANCE REPLACED AN EPSU. OPERATIONALLY CHECKS OK. (M)SDR USAASA02090Battery · dischargedBDL - THE EMERGENCY LIGHT SYSTEM FAILED THE TEST. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT BATTERIES. OPERATIONALLY CHECKS OK. (M)SDR USAA020375Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED 25 SQUARE INCHES, FLOORBOARD INTERCOSTAL AT FRAME 16, 20 INCHES LEFT OF CENTER. CORROSION LEVEL 2. (M)SDR USAA020376Floorbeam · corrodedFOUND FLOORBEAM CORRODED 2 INCH AREA, FLOORBOARD INTERCOSTAL FRAME 16, 30 INCHES LEFT OF CENTER. CORROSION LEVEL 2. SPLICED IN NEW SECTION OF FLOORBEAM FROM FRAME 16 FORWARD PER SRM 53-11-14 FIG 202. (M)SDR USAA020377Floorbeam · corrodedTPA - FOUND FLOOR BEAM CORRODED 1 SQUARE INCH, OUTBOARD FLOORBEAM AT FLOORBOARD HOLE FORWARD OF GIRT BAR PAD. CLEANED AREA AND INSTALLED REPAIR ANGLE PER SRM 53-41-14 FIG 201, REPAIR PRINCIPAL 2. (M)SDR USAA020379Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED, LEFT AFT LAVATORY, AFT INBOARD LAVATORY MOUNT HOLE. DEFECTIVE PART REPLACED WITH IDENTICAL PART NR. (M)SDR USAA020378Floorbeam · corrodedTPA - FOUND FLOORBEAM CORRODED, LEFT AFT LAVATORY, AFT OUTBOARD LAVATORY MOUNT HOLE. CORROSION LEVEL 2. DEFECTIVE PART REPLACED WITH IDENTICAL PART NR. (M)SDR USAASA02075Light · inoperativeDCA - THE EMERGENCY LIGHTS SYSTEM TEST FAILED. MAINTENANCE RELAMPED THE ESCAPE HATCH LIGHTS. SYSTEM CHECKS OK. (M)SDR USAASA02070Power Supply · will not testCLT - THE AFT LEFT OVERWING EXIT EMERGENCY POWER SUPPLY UNIT FAILS TEST, INDICATING AN INTERIOR AND EXTERIOR LIGHTS FAULT. MAINTENANCE REPLACED THE EMERGENCY POWER SUPPLY UNIT. OPERATIONALLY CHECKED OK. (M)SDR USAASA02060Power Supply · dischargedDCA - AN EMERGENCY POWER SUPPLY FAULT WAS INDICATED ON THE FLIGHT ATTENDANTS PANEL. MAINTENANCE REPLACED AN EMERGENCY POWER SUPPLY UNIT WITH BATTERIES. OPERATIONALLY CHECKED OK. (M)SDR USAASA02020Battery · dischargedBDL - AIRCRAFT FAILED THE EMERGENCY LIGHTS TEST. MAINTENANCE REPLACED BATTERIES. OPERATIONALLY CHECKED OK. (M)SDR USAASA01023Power Supply · dischargedCLT - FOUND THE EMERGENCY EXIT LIGHTS FAILED TO ILLUMINATE, AT THE LEFT OVERWING EXIT AND OVERHEAD AISLE, WITH THE NO SMOKING LIGHTS SELECTED ON. THE LIGHTS CAME ON WHEN THE EMERGENCY LIGHTS WERE SWITCHED ON. MAINTENANCE REPLACED THE EMERGENCY POWER SUPPLY USDR USAASA01016Power Supply · inoperativeCLT - FOUND AN INOPERATIVE POWER SUPPLY UNIT DURING TEST. MAINTENANCE REPLACED THE INOPERATIVE EMERGENCY POWER SUPPLY UNIT. OPERATIONALLY CHECKS OK. (M)SDR USAASA01010Power Supply · dischargedTPA - THE AIRCRAFT FAILED THE EMERGENCY EXIT LIGHT TEST. MAINTENANCE REPLACED THE EMERGENCY POWER SUPPLY UNIT. SYSTEM TESTS NORMAL. (M)SDR USAASA01009Power Supply · inoperativeBOS - THE AIRCRAFT FAILED THE EMERGENCY EXIT LIGHT TEST. MAINTENANCE REPLACED THE LEFT OVERWING EMERGENCY POWER SUPPLY UNIT. OPS CHECKED OK. (M)SDR USAASA01008Sign · inoperativePHL-DEN - FLT 125 - THE EMERGENCY OVERWING EXIT LIGHT WAS FOUND INOPERATIVE. MAINTENANCE REPLACED THE EXIT SIGN ASSEMBLY. OPERATIONALLY CHECKED GOOD. (M)SDR USAASA00017Engine · overtempPHL/LAX - FLT 33 - AIRCRAFT INDICATED NR 1 ENGINE OVERTEMP AND OVERSPEED WARNINGS ON CLIMB-OUT. SHUT DOWN NR 1 ENGINE, DECLARED EMERGENCY, AND THEN RETURNED TO FIELD. FLIGHT LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED THE LEFT ENGINE ASSY. OPS CHECKED O
Back to N108UW