N748UW
Service difficulty reports · 215
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 = 'N748UW' 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 = 'N748UW' 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 USAA2012020100006Floorbeam · corrodedC11 CHECK - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT FR16, Z-500, Y765. REPLACED FLOORBEAM AT FR16, Z-500, Y765 IAW A319 SRM 52-71-11 & AIRBUS DRAWING 53112812.SDR USAA2011071200002Hinge Fitting · wornT/R CHANGE - RIGHT MAIN LANDING GEAR DOOR FORWARD HINGE FITTING, FORWARD LUG HAS WEAR ON FORWARD FACE AT FR42, S32R. REPAIRED RIGHT MAIN LANDING GEAR DOOR FORWARD HINGE FITTING, FORWARD LUG IAW EA 200332 & JOB CARD 26T14753001.SDR USAA2010121793106Lens · missingFLT 1649 - DCA-TPA - EMERGENCY LIGHT - R2 DOOR EMERGENCY LIGHT LENS MISSING. REMOVED AND REPLACED EMERGENCY LIGHT LENS AT DOOR R2.SDR USAA2010040590712Pin · damagedFLT 1406 - PHL-BOS - EMERGENCY LIGHTS - EMERGENCY LIGHT AT PATHWAY SEATS 18(ABC) INOPERATIVE. REPLACE PIN IN CONNECTOR PLUG AND RECONNECTED CONNECTOR, OPERATIONAL CHECK WAS GOOD PER AMM 33-50-00.SDR USAA060524Beam · corrodedFR 68 Y1162 CORROSION. REPLACED BEAM PER SRM 51-72-11; CORR TASK JA-260-53500; LEVEL 1, DEFECT SIZE: 1 X 1 INCH.SDR USAA060525Dummy Rail · corrodedY-512 AT FRAMES 16-18 CORRODED. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-41-11; TASK JA-220-53500, LEVEL 1, DEFECT SIZE: 1 X 3 INCH.SDR USAA060526Sill · corrodedLEFT SILL AT FR 66 CORRODED. REMOVED CORROSION & INSTALLED REPAIR ANGLES PER SRM 53-41-14; CORR TASK JA-260-53500, LEVEL 1, DEFECT SIZE: 1 X 1 INCH.SDR USAA060527Floor Support · corrodedFLOOR SUPPORT Y-1162 AT CROSSBEAM C68 CORRODED. DEFECTIVE PART REPLACED WITH IDENT PART PER SRM 51-72-11; CORR TASK JA-900-0900; LEVEL 1, DEFECT SIZE: .75 INCH DIA.SDR SA05091Epsu · faultyPHL - THE FORWARD EMERGENCY POWER SUPPLY UNIT FAULTED DURING THE EMERGENCY LIGHTS TEST. MAINTENANCE REPLACED THE FORWARD EMERGENCY POWER SUPPLY UNIT. OPERATIONALLY CHECKS OK.SDR SA05041Power Supply · defectivePIT - RECEIVED FAULT MESSAGE EPSU INT LOAD FWD L DURING THE TEST OF THE EMERGENCY LIGHTS SYSTEM. MAINTENANCE REPLACED THE FORWARD CABIN EMERGENCY POWER SUPPLY UNIT. OPERATIONALLY CHECKS OK.SDR USAASA03138Battery · failedDCA - THE EMERGENCY LIGHTS TEST FAILED, WITH CIDS MESSAGE 'EPSU BATT FWD L'. MAINTENANCE REPLACED THE FORWARD LEFT POWER SUPPLY UNIT BATTERY. OPERATIONALLY CHECKS OK. (M)SDR USAASA03090Release Cable · incorrectPHL - FOUND AN INCORRECT RELEASE CABLE ON THE FORWARD RIGHT ESCAPE SLIDE DURING INSPECTION. MAITNENANCE REPLACED THE EMERGENCY ESCAPE SLIDE. OK FOR SERVICE. THE REPAIR SHOP INSTALLED THE PROPER RELEASE CABLE ON THE SLIDE AND RETURNED THE SLIDE TO SERVICE. SDR USAASA03091Release Cable · incorrectPHL - FOUND AN INCORRECT RELEASE CABLE ON THE FORWARD LEFT ESCAPE SLIDE DURING INSPECTION. MAINTENANCE REPLACED THE EMERGENCY ESCAPE SLIDE. OK FOR SERVICE. THE REPAIR SHOP INSTALLED THE PROPER RELEASE CABLE ON THE SLIDE AND RETURNED THE SLIDE TO SERVICE. (SDR USAASA02116Power Supply · dischargedTPA - THE CABIN INTERCOMMUNICATIONS DATA SYSTEM EMERGENCY LIGHT TEST GAVE "EPSU R FAULT" MESSAGE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT, FIN 12WL. OPERATIONALLY CHECKS OK. (M)SDR USAASA02005Blower · malfunctionedPHL - FLT 2249 - EN ROUTE PHL-PVD - DURING CLIMB-OUT, A STRONG, PUNGENT ODOR BECAME PRESENT IN BOTH THE COCKPIT AND CABIN, ACCOMPANIED BY A STRONG VIBRATION. THE VIBRATION STOPPED WHEN THE ECAM WARNING, 'BLOWER FAULT' ANNUNCIATED. THE FLIGHT RETURNED TO THE
Back to N748UW