N939UW
Service difficulty reports · 156
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 = 'N939UW' 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 = 'N939UW' 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 USAABB08167Flashlight · inoperativeSEA - THE AFT FLIGHT ATTENDANT, OUTBOARD POSITION FLASHLIGHT WAS INOPERATIVE. MAINTENANCE REPLACED THE AFT FLIGHT ATTENDANT, OUTBOARD POSITION FLASHLIGHT.SDR USAA920081262Flap · delaminatedCLT - C-22 - MAJOR REPAIR - FOUND DELAMINATION ON LEFT OUTBOARD AFT FLAP MEASURES 4"X4.5", 5.5" FORWARD OF TRAILING EDGE. REPAIRED DELAMINATION ON LEFT OUTBOARD AFT FLAP 4"X4.5" AREA., 5.5" FORWARD OF TRAILING EDGE IAW B757 SRM 57-53-01. (S)SDR BB08104Megaphone · damagedMCO - THE AFT MEGAPHONE WAS FOUND DAMAGED AND INOPERATIVE. MAINTENANCE REPLACED THE AFT MEGAPHONE. OPERATIONALLY CHECKS OK.SDR USAA920070793Skin · crackedBMH - MAJOR REPAIR - C-4 CHECK - NR 6000784, RIGHT WING LEADING EDGE SLAT NR 9 INNER SKIN CRACKED, WS 623.5. REPLACED RIGHT WING LEADING EDGE SLAT NR 9 INNER SKIN CRACKED, WS 623.5 IAW B757 SRM 51-40-02.SDR USAA920070792Floorbeam · corrodedBFM - MAJOR REPAIR - C-4 CHECK - NR 6000701, CORROSION ON CABIN FLOORBEAM, BS 365, RBL 20 - RBL 25, WL 208. REPAIRED CABIN FLOORBEAM, BS 365, RBL 20 - RBL 25, WL 208 IAW USAIRWAYS TYPICAL REPAIR 53-15-01.SDR BB07002Fuse · blownR4 DOOR EXTERIOR EMERGENCY LIGHT FOUND INOPERATIVE. MAINTENANCE REPLACED THE FUSE AND RELAMPED.
Back to N939UW