N733UW
Service difficulty reports · 308
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 = 'N733UW' 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 = 'N733UW' 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 USAA051110Shear Tie · corrodedFOUND CORROSION BETWEEN FRAME 69 AND 70 TO RT SIDE. REMOVED AND REPLACED WITH DEFECTIVE PART NR PER SRM 51-72-11, DEFECT SIZE: 3" X 4".SDR USAA051121Shear Tie · corrodedLT SHEAR TIE CORRODED BETWEEN FRAME 69 AND 70. REMOVED AND REPLACED PART WITH NEW PER 51-72-11, DEFECT SIZE: .05" X 1" AREA.SDR USAA051123Floor Support · corrodedFOUND CORROSION TOP OF FLOOR SUPPORT/BEAM Y254 AT FRAME C19. CUT OUT DAMAGE, INSTALLED FILLER AND REPAIR ANGLES PER SRM 53-00-14 PG 222, 224 FIG 204.SDR SA05025Windshield · crackedDEN - FLIGHT 1 EN-ROUTE PIT TO LAX. DURING FLIGHT, THE FIRST OFFICER'S WINDOW BEGAN TO CRACK. THE CREW PULLED THE WINDSHIELD HEAT CIRCUIT BREAKER AND DIVERTED TO DEN. THE FLIGHT LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED THE FIRST OFFICER'S WINDSDR SA05021Sensor · faultyCLT - FLT 458 EN-ROUTE LIR - CLT. AFTER TAKEOFF, THE NR ONE MAIN BRAKE INDICATED INTERMITTENT OVERHEAT, FROM 200 - 800 DEGREE CELSIUS. THE CREW LOWERED THE GEAR TO COOL THE BRAKES. WHEN THE TEMPERATURES STABILIZED TO 135 DEGREE CELSIUS, THE CREW RAISED THESDR USAASA03038Power Supply · inoperativeDCA - AIRCRAFT FAILED THE EMERGENCY LIGHTS TEST. MAINTENANCE REPLACED THE EMERGENCY POWER SUPPLY UNIT IN THE AFT POSITION. OPERATIONALLY CHECKS OK. (M)SDR USAASA02097Battery Pack · dischargedPIT - THE LEFT EMERGENCY POWER SUPPLY UNIT FAULTED DURING THE EMERGENCY LIGHTS TEST. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY BATTERY PACK. OPERATIONALLY CHECK OK. (M)SDR USAASA02087Odor · detectedMSY - FLT 289 - EN ROUTE DCA-MSY, DURING DESCENT INTO MSY, AN ODOR BECAME PRESENT IN BOTH THE COCKPIT AND CABIN. FLIGHT LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE INSPECTED THE ELECTRONICS BAYS AND CABIN FOR ODORS. NONE WERE FOUND. THE ENGINES AND PACK W
Back to N733UW