N127UW
Service difficulty reports · 109
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 = 'N127UW' 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 = 'N127UW' 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 USAA2013111200001Light · inoperativeCREW REPORTED ACFT RT OVERWING EXITS, EXIT LIGHT INOPERATIVE. MAINTENANCE REPLACED LIGHT ASSEMBLY. CHECKED GOOD IAW 33-51-16.SDR USAA2013110700003Flashlight · inoperativeCREW REPORTED THE FORWARD FLASHLIGHT NOT BLINKING. MAINTENANCE R & R FORWARD FLASHLIGHT IAW AMM 25-65-53.SDR USAA2013072300005Knob · missingWHILE ACCOMPLISHING J/C 26L00005005 ARBS WEEKLY CHECK FOUND AFT MEGAPHONE MISSING. VOLUME CONTROL KNOB MISSING. REPLACED MEGAPHONE.SDR USAA2013062600002Lens · missingROW 1, ACFT EMERGENCY LIGHT (CLEAR) LENS MISSING. INSTALLED NEW LIGHT AT ROW 1.SDR USAA2013050600008Slide · damagedR-1 DOOR SLIDE GIRT BAR STRAP BROKEN. REMOVED AND REPLACED R1 DOOR ESCAPE SLIDE.SDR USAA2013032000005Lens · brokenROW 7 EMERGENCY LIGHT LENS CAP BROKEN. REPLACED LIGHT ASSEMBLY.SDR USAA2012061100019Lens · missingAIRCRAFT DOOR 2L MISSING EXIT LIGHT COVER. INSTALLED MISSING LENS COVER AT DOOR 2L.SDR USAA2012052900037Lens · brokenL3 EMERGENCY LIGHT LENS BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT AT L3. OPS CHECKED GOOD.SDR USAA2012020800019Light · brokenRED EMERGENCY EXIT LIGHT ROW 9 LEFT BROKEN. REPLACED EMERGENCY EXIT SEAT MOUNTED LIGHT AT 9 LT IAW AIRBUS MAINTENANCE MANUAL 33-51-18.
Back to N127UW