N721UW
Service difficulty reports · 271
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 = 'N721UW' 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 = 'N721UW' 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 USAA2010062191185Battery · dischargedFLT 1897-ATL - EEL - FORWARD CABIN EMERGENCY FLASHLIGHT INOPERATIVE - SEAL BROKEN. MAINTENANCE REMOVED AND REPLACED FORWARD CABIN FLASHLIGHT BATTERY AND SEAL.SDR USAA2010010490002Cylinder · low pressureFLT 1968 - SJU-BOS - EMERGENCY EGRESS SYSTEM - L1 DOOR EMERGENCY CYLINDER NEEDS SERVICE. SERVICED L1 DOOR EMERGENCY CYLINDER PER AMM 52-10-00-614.SDR USAA2009102192821Lens · missingFLT 1403 - BOS-PHL - EMERGENCY LIGHTS - EMERGENCY LIGHT LENS MISSING ROW 10 AIRCRAFT RIGHT. INSTALLED NEW EMERGENCY LIGHT LENS. OPERATIONAL CHECK WAS GOOD.SDR USAA2009081392107Lug · corrodedPIT - LRN GEAR CHANGE - MAJOR REPAIR - RIGHT MAIN LANDING GEAR RIB 5 FORWARD LUG HAS CORROSION. REWORKED LUG IAW EA 113314.SDR USAA2009081392106Lug · corrodedPIT - LRN GEAR CHANGE - MAJOR REPAIR - LEFT MAIN LANDING GEAR RIB 5 FORWARD LUG HAS CORROSION. REWORKED LUG IAW EA 113313.SDR USAA050792Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED .5 INCH BY .75 INCH, Y1292 FRAME 64-67. DEFECTIVE PART REPLACED WITH IDENT PART. (M)SDR USAA050791Shear Tie · corrodedPIT - FOUND SHEAR TIE CORRODED 1 INCH BY 1 INCH AREA, BETWEEN FRAME 69 RIGHT, FRAME 70 RIGHT. DEFECTIVE PART REPLACED WITH IDENT PART. CORROSION LEVEL 2, TASK JA-260-53500. (M)SDR USAA050790Floor Support · corrodedPIT - FOUND FLOOR SUPPORT BEAM CORRODED 1.5 INCH BY .75 INCH AREA, -Y1050 FRAME 67 AND 68. DEFECTIVE PART REPLACED WITH IDENT PART. CORROSION LEVEL 2, TASK JA-260-53500. (M)SDR USAA050788Sill · corrodedFOUND SILL PLATE CORRODED 1 INCH BY 3 INCH AREA, FRAME 66, COMMON TO SILL PLATE. ACCOMPLISHED SRM REPAIR 53-41-14 FIG 201 SHT 4, REPAIR PRINCIPLE 6. CORROSION LEVEL 2, TASK JA-260-53500. (M)SDR USAA050787Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED 1.5 INCH BY 4 INCHES, CABIN FLOORBEAM Y1292 AT FRAME 18. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-42-00, 51-43-00, 51-72-11. CORROSION LEVEL 1, TASK JA-220-53500. (M)SDR USAA050789Floor Support · corrodedPIT - FOUND FLOOR SUPPORT CORRODED .5 INCH BY .5 INCH AREA, CABIN FLOOR SUPPORT Y254 AT FRAME 16. REMOVED AND REPLACED FLOOR SUPPORT PER SRM 53-11-14. (M)SDR SA05048Seal · cutCLT - FLT 1449 ENROUTE CLT - PLS, AFTER TAKEOFF, A LOUD AIR LEAK NOISE GENERATED FROM THE MAIN ENTRANCE DOOR. THE FLIGHT RETURNED AND LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED THE FORWARD LEFT ENTRANCE DOOR SEAL, AND SEAL RETAINER A THE LOWER AFTSDR SA05026Windshield · crackedCLT - FLT 200 EN-ROUTE MSP TO CLT, DURING FLIGHT, THE FIRST OFFICER'S WINDSHIELD BEGAN TO ARC, AND THEN CRACK. CREW PULLED THE CIRCUIT BREAKER FOR THE WINDSHIELD ANTI-ICE HEAT AND DESCENDED TO FL 230. FLIGHT CONTINUED TO CLT WITHOUT FURTHER INCIDENT. MAINTSDR SA04099Battery Pack · dischargedBOS - THE FORWARD EMERGENCY POWER SUPPLY UNIT FAILED TEST. MAINTENANCE REPLACED THE FORWARD EMERGENCY POWER SUPPLY UNIT BATTERY.SDR SA04098Warning Light · intermittentMSY - FLIGHT 972 ENROUTE MSY-PHL, AFTER TAKEOFF, A FORWARD CARGO SMOKE WARNING CAME ON INTERMITTENTLY. FLIGHT RETURNED TO FIELD AND LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE PERFORMED AN OPERATIONAL TEST. THE SYSTEM OPERATIONALLY CHECKED OK.SDR USA2004F00059Power Supply · faultyTHE AFT LEFT EMERGENCY POWER SUPPLY UNIT FAILED TESTING. MAINTENANCE REMOVED AND REPLACED THE AFT LEFT EMERGENCY POWER SUPPLY UNIT. OPERATIONALLY CHECKS OK.SDR USAASA04038Psu · inoperativeTHE EMERGENCY LIGHTS FAILED TEST. MAINTENANCE REPLACED THE AFT EMERGENCY POWER SUPPLY UNIT. OPS CHECKS OK. (M)SDR USAASA04037Psu · inoperativeTHE EMERGENCY LIGHTS FAILED TEST. MAINTENANCE REPLACED THE FORWARD EMERGENCY POWER SUPPLY UNIT. OPERATIONALLY CHECKS OK. (M)SDR USAASA02017Connector · dirtyDCA- RECEIVED, 'EPSU EXT LOAD AFT L', MESSAGE, WHEN PERFORMING THE EMERGENCY LIGHTS TEST. MAINTENANCE CLEANED AND RESECURED THE AFT LEFT DOOR SLIDE CONNECTOR. SYSTEM BITE CHECKS OK. (M)SDR USAASA01050Power Supply · failedPIT - THE LEFT CENTER CABIN EMERGENCY POWER SUPPLY UNIT FAILED THE CABIN INTERCOMMUNICATION DATA SYSTEM TEST. MAINTENANCE REPLACED THE EMERGENCY LIGHT POWER SUPPLY. TESTS OK. (M)SDR USAASA01031Connector · loosePIT - THE EMERGENCY LIGHTS TEST FAILED ON THE WEEKLY CHECK. MAINTENANCE SECURED A LOOSE CONNECTOR ON THE L1 DOOR SLIDE. THE SYSTEM TESTED OK FOR SERVICE. (M)
Back to N721UW