N185UW
Service difficulty reports · 310
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 = 'N185UW' 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 = 'N185UW' 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 USAA2009102692868Lens · missingFLT 1548 - SEA-PHL - EMERGENCY LIGHTS - RED EMERGENCY LIGHT LENS AT SEAT 10C IS MISSING. REPLACED EMERGENCY LIGHT LENS AT SEAT 10C. OPERATIONAL CHECK WAS GOOD.SDR USAA2009092392599Lens · missingFLT 1779 - LAS - EEL - 10L EMERGENCY LIGHT LENS MISSING. MAINTENANCE REPLACED EMERGENCY LIGHT LENS AT 10L.SDR USAA070709Beam · corrodedTHE 1162/1292 BEAM SEGMENT BETWEEN FR C66 & 68 HAS CORROSION. PART REPLACED WITH LIKE PART PER SRM 53-41-14; CORR TASK JA-260-53500, DEFECT SIZE: 1 INCH SQ (2 EA).SDR USAA070708Shear Plate · corrodedRIGHT LATERAL SHEAR PLATE BETWEEN FR 69 & 70 HAS CORROSION. DEFECTIVE PART REPLACED WITH IDENTICAL PART; CORR TASK JA-260-53500, DEFECT SIZE: 2" X 3".SDR USAA070707Skin · damagedFR 76 - 77 BETWEEN STRINGERS R36-37 HAS CREASE. CUT OUT DAMAGE & INSTALLED DOUBLER PER SRM 53-00-11 FIG 203, DEFECT SIZE: 2.5" X 1" X .125".SDR USAA070710Beam · corrodedY1292 BEAM BETWEEN FR C68 & 69 HAS CORROSION.SDR USA2007F00012Skin · corrodedCORRODED RIVET TAILS WERE FOUND IN THE FUSELAGE FORWARD CARGO COMPARTMENT BETWEEN FRAME28 TO 35.5 STRINGER 38R TO 38L. APPROX 450 RIVETS WERE REPLACED. A RESIDUE OF SODIUM CHLORIDE ATTACKED THE RIVETS. NUMEROUS OTHER RIVETS HAD THE PAINT FLAKING OFF THE RIVSDR SA06072Engine · shutdownFLT1408 - DURING CRUISE, EN ROUTE FROM SFO TO CLT, CREW RECEIVED ECAM MESSAGE "ENG 2 HI TEMP FADEC OVHT" AND "ENG 2 FADEC B FAULT" ALONG WITH OTHER ASSOCIATED FAULT MESSAGES. CIRCUIT BREAKER FOR ENG 2 FADEC TRIPPED, AND MOMENTS LATER, THE NR 2 ENGINE AUTOMATISDR USAASA07010Charger · inoperativeBDL - THE EMERGENCY LIGHT CHARGER UNIT, FIN 11WL, AT THE MID CABIN WAS FOUND INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY POWER SUPPLY UNIT AND BATTERY. OPERATIONALLY CHECKS OK.SDR SA05122Battery Pack · dischargedTHE LT FORWARD EMERGENCY LIGHT BATTERY PACK FAILED TEST. MAINTENANCE REPLACED THE LT FORWARD BATTERY PACK. OPERATIONALLY CHECKS OK.
Back to N185UW