N740UW
Service difficulty reports · 258
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 = 'N740UW' 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 = 'N740UW' 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 USAA051256Beam · corrodedFOUND Y1292 FS 66, DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 53-41-04, DEFECT SIZE: 2" BY 30".SDR USAA051255Beam · corrodedFOUND BEAM CORRODED Y1162 - 1292 FS 66-68, DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 53-41-04, DEFECT SIZE: 2' BY 10".SDR USAA051254Strut · corrodedFOUND CORROSION UPPER HINGE OF NOSE LANDING GEAR TORQUE LINK, HINGE BORE. MESSIER DOWTY CMM 32-27-20 PG 609, DEFECT SIZE: 1-1/4" BY .008" DEEP; CORROSION LEVEL 1; TASK JA-74-32500.SDR USAA051253Floor Support · corrodedFOUND CORROSION BETWEEN FRAME 64 AND 66 AT 765. DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 51-12-11, DEFECT SIZE: 2" BY 36" BY .100"SDR USAA051252Floorbeam · corrodedFOUND CORROSION UPPER SURF FLOORBEAM Y503.2 STA 14 - 16; CORROSION LEVEL 1; TASK JA-220-53500. DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 53-11-14, DEFECT SIZE: 1/2" BY 4" AREA.SDR USAA051251Frame · corrodedFOUND FRAME CORRODED, A FRAME C-16 -Y50. CORROSION LEVEL 1; TASK JA-220-53500. REPLACED BEAM PER SRM 51-72-11, DEFECT SIZE: 2" BY 2" AND 2" BY 2" CORROSION.SDR USAA051257Beam · corrodedFOUND CORROSION Y1162 FS 68, DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 53-41-04, DEFECT SIZE: 2" BY 21".SDR USAASA04010Slide · deployedPRIOR TO DEPARTURE, THE MAIN ENTRY DOOR WAS OPENED WHILE THE SLIDE WAS ARMED. THE SLIDE DID NOT INFLATE. MAINTENANCE REMOVED THE SLIDE AND DEPLETED THE AIR PRESSURE FROM THE CYLINDER. AIRCRAFT FERRIED FOR MAINTENANCE TO PIT. THE SLIDE WAS REPLACED. IN THE
Back to N740UW