N901CF
Service difficulty reports not matched to an aircraft · 309
They name N901CF, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. 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 = 'N901CF' AND registry_match IS NULL 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 = 'N901CF' AND registry_match IS NULL 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 96ZZZX3594Pump · leakingPUMP LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH USED UNIT, CORRECTED PROBLEM.SDR 97ZZZX660Latch · wornHIGH PROFILE COWL LATCH WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX655Flex Beam · delaminatdFLEX BEAM BUMPER EXCESSIVE DELAMINATION. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX654Flex Beam · delaminatedFLEX BEAM BUMPER EXCESSIVE DELAMINATION. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX653Flex Beam · delaminatedFLEX BEAM BUMPER EXCESSIVE DELAMINATION. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX649Bearing · wornM/R CENTERING BEARING ELASTOMERICS WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX648Bearing · wornM/R CENTERING BEARING ELASTOMERICS WORN BEYOND SERVICEABLE LIMITS. DEBONDING. REPLACED WTIH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX647Bearing · wornM/R CENTERING BEARING ELASTOMERICS WORN BEYOND SERVICEABLE LIMITS. DEBONDING. REPLACED WWITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX646Bearing · wornM/R CENTERING BEARING ELASTOMERICS WORN BEYOND SERVICEABLE LIMITS. DEBONDING. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX659Latch · seizedLOW PROFILE COWL LATCH SEIZED. WILL NOT MOVE. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX650Bearing · wornM/R CENTERING BEARING ELASTOMERICS WORN BEYOND SERVICEABLE LIMITS. DEBONDING. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX807Bearing · wornBEARING JOURNAL WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH 4 EACH NEW UNITS, CORRECTED PROBLEM.SDR 97ZZZX674Latch · wornHIGH PROFILE COWL LATCH WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH 3 EACH NEW UNITS, CORRECTED PROBLEM.SDR 97ZZZX667Scissors · wornDRIVE SCISSORS WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX663Compression Pad · wornCOMPRESSION PAD WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3140Bearing · flat spotsTHRUST BEARING HAS FLAT SPOTS. REPLACED WITH 6 EACH NEW UNITS, CORRECTED PROBLEM.SDR 96ZZZX3136Transducer · defectiveTRANSDUCER UNIT CAUSES PRESSURE GAUGE TO FLUCTUATE 4 PERCENT TO 8 PERCENT. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX2939Thermocouple · failedTHERMOCOUPLE FAILED RESISTANCE CHECK. REPLACED WITH NEW 2 EACH UNITS, CORRECTED PROBLEM.SDR 96ZZZX3128Hose · wornHOSE WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3154Sensor · defectivePRESSURE SENSOR CAUSES PRESSURE GAUGE TO FLUCTUATE 10 PERCENT. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3153Flex Beam · defectiveFLEX BEAM BUMPER ASSY WRAPPING EXCESSIVELY SLIPPED IN THE AREA OF THE OUTBOARD APEX. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3152Flex Beam · defectiveFLEX BEAM BUMPER ASSY WRAPPING EXCESSIVELY SLIPPED IN THE AREA OF THE OUTBOARD APEX. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3151Flex Beam · defectiveFLEX BEAM BUMPER ASSY WRAPPING EXCESSIVELY SLIPPED IN THE AREA OF THE OUTBOARD APEX. REPLACED WIH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3150Flex Bam · defectiveFLEX BEAM BUMPER ASSY WRAPPING EXCESSIVELY SLIPPED IN THE AREA OF THE OUTBOARD APEX. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3149Flex Beam · defectiveFLEX BEAM BUMPER ASSY WRAPPING EXCESSIVELY SLIPPED IN THE AREA OF THE OUTBOARD APEX. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3142Sensor · fluctuatesPRESSURE SENSOR CAUSES PRESSURE GAUGE TO FLUCTUATE 10 PERCENT. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3139Bearing · wornTHRUST BEARING WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH 2 EACH NEW UNITS, CORRECTED PROBLEM.SDR 96ZZZX3138Bearing · wornTHRUST BEARING WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH 2 EACH NEW UNITS, CORRECTED PROBLEM.SDR 96ZZZX3148Display · inoperativeINSTRUMENT DISPLAY PRIMARY SIDE OF UNIT IS INOPERATIVE. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3155Transducer · defectivePRESSURE TRANSDUCER CAUSES PRESSURE GAUGE TO FLUCTUATE. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX1591Link Assy · wornEXCESSIVE PLAY IN LINK ASSY CAUSING MAIN ROTOR VIBRATION. INSTALLED NEW LINK ASSY PER INSTRUCTION FROM MIKE SUTT (MDHS FIELD SUPPORT).SDR 97ZZZX2474Eec · malfunctionELECTRONIC ENGINE CONTROL INSTALLATION. TROUBLESHOOTING SOFTWARE. EEC PUTTING OUT ERRATIC AND FALSE INFORMATION. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. CORES RETURNED TO MDHS FROM RNO.SDR 96ZZZX1584Nozzle Set · defectiveTROUBLESHOOTING LT ENGINE FOR HUNG START AT 38 PERCENT NG AND ALSO FAILED TO REACH IDLE RPM. REPLACED WITH NEW NOZZLE SET UNIT, CORRECTED PROBLEM.SDR 96ZZZX1583Nozzle Set · defectiveTROUBLESHOOTING LT ENGINE FOR HUNG START AT 38 PERCENT NG AND ALSO FAILED TO REACH IDLE RPM. REPLACED WITH NEW NOZZLE SET UNIT, CORRECTED PROBLEM.SDR 96ZZZX3262Impeller · wornIMPELLER WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3147Blade · defectiveM/R BLADE LOOSING PAINT. JOINT FILLER ERODING. ABRASION STRIP DEBONDING AT JOINTS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3146Blade · defectiveM/R BLADE LOOSING PAINT. JOINT FILLER ERODING. ABRASION STRIP DEBONDING AT JOINTS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3145Blade · defectiveM/R BLADE LOOSING PAINT. JOINT FILLER ERODING. ABRASION STRIP DEBONDING AT JOINTS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3144Blade · defectiveM/R BLADE LOOSING PAINT. JOINT FILLER ERODING. ABRASION STRIP DEBONDING AT JOINTS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3141Blade · defectiveM/R BLADE LOOSING PAINT. JOINT FILLER ERODING. ABRASION STRIP DEBONDING AT JOINTS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3133Switch · inoperativeRIGHT IPS BYPASS PRESSURE SWITCH INOPERATIVE. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3137Display · inoperativeINSTRUMENT DISPLAY UNIT INOPERATIVE. DISPLAY WILL NOT ILLUMINATE. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3132Scissors · wornSCISSORS WORN BEYOND SERVICEABLE LIMITS. CAUSING MR VIBRATION. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX1615Sensor · defectiveSENSOR UNIT CAUSES PRESSURE GAUGE TO FLUCTUATE. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3131Handle · wornDOOR HANDLE WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3143Sensor · fluctuatesPRESSURE SENSOR CAUSES PRESSURE GAUGE TO FLUCTUATE. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX1498Link Assy · wornLINK ASSY TEFLON LINERS WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX1495Igniter · wornIGNITER WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH 2 EACH NEW UNITS, CORRECTED PROBLEM.SDR 96ZZZX1490Compression Ring · looseCOMPRESSION RING LOOSENED UP WHICH CAUSED ENGINE LOW POWER. PWC HAS DEVELOPED AND WILL INSTALL ON THE ENGINE A RETROFIT KIT THAT INCORPORATES A DOWEL WHICH IS SUPPOSED TO RESTRICT MOVEMENT OF THE COMPRESSION RING.SDR 96ZZZX3130Pad · wornPAD WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNITS 4 EACH, CORRECTED PROBLEM.
Back to N901CF