N927UW
Service difficulty reports · 114
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 = 'N927UW' 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 = 'N927UW' 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 AALA201711309015Cylinder · low pressureR4 DOOR DAMPER CYLINDER PRESSURE IS BELOW THE GREEN BAND. SERVICED THE CYLINDER IAW AMM 52-10-00. OPS CHECKED GOOD.SDR AALA201711019022Handle · out of adjustTOP STRIKER PLATE OF COCKPIT DOOR DOES NOT MAINTAIN ADEQUATE PRESSURE TO KEEP DOOR OPEN LIGHT EXTINGUISHED. ADJUSTED DOOR HANDLE IAW AMM.SDR AALA201705109007Actuator · faultyDURING CLIMBOUT, THE ECAM FUEL LEFT CENTER TANK TRANSFER FAULT. IAW ECAM SELECTED MAN MODE OPS NORMAL. REPLACED LEFT CONTROL TANK FUEL CONTROL VALVE ACTUATOR.SDR AALA201705089016Lens · brokenAIRCRAFT NOT GROUNDED. AFT CABIN RT DOOR WALL MOUNTED EMERGENCY EXIT LIGHT LENS FOUND BROKEN. REPLACED CABIN AFT RT DOOR WALL MOUNTED EMERGENCY EXIT LIGHT LENS.SDR AALA201704129014Bottle · low pressureR4 DOOR ASSIST BOTTLE PRESSURE LOW. SERVICED THE DOOR BOTTLE.SDR AALA201704049008Lens · brokenEMERGENCY LIGHT LENS BROKEN NEAR L4. REPLACED THE LENS.SDR AALA201702079009Lens · brokenEXIT LIGHT LENS BROKEN AT R4 DOOR. REPLACED THE LENS.SDR AALA201701269024Cylinder · low pressureR4 DOOR ASSIST CYLINDER IS NOT IN GREEN BAND. SERVICED R4 DOOR CYLINDER IAW AMM TASK 52-10-00-614-001.SDR AALA201611039006Cover · missingMISSING LENS COVER ON R4 DOOR EXIT LIGHT. INSTALLED LENS COVER PER AMM 33-51-00.SDR AALA201610149017Diaphragm · leakingDOOR 2L PRESS LOW LIGHT FOR PNEUMATIC ASSIST INDICATION. REPLACED DOOR DAMPER DIAPHRAGM REF AMM TASK 52-22-00-860-002 AND SERVICED N2. OK FOR SERVICE. CLEARED MICS. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201610139026Bottle · low pressureL-2 DOOR HAS LOW PRESSURE, ORANGE LIGHT ILLUMINATED WHEN ARMED. FOUND L-2 DOOR ASSIST BOTTLE PRESS LOW. SERVICED DOOR BOTTLE IAW AMM 52-10-00. LEAK CK GOOD. MSG CLEARED. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201610029010Accumulator · low pressureR4 DOOR EMERGENCY CYLINDER ACCUMULATOR HAS LOW PRESSURE. SERVICED ACCUMULATOR IAW AMM 52-10-00.SDR AALA201607259002Battery · failedAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT AT THE L3 DOOR FAILED TEST. REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-38.SDR AALA201511239013Cap · missingCOVER PLATE MISSING, ESCAPE PATH LIGHTING WIRING COVER PLATE, PROTECTION CAP, AT 3L DOOR. REPLACED MISSING COVER, PROTECTION CAP, ON ESCAPE PATH WIRING.
Back to N927UW