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 97ZZZX4083Metering Unit · defectiveFUEL METERING UNIT INSTALLATION DEFECT. EGT AND TORQUE FLUCTUATIONS. REMOVED FROM LOANER ENGINE. CORE SHIPPED FROM RNO TO PLANT 12 ON 4-10-97. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2472Bearing · seizedTHRUSTER BUILD-UP ASSEMBLY SEIZED. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. CORES RETURNED TO MDHS FROM RNO.SDR 97ZZZX2470Rotating Cone · wornTHRUSTER BUILD-UP INSTALLATION. WORN RING. REPLACED WITH USED UNIT, CORRECTED PROBLEM. CORES RETURNED TO MDHS FROM RNO.SDR 97ZZZX2468Pulley · groovedTHRUSTER BUILD-UP ASSEMBLY PULLEY UNIT EXCESSIVELY GROOVED. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. CORES RETURNED TO MDHS FROM RNO.SDR 97ZZZX2467Sector Assy · stiffTHRUSTER BUILD-UP ASSEMBLY SECTOR STIFF. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. CORES RETURNED TO MDHS FROM RNO.SDR 97ZZZX2460Impeller · shaft playDRIVE/TRANSMISSION SYS BLOWER IMPELLER EXCESSIVE PLAY. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. CORES RETURNED TO MDHS FROM RNO.SDR 97ZZZX2457Pinion Assy · leakingTRANSMISSION ASSY INPUT PINION ASSY LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. CORES RETURNED TO MDHS FROM RNO.SDR 97ZZZX2456Pinion Assy · leakingTRANSMISSION ASSY INPUT PINION ASSY LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. CORES RETURNED TO MDHS FROM RNO.SDR 97ZZZX2451Latch · stiffCOWL LATCH STIFF. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. CORES RETURNED TO MDHS FROM RNO.SDR 97ZZZX2450Impeller · wornBLOWER IMPELLER EXCESSIVE PLAY ON SHAFT. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. CORES RETURNED TO MDHS FROM RNO.SDR 97ZZZX2449Control Valve · defectiveINSTALLATION, ROTOR BRAKE CONTROL VALVE ASSY WEAK. ROTOR SYSTEM WILL NOT STOP WITHIN 1 MINUTE WHILE BRAKE IS APPLIED AT 3350 PSI PEAK. IN LOCKED POSITION THE PSI WILL DROP TO 180 AND WILL NOT FIRMLY LOCK HEAD (CAN MANUALLY PUSH HEAD THROUGH WITH LITTLE RESISSDR 97ZZZX2442Isolator · wornDRIVE/TRANSMISSION SYSTEM ISOLATOR WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. CORES RETURNED TO MDHS FROM RNO.SDR 97ZZZX2471Diverter Plate · wornINSTALL, NOTAR (R) DIFFUSER - STATOR. REPLACED SEVERAL FAN BLADES. REINSTALLED FAN ASSY. WHILE PERFORMING A PEDAL CHECK, FOUND PITCH CONTROL BELLCRANK ROCKING INSIDE THE DIVERTER PLATE. FURTHER INVESTIGATION FOUND THE BUSHINGS ARE TOO LOOSE WITHIN THE DIVESDR 97ZZZX2466Blade Assy · defectiveFAN ASSEMBLY, NOTAR (R). WHILE PERFORMING FAN HUB WEIGHT CHANGE, FOUND SEVERAL FAN BLADES WITH SIDEWALL DEFECT OR PROTRUSION. ALSO, FOUND THE FAN DIVERTER PLATE BELLCRANK HAD ELONGATED HOLES. INNER BELLCRANK WAS LOOSE. REPLACED WITH NEW UNIT, CORRECTED PROSDR 97ZZZX2465Blade · damagedFAN ASSEMBLY, NOTAR (R), BLADE DAMAGED. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2464Blade Assy · defectiveFAN ASSEMBLY, NOTAR (R). WHILE PERFORMING FAN HUB WEIGHT CHANGE, FOUND SEVERAL FAN BLADES WITH SIDEWALL DEFECT OR PROTRUSION. ALSO, FOUND THE FAN DIVERTER PLATE BELLCRANK HAD ELONGATED HOLES. INNER BELLCRANK WAS LOOSE. REPLACED WITH NEW UNIT, CORRECTED PROSDR 97ZZZX2463Blade Assy · defectiveFAN ASSEMBLY, NOTAR (R). WHILE PERFORMING FAN HUB WEIGHT CHANGE, FOUND SEVERAL FAN BLADES WITH SIDEWALL DEFECT OR PROTRUSION. ALSO, FOUND THE FAN DIVERTER PLATE BELLCRANK HAD ELONGATED HOLES. INNER BELLCRANK WAS LOOSE. REPLACED WITH NEW UNIT, CORRECTED PROSDR 97ZZZX2462Blade Assy · defectiveFAN ASSEMBLY, NOTAR (R). WHILE PERFORMING FAN HUB WEIGHT CHANGE, FOUND SEVERAL FAN BLADES WITH SIDEWALL DEFECT OR PROTRUSION. ALSO, FOUND THE FAN DIVERTER PLATE BELLCRANK HAD ELONGATED HOLES. INNER BELLCRANK WAS LOOSE.SDR 97ZZZX2461Bellcrank · wornINSTALLATION, NOTAR (R) FAN CONTROL WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2445Display · malfunctionFLIGHT INSTRUMENT INSTALLATION DISPLAY SYSTEM (IIDS) FAULT NR 9 RECORDED WHILE PRESSING CLR. TO PREPARE FOR DATA DOWNLOAD, IIDS WENT BACK JUST LIKE IT HAD BEEN TURNED OFF, BUT RIGHT SIDE FUNCTION BUTTONS STILL ON 3 TO 4 SECONDS. REPLACED WITH NEW UNIT, CORRESDR 97ZZZX2475Strut · bentCOCKPIT DOORS, INSTALLATION. DOOR STRUT BENT BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2469Pad · wornSTANDARD LANDING GEAR INSTALLATION. SADDLE PAD WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. CORES RETURNED TO MDHS FROM RNO.SDR 97ZZZX2455Switch · wornICS FOOT SWITCH WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2444Scissors · wornMAIN ROTOR SYS INST PILOT REPORTS EXCESSIVE MR VIBRATION. SWASHPLATE DRIVE SCISSORS WORN .128 INCH (MEASURED WHILE INSTALLED). PITCH LINK HAS WORN .038 INCH IN 77 HOURS. INSTALLED NEW PN-107. PARTS RETURNED TO MDHS FROM RNO. NOTE: WITH SCISSORS REMOVED TSDR 97ZZZX2458Pinion Assy · leakingTRANSMISSION ASSY LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. CORES RETURNED TO MDHS FROM RNO.SDR 97ZZZX930Flex Beam · delaminatedFLEX BEAM BUMPER DELAMINATION. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. CORE PART RETURNED DIRECTLY TO MESA FROM RENO.SDR 97ZZZX2459Pinion Assy · leakingTRANSMISSION ASSY LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. CORES RETURNED TO MDHS FROM RNO.SDR 97ZZZX2322Latch · bindingCOWL LATCH STIFF AND BINDING. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2454Hose · leakingOIL BREATHER INSTALLATION, HOSE LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2453Hose · leakingOIL BREATHER INSTALLATION, HOSE LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2452Hose · leakingHOSE LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH 2 EACH NEW UNITS, CORRECTED PROBLEM.SDR 97ZZZX2443Lining · wornINSTALLATION, ROTOR BRAKE CONTROL WORN BEYOND SERVICEABLE LIMITS. ROTOR BRAKE FAILS TO SLOW ROTOR DOWN WITHIN THE SPECIFIED LIMITS. REPLACED WITH 2 EACH NEW UNITS, CORRECTED PROBLEM.SDR 97ZZZX2324Bracket · bentCOLLECTIVE SENSOR BRACKET BENT BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2323Collective Stick · screw brokeSET SCREW INSIDE TWIST GRIP BROKE OUT FROM THE NR 2 THROTTLE SIDE. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2156Bellcrank Strap · wornEMPENNAGE BUILD-UP ASSEMBLY, FOUND BELLCRANK STRAPS WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH 2 EACH NEW UNITS, CORRECTED PROBLEM.SDR 97ZZZX2441Display · malfunctionFLIGHT INSTRUMENT INSTALLATION. DISPLAY ROTOR BRAKE WARNING BMS FAULT 13. RECEIVED THE WARNING TWICE. REPLACED WITH USED UNIT, CORRECTED PROBLEM.SDR 97ZZZX724Bearing · wornM/R CENTERING BEARING ELASTOMERICS WORN BEYOND SERVICEABLE LIMITS. DEBONDING. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX929Flex Beam · delaminatedFLEX BEAM BUMPER DELAMINATION. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX928Flex Beam · delaminationFLEX BEAM BUMPER DELAMINATION. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2155Bolt · seizedMAIN ROTOR BLADE INSTALLATION, FOUND RETAIN BOLT GAULED AND SEIZED. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2154Bolt · seizedMAIN ROTOR BLADE INSTALLATION, FOUND RETAIN BOLT GAULED AND SEIZED. REPLACED WITH NEW UNITS, CORRECTED PROBLEM.SDR 97ZZZX2473Fan Assy · damagedFAN ASSEMBLY, NOTAR (R). DAMAGED AROUND BLADE CUFF. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2325Bearing · notchedT/R CONTROL BEARING NOTCHED. OCCURRENCE DATE IS 12-19-96. REPALCED WITH 6 EACH UNITS, CORRECTED PROBLEM.SDR 97ZZZX2161Pitch Link · wornMAIN ROTOR SYSTEM PITCH LINK WORN BEYOND SERVICEABLE LIMITS. EXCESS BEARING PLAY CAUSING AIRFRAME VIBRATION. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2158Pitch Link · wornPITCH LINK WORN BEYOND SERVICEABLE LIMITS. EXCESS BEARING PLAY CAUSING AIRFRAME VIBRATION. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2157Switch · defectiveINSTALLATION, ROTOR BRAKE CONTROL PROBLEM. ROTOR BRAKE LIGHT COMING ON DURING FLIGHT. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX732Display Sys · lights fluctuateDISPLAY DIMMER AND LIGHTS FLUCTUATE. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX669Hose · leakingHOSE LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2448Thermocouple · wornTHERMOCOUPLE WORN BEYOND SERVICEABLE LIMITS AND REMOVED IN COMPLIANCE TO SB 28096. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2447Thermocouple · wornTHERMOCOUPLE WORN BEYOND SERVICEABLE LIMITS AND REMOVED IN COMPLIANCE TO SB 28096. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.
Back to N901CF