N639RW
Service difficulty reports · 173
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 = 'N639RW' 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 = 'N639RW' 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 UHLA2010120700292Doubler · corrodedLEVEL 2 CORROSION FOUND UNDER WASTE SERVICE BOX ON INTERNAL DOUBLER. REMOVED AND REPLACED INTERNAL SKIN DOUBLER AT WASTE SERVICE DRAIN BOX IAW EMB 170 SRM 51-41-02.SDR UHLA2010120400294Skin · crackedMAJOR REPAIR - CRACK IN LT TRAILING EDGE WING SKIN APPROX 45MM O/B OF RIB 10 AND 14MM LONG. REPAIRED TRAILING EDGE WING IAW ETD 2010-170/11370.SDR UHLA2010120400291Pan · corrodedLEVEL 2 CORROSION ON CONDING PLATES, INTERNAL SIDE OF WASTE DRAIN VALVE BOX. REMOVED AND REPLACED SERVICE PAN IAW EMB 170 SRM 51-43-02.SDR UHLA2010120400290Seat Track · corrodedLEVEL 2 CORROSION RT SEAT TRACK UPPER SURFACE FR12-17. REMOVED AND INSTALLED NEW SEAT TRACK SECTION RT SIDE FR12-20 IAW EMB 170 SRM 51-40-02, 51-41-01, 51-41-02, 51-43-03, AND 51-43-04.SDR UHLA2010120400289Sill · corrodedLEVEL 2 CORROSION ON LT SILL FOR FR88-90. REMOVED AND REPLACED LT SILL IAW EMB 170 SRM 51-41-01.SDR UHLA2010120400288Gusset · corrodedLEVEL 2 CORROSION ON MIDDLE GUSSET ON FR90. REMOVED AND REPLACED GUSSET IAW EMB 170 SRM 51-40-02 AND 51-43-01.SDR UHLA2010120400287Gusset · corrodedLEVEL 2 CORROSION ON GUSSET ON RT MIDDLE I-BEAM ON FR90. REMOVED AND REPLACED GUSSET IAW EMB 170 SRM 51-40-02 AND 51-43-01.SDR UHLA2010120400286Gusset · corrodedLEVEL 2 CORROSION ON GUSSET ON RT MIDDLE I-BEAM ON FR89. REMOVED AND REPLACED GUSSET IAW EMB 170 SRM 51-43-01.SDR UHLA2010120400285Gusset · corrodedLEVEL 2 CORROSION ON GUSSET ON RT I-BEAM SUPPORT OF FR90. REMOVED AND REPLACED GUSSET IAW EMB 170 SRM 51-41-02.SDR UHLA2010120400284Sill · corrodedLEVEL 2 CORROSION RT SILL FROM FR88-90. REMOVED AND REPLACED RT SILL.SDR UHLA2010120400283Intercostal · corrodedLEVEL 2 CORROSION MIDDLE INTERCOSTAL ON FR 87. REMOVED AND REPLACED SHEAR PLATE IAW EMB 170 SRM 51-40-02.SDR UHLA2010120400282Intercostal · corrodedLEVEL 2 CORROSION RT INTERCOSTAL AT FR 87. REMOVED AND REPLACED SHEAR PLATE IAW EMB 170 SRM 51-42-01 AND 51-42-02.SDR UHLA2010120400281Intercostal · corrodedLEVEL 2 CORROSION LT INTERCOSTAL AT FR 87. REMOVED AND REPLACED SHEAR PLATE IAW EMB 170 SRM 51-40-02.SDR UHLA2010120400280Seat Track · corrodedLEVEL 2 CORROSION LT SEAT TRACK FLOORBEAM SURFACE AT FR16 TO FR19. REMOVED AND REPLACED SEAT TRACK FLOORBEAM ON LT SIDE FR17-20 IAW EMB 170 SRM 51-40-02, 51-43-03, AND 51-43-04.SDR UHLA2010120400279Sill · corrodedLEVEL 2 CORROSION RT SILL UPPER SURFACE FR12R TO FR14R. INSTALLED SERVICEABLE SILL PER EMB SRM 51-40-00.SDR UHLA2010120400268Gusset · corrodedLEVEL 2 CORROSION ON GUSSET OUTBOARD OF LT I-BEAM ON FR90. REMOVED AND REPLACED GUSSET IAW EMB 170 SRM 51-40-02.SDR UHLA2010120400266Gusset · corrodedLEVEL 2 CORROSION ON GUSSET ON RT MIDDLE I-BEAM BETWEEN FRAMES 85-86. REMOVED AND REPLACED GUSSET IAW EMB 170 SRM 51-41-01 AND 51-43-01.SDR UHLA2010120400265Seat Track · corrodedLEVEL 2 CORROSION ON MIDDLE RT I-BEAM FROM FR 87 TO 89. REMOVED AND REPLACED SEAT TRACK AT FR86 TO FR89 IAW EMB 170 SRM 51-41-01 AND 51-43-01.SDR UHLA2010111200203Duct · looseRECEIVED CAUTION MESSAGE CENTRAL EBAY FANS FAIL. FOLLOWED QRH, DIVERTED TO SBN. LANDED WITHOUT INCIDENT. ON CALL MAINTENANCE VERIFIED THAT FAN NR 1 IN MID EBAY WORKS. FERRIED AIRCRAFT TO IND. RE-SECURED LOOSE DUCT IN MID EBAY AND REMOVED AND REPLACED FLOWSDR UHLA2010072700081Control Unit · unserviceableIN CRUISE FLIGHT AT FL350 NUMEROUS MASTER CAUTIONS APPEARED: AOA LIMIT FAIL, SHAKER ANTICIPATED, FLAP FAIL, GRND PROX FAIL, WINDSHEAR FAIL, AT FAIL, AP FAIL, AND THERE WAS NO LONGER A FLAP POSITION INDICATOR. RAN THE APPROPRIATE CHECK LISTS AND LANDED WITH NSDR UHLA2009070800050Proximity Sensor · inoperativeUPON INITIAL CLIMB, CREW NOTED GEAR HANDLE WOULD NOT MOVE FROM THE GEAR DOWN POSITION. UNABLE TO RETRACT LANDING GEAR. RAN QRH AND DECLARED EMERGENCY. LANDED WITHOUT INCIDENT. AIRCRAFT WAS FERRIED TO CMH. MAINTENANCE REMOVED AND REPLACED THE NLG WOW NR 2 SDR UHLA2009012300019Landing Gear · malfunctionedAFTER TAKEOFF WITH A POSITIVE RATE OF CLIMB ESTABLISHED, WE ATTEMPTED TO RETRACT THE LANDING GEAR. THE LANDING GEAR HANDLE COULD NOT BE MOVED FROM THE DOWN POSITION. WE ATTEMPTED THIS SEVERAL TIMES WITH NO SUCCESS. WE DETERMINED THE BEST COURSE OF ACTION WASSDR 200609121Warning Message · illuminatedFLIGHT 7727 CMH TO DEN AT GEAR EXTENSION THE STEERING FAIL MESSAGE APPEARED ON EICAS. CREW ABORTED THE APPROACH AND RAN QRH AND DECLARED EMERGENCY. LANDED WITH NO EVENT. OCM RESET MAU 2 CIRCUIT WITH BREAKER.
Back to N639RW