N39PH, cancelled Sep 4, 2019
Service difficulty reports · 34
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 = 'N39PH' AND deregistration_id = 'N39PH-2019-09-04' 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 = 'N39PH' AND deregistration_id = 'N39PH-2019-09-04' 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 2011F00030Actuator · failedDURING LANDING, THE PILOT HEARD A LOUD POP IN THE NOSE GEAR BAY AND THE NLG WOULD NOT EXTEND , AFTER TRYING SEVERAL TIMES TO EXTEND THE GEAR INCLUDING EMERGENCY EXTENSION THE PILOT DECIDED TO LAND WITH THE NOSE GEAR UP AND THE MAIN GEAR DOWN , JUST BEFORE TOUCSDR HEEA065142Transmitter · intermittentTRANSMITTER HAD INTERMITTENT FUEL FLOW READINGS.SDR HEEA0015914Inverter · failedINVERTER DROPS OFF LINE THEN COMES BACK ON IN-FLIGHT.SDR HEEA0015414Tach Gen · fluctuatesAT 200 TO 250 RPM, PROP FLUCTUATES, INDICATION ONLY.SDR HEEA0014905Radio Altimeter · intermittentALTIMETER INTERMITTENT FLAG 2,000 FEET.SDR HEEA0014903Valve · malfunctionedVALVE WOULD NOT HOLD CABIN ALTITUDE WITH NR 2 FLOWPACK CUT OFF.SDR HEEA0014893Valve · inoperativeOUT CROSSFEED ON VALVE INOPERATIVE RIGHT TO LEFT.SDR HEEA0014553Indicator · sticksTACHOMETER STICKS AT 10-15 PERCENT ON SHUT DOWN.SDR HEEA0014527Indicator · sticksTOT INDICATOR STICKS AT OR ABOVE 700C ON START.SDR HEEA0013804Inverter · failedINVERTER WILL NOT COME ON LINE. WORKED FOR ONE HOUR AFTER CLEANING CANNON PLUG.SDR HEEA0013775Hub · leakingBLADE GRIP SEALS LEAKING GREASE. LOOSE DEVICE SLIP RING.SDR HEEA0013512Gps · defectiveSELECTOR KNOB SKIPS DIGITS AND LETTERS WHEN TRYING TO SELECT.SDR HEEA0012453Cvr · failedCVR WILL NOT TEST.SDR HEEA0012180Skynav 5000 · failedCOULD NOT SELECT AIRPORTS, NDRS, ETC.SDR HEEA0011179Antenna Loop · corrodedCORROSION ON ANTENNA. WEAK SIGNAL. SENT TO COLLINS AVIONICS FOR INSPECTION AND REPAIR.SDR HAIHEEA9982Artificial Horiz · defectiveARTIFICIAL HORIZ WILL NOT MAINTAIN ATTITUDE WITH INST. AIR APPLIED.SDR HAIHEEA9310Indicator · fluxuatesINDICATOR FLUCTUATES 20-40 DEGREES IN FLIGHT.SDR HEEA968310Indicator · sticksVSI STICKS IN CLIMB AND DESCENT.SDR HEEA967713Indicator · malfunctionVERTICAL ORANGE LINES IN ALL RANGE SETTINGS.SDR HEEA967515Actuator · defectiveSPIRAL DISC SWITCH LEVER HAS EXCESSIVE PLAY.SDR HEEA967355Gyro · defectiveWAIT AND ANT LIGHT COMES ON WHEN STABILIZATION MODE IS SELECTED.SDR HEEA967199Alerter · erraticERRATIC ALERTING, IT MIGHT TRIP 1000 FEET ABOVE OR BELOW. OR ANYWHERE IN BETWEEN. TIME SINCE REPAIR 176:40.SDR HEEA967166Transmitter · defectiveERRATIC FUEL FLOW.SDR HEEA967142Skynav 5000 · malfunctionGPS UNIT DOES NOT HOLD ENTERED DATA.SDR HEEA966968Vane Ring · crackedCRACKED POWER TURBINE 2ND STAGE VANE RING.SDR HEEA966622Alerter · damagedHARD SPOTS DURING RUN UP AND RUN DOWN. FACEPLATE IS CRACKED.SDR HEEA966453Altimeter · erraticRADIO ALTIMETER ERRATIC ALTITUDE READOUT.SDR HEEA966423Indicator · inoperativeDEAD NEEDLE; CONTINUOUS FLAG. TIME SINCE REPAIR 4:00.SDR HEEA955875Indicator · defectiveBLUE SCREEN ON INDICATOR, ANTENNA LIGHT AND INTERMITTENT ON TAKE OFF.SDR HEEA955444Altimeter · defectiveENCODER HAS NO VALID OUTPUT. TIME SINCE REPAIR 187:40.SDR HEEA954987Skynav 5000 · defectiveSKYNAV 5000 HAS LOOSE PART INSIDE CABINET. ON FIRST POWER UP, DISPLAY LOCKED UP. FOUND BROKEN PIECE OF DATA CARD READER.SDR HEEA954884Hub · making metal#2 ENGINE MAKING METAL. TARGET SCREWS MISSING IN DEICE SLIP RING.SDR HEEA954713Cvr · defectiveBEGAN TRANSCRIBING TAPE AND FOUND CVR TO DIE AFTER 30-45 SECONDS OF OPERATION.SDR HEEA954355Transducer · inoperativeZERO OUTPUT WITH POWER AND PRESSURE APPLIED.
Back to N39PH, cancelled Sep 4, 2019