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 2000ZZZX139Wire · chafedUNITS EXCESSIVELY CHAFED. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 2000ZZZX144Bearing · wornELASTOMERICS WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 20000517SH028Control Box · inoperativeUNIT INOPERATIVE. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. (X)SDR 2000ZZZX151Bolt · damagedNOT SEIZED ON SHAFT THREADS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 2000ZZZX143Bearing · wornELASTOMERICS WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 2000ZZZX142Bearing · wornELASTOMERICS WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 99ZZZX3522Pitch Link · wornPITCH LINK WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 99ZZZX3521Thermal Valve · fluctuatingOIL TEMPERATURE FLUCTUATION TO VALVE (NOT SEATING). REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 99ZZZX2612Actuator · malfunctionedACTUATOR BACK-DRIVES WHEN POWER IS APPLIED. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 99ZZZX2611Actuator · malfunctionedACTUATOR BACK-DRIVES WHEN POWER IS APPLIED. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 2000ZZZX140Link · looseLINK HAD EXCESSIVE PLAY. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 99ZZZX779Display System · failedIIDS WILL NOT RESPOND TO MENU KEY, DIGITAL READ-OUT OR DISPLAY EXCEPTION. CYCLING POWER OFF THEN ON SEEMS TO CORRECT PROBLEM TEMPORALLY. RIGHT TURBINE EGT FLUCTUATION ON DISPLAY LED. CONSTANT IIDS BATTERY FAULT. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 99ZZZX847Link Assy · looseLINK ASSY, DRIVE-SCISSORS, EXCESSIVE PLAY AT HIGH SPEED. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 99ZZZX776Pitch Link · wornPITCH LINK WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 99ZZZX778Line · wornLINE IN OIL SYSTEM WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX4423Display · damagedSCREEN SEPARATED WHICH CAUSES LIGHT TO SHINE THROUGH. THE SEPARATION ALSO CAUSED THE FORMATION OF A SINGLE BUBBLE WHICH DISTORTS ONE OF THE ANNUNICATOR WARNING LIGHTS. AT TIMES, THE BUBBLE WOULD CAUSE THE ILLUSION OF FALSE WARNING LIGHT THAT COULD CAUSE THE SDR 99ZZZX848Shroud · leakingVAPOR SHROUD LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 99ZZZX849Blade · crackedBLADE ASSY CRACKED BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 99ZZZX775Actuator · failedACTUATOR UNIT INOPERATIVE. FAILS TO RETRACT DOOR. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX3735Pitch Link · wornPITCH LINK ASSY WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX3726Stator · failedPIN 'A' IS EXCESSIVELY BURNED. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX3725Harness · failedPIN TO PMA (STATOR) IS EXCESSIVELY BURNED. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX3850Screen · wornSCREEN WORN BEYOND SERVICE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX3742Screen · wornAIR INLET SCREEN WORN BEYOND SERVICEABLE LIMITS. WIRE MESH IS LOOSE AND FRETTI NG. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX3738Screen · wornAIR INLET SCREEN WORN BEYOND SERVICEABLE LIMITS. WIRE MESH IS LOOSE AND FRETTING. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX3724Screen · wornSCREEN WORN BEYOND SERVICEABLE LIMITS. WIRE MESH IS LOOSE AND FRETTING. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX3737Bearing · damagedBEARING DEBONDED FROM ELASTOMERS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX3728Fan Assy · damagedBUBBLE IN SPAR AREA. REPLACED WITH NEW FAN ASSY UNIT, CORRECTED PROBLEM.SDR 98ZZZX3709Fan Assy · damagedBUBBLE IN SPAR AREA. REPLACED FAN ASSY WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX3708Fan Assy · damagedBUBBLE IN SPAR AREA. REPLACED FAN ASSY WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX2525Eec · failedEEC FAILED TO PASS OVERSPEED TEST. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX3732Caliper · stuckAFT PISTON WILL NOT RETRACT. UNIT INSTALLED WHILE AC WAS IN MESA FOR WORK. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX3736Bearing · damagedBEARING DEBONDED FROM ELASTOMERS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX3707Shield · crackedSHIELD CRACKED BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. PART TOTAL CYCLES: 1,477.SDR 98ZZZX3733Actuator · inoperativeUNIT INOPERATIVE. DOOR WILL NOT OPEN. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX3734Actuator · inoperativeUNIT INOPERATIVE. MOTOR FAILED. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX1991Support · crackedLT INLET SUPPORT ASSY CRACKED BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX1990Support · crackedRT INLET SUPPORT ASSY CRACKED BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX1989Valve · failedFLOW CONTROL VALVE WILL NOT OPEN AND CLOSE PROPERLY. ALSO, THE VALVE WILL NOT REMAIN SEATED WHICH CAUSES BLEED AIR TO PASS BY. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX1810Bracket · crackedPILOT'S REPORT - WHILE ADJUSTING SNOW COVER ON THRUSTER CAN, PILOT HEAR A LOUD CRACK AS IF SOMETHING INSIDE THE TAILBOOM BROKE. MECHANIC DISASSEMBLED THRUSTER AND FOUND A BRACKET CRACKED AROUND THE 'PITCH CHANGE CABLE MOUNT POINT'. REPLACED WITH NEW UNIT, SDR 98ZZZX1813Trim Box · defectiveTORQUE TRIM BOX TRIGGERING FAULT CODES: NCFALL - 13 AND AIRCRAFT FLT - 11. RESISTANCES FLUCTUATE WHEN CANNON PLUG IS WIGGLED. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX1812Thermocuple · failedTHERMOCOUPLE HAS FAULTY INDICATION AND EXCESSIVE RESISTANCE. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX1811Thermocouple · failedTHERMOCOUPLE HAS FAULTY INDICATION AND EXCESSIVE RESISTANCE. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 99ZZZX777Blade · debondedBLADE DEBONDING. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX1361Blower Drive · leakingBLOWER DRIVE LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX1353Bypass Indicator · failedMGB FILTER BYPASS INDICATOR UNIT INOPERATIVE. EVEN WITH FRESH FILTERS INSTALLED, UNIT 'POPS'. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX1352Servo Actuator · leakingHYDRAULIC SERVO ACTUATOR LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX1502Display · failedDISPLAY SYSTEM UNIT INOPERATIVE. LOWER HALF OF DISPLAY IS DIMMER (APPROXIMATELY BY HALF) THAN THE UPPER HALF. REPLACED WITH REPAIRED UNIT. CORRECTED PROBLEM.SDR 98ZZZX1010Bearing · bindingBALL SLIDER BEARING BINDING ON MAIN ROTOR SHAFT ASSY DURING COLLECTIVE MOVEMENT. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 98ZZZX1015Actuator · failedINLET DOOR LINEAR ACTUATOR FAILED IN OPEN POSITION. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.
Back to N901CF