N109UW
Service difficulty reports · 207
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 = 'N109UW' 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 = 'N109UW' 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 USAASA05058Epsu · faultyTHE AFT LEFT EMERGENCY POWER SUPPLY UNIT FAILED THE EMERGENCY LIGHTS TEST. MAINTENANCE REPLACED THE AFT POWER SUPPLY UNIT.SDR SA05046Landing Gear · malfunctionedLAX FLT 1 EN-ROUTE PIT TO LAX, DURING APROACH, THE LANDING GEAR DID NOT INDICATE DOWN AND LOCKED. THE FLT PERFORMED A GO-AROUND, AND THEN MANUALLY EXTENDED THE LANDING GEAR. THE AIRCRAFT LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE PERFORMED TROUBLESHOOTINSDR SA04103Slide · wornDURING TROUBLESHOOTING, MAINTENANCE FOUND THE AFT LEFT PASSENGER DOOR SLIDE LACING WORN ALMOST ALL THE WAY THROUGH. MAINTENANCE REPLACED THE AFT LEFT DOOR SLIDE. OK FOR SERVICE.SDR SA04102Diaphragm · crackedTHE AFT LEFT PASSENGER DOOR WILL NOT OPEN FROM INSIDE OR OUTSIDE. MAINTENANCE FOUND THE DOOR ASSIST DAMPER PRESSURIZED BY A CRACKED SEAL. MAINTENANCE REPLACED THE CRACKED SEAL. OPERATIONALLY CHECKS OK.SDR USA2004F00012Battery · dischargedTHE RT SIDE MID-CABIN EMERGENCY LIGHT BATTERY FAULTED DURING TEST. MAINTENANCE REPLACED THE RT SIDE MID-CABIN EMERGENCY LIGHT BATTERY. OPERATIONALLY CHECKS OK.SDR USAASA01051Brake · overheatedDEN - FLT 183 - EN ROUTE PHL-DEN, AFTER TAKEOFF AND LANDING GEAR RETRACTION, THE NR 2 BRAKE WENT FROM 300 TO 500 DEGREES IN SEVERAL SECONDS TIME. THE LANDING GEAR WAS LOWERED AND THE BRAKE FAN ACTIVATED. THE BRAKE TEMPERATURE THEN DECREASED TO BELOW 100 DEGRSDR USAASA00004Slide · will not testCLT - THE CREW INADVERTENTLY ACTIVATED THE FORWARD ENTRY DOOR SLIDE ON ARRIVAL AT THE GATE. THE SLIDE FAILED TO DEPLOY. MAINTENANCE REPLACED AND RIGGED THE SLIDE ASSEMBLY. (M)
Back to N109UW