Piper PA-34-200
Service difficulty reports · 203
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = 'PA34200' 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 aircraft_model_key = 'PA34200' 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 95ZZZX2380Rib · crackedTHIS RIB IS LOCATED AT STA 49.25, IN THE MAIN LANDING GEAR WELLS. FOUND 3 SENECA'S WHERE THIS RIB HAS BEEN CRACKED IN THE RADIUS OF THE OUTBOARD ANGLE UNDER THE DRAG BRACE SUPPORT. PIPER PA-28R HAS THIS SAME PROBLEM. SUSPECT THE CAUSE IS FROM HARD OR GRASS SDR 95ZZZX1881Hinge Pin · deterioratedNEOPRENE HINGE PIN FAILED DUE TO WEATHERING. THE HINGE DID NOT FAIL OR WEAR, ONLY THE PIN. SUBMITTER SUGGESTS A TIME PERIOD SHOULD BE REQUIRED FOR MANDATORY REPLACEMENT OF NEOPRENE COVERED PINS. FEEL THIS SHOULD ONLY BE IMPOSED ON THE INDIVIDUAL ITEM. THE SDR 95ZZZX1159Coil · crackedDURING INSPECTION PER CUSTOMER INSTRUCTIONS, COIL CRACK WAS NOTED. REMOVED AND TESTED COIL. FOUND HIGH VOLTAGE LEAK OUT FROM CRACK. SUSPECT CAUSE MAY BE FROM MANUFACTURE DATE STAMP IN INSULATION. CRACK LOCATION ABOUT 1 INCH FROM OUTPUT TAB.
Back to Piper PA-34-200