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 97ZZZX2446Isolator Bolt · delaminatedDELAMINATION. REPLACED WITH NEW 8 EACH UNITS, CORRECTED PROBLEM.SDR 97ZZZX2440Thermocouple · wornTHERMOCOUPLE WORN BEYOND SERVICEABLE LIMITS AND REMOVED IN COMPLIANCE TO SB 28096. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX2439Thermocouple · wornTHERMOCOUPLE WORN BEYOND SERVICEABLE LIMITS AND REMOVED IN COMPLIANCE TO SB 28096. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX731Swashplate · misalignedSWASHPLATE RECEIVED FROM MDHS WITH IMPROPER SPLIT LINE ALIGNMENT. SWASHPLATE SHOULD HAVE BEEN ALIGNED WITH THE AIRCRAFT CENTERLINE PER SB 900-032, BUT INSTEAD, THE TECHNICIAN ALIGNED THE SWASHPLATE WITH THE LATERIAL PITCH EAR IN ERROR. RMH PERSONNEL CORRECTESDR 97ZZZX658Pump · malfunctionHYDRAULIC PUMP, NR 2 SYSTEM PRESSURE TOO HIGH, 860 PSI. REPLACED WITH NEW UNIT, CORRECTED PROBLEMSDR 97ZZZX657Cover Plate · wornHEAT CONTROL COVER WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX728Door Latch · defectiveDOOR LATCH DEFECT. (SB 900-040). REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX727Door Latch · defectiveDOOR LATCH DEFECT. (SB900-040.) REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX726Bearing · wornM/R CENTERING BEARING ELASTOMERICS WORN BEYOND SERVICEABLE LIMITS. DEBONDING. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX723Bearing · wornM/R CENTERING BEARING ELASTOMERICS WORN BEYOND SERVICEABLE LIMITS. DEBONDING. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX722Bearing · wornM/R CENTERING BEARING ELASTOMERICS WORN BEYOND SERVICEABLE LIMITS. DEBONDING. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX721Bearing · wornCENTERING BEARING ELASTOMERICS WORN BEYOND SERVICEABLE LIMITS. DEBONDING. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX668Hose · leakingHOSE LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX640Hose · leakingHOSE LEAKING BEYOND SERVICEABLE LIMITS. SMALL PINHOLE 3 INCHES FROM OIL PUMP OUTLET. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX718Snubber Bolt · wornM/R HEAD SNUBBER BOLT WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW 5 EACH UNITS, CORRECTED PROBLEM.SDR 97ZZZX672Hinge · wornSPOILER HINGE WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX644Roller · wornCABIN DOOR ROLLER TRACK WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW 5 EACH UNITS, CORRECTED PROBLEM.SDR 97ZZZX643Cover Plate · wornCOVER PLATE WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX720Bearing · wornM/R CENTERING BEARING ELASTOMERICS WORN BEYOND SERVICEABLE LIMITS. DEBONDING FROM BALL. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX719Bearing · wornM/R CENTERING BEARING ELASTOMERICS WORN BEYOND SERVICEABLE LIMITS. DEBONDING FROM BALL. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX750Door Latch · defectiveDOOR LATCH DEFECT. COCKPIT FWD (SL 900-011.) REPLACED WITH NEW UNITS, CORRECTED PROBLEM.SDR 97ZZZX736Door Latch · defectiveDOOR LATCH DEFECT. COCKPIT FWD (SL 900-011.) REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX725Thrust Bearing · wornTHRUST BEARING WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH 3 EACH NEW UNITS, CORRECTED PROBLEM.SDR 97ZZZX730Abrasion Strip · wornSKID ABRASION STRIP WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX729Abrasion Strip · wornSKID ABRASION STRIP WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX5690Cable Assy · wornIGNITER CABLE ASSY WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW 2 EACH UNITS, CORRECTED PROBLEM.SDR 96ZZZX5689Cable Assy · wornIGNITER CABLE ASSY WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW 2 EACH UNITS, CORRECTED PROBLEM.SDR 97ZZZX734Actuator · defectiveDAMPNER ACTUATOR INSPECT FOR BREAKAWAY TORQUE TOLERANCE. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX733Actuator · faultyDAMPNER ACTUATOR FAILED BREAKAWAY TORQUE TOLERANCE INSPECTION. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX665Windscreen · defectiveTHE TINTED SMOKE COLOR OF THE WINDSCREEN GLASS CREATED VISIBILITY PROBLEMS DURING NIGHT-TIME FLIGHTS, ESPECIALLY WHILE RUNNING THE UV FILTERED SX5 NIGHT SUN. PILOTS REPORTED SEVERAL INADVERTENT IFR PROBLEMS BECAUSE OF THE TINTED COLOR. THE TINTED GLASS IS A SDR 97ZZZX664Windscreen · defectiveTHE TINTED SMOKE COLOR OF THE WINDSCREEN GLASS CREATED VISIBILITY PROBLEMS DURING NIGHT-TIME FLIGHTS, ESPECIALLY WHILE RUNNING THE UV FILTERED SX5 NIGHT SUN. PILOTS REPORTED SEVERAL INADVERTENT IFR PROBLEMS BECAUSE OF THE TINTED COLOR. THE TINTED GLASS IS A SDR 97ZZZX662Windscreen · defectiveTHE TINTED SMOKE COLOR OF THE WINDSCREEN GLASS CREATED VISIBILITY PROBLEMS DURING NIGHT-TIME FLIGHTS, ESPECIALLY WHILE RUNNING THE UV FILTERED SX5 NIGHT SUN. PILOTS REPORTED SEVERAL INADVERTENT IFR PROBLEMS BECAUSE OF THE TINTED COLOR. THE TINTED GLASS IS A SDR 97ZZZX661Windscreen · defectiveTHE TINTED SMOKE COLOR OF THE WINDSCREEN GLASS CREATED VISIBILITY PROBLEMS DURING NIGHT-TIME FLIGHTS, ESPECIALLY WHILE RUNNING THE UV FILTERED SX5 NIGHT SUN. PILOTS REPORTED SEVERAL INADVERTENT IFR PROBLEMS BECAUSE OF THE TINTED COLOR. THE TINTED GLASS IS A SDR 97ZZZX642Input Pinion · leakingINPUT PINION UPON INSTALLATION UNIT BEGAN LEAKING OIL BEYOND SERVICEABLE LIMITS. THIS REPORT FOR INFORMATION ONLY. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX735Bumper · bentTAILBOOM BUMPER BENT BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX737Abrasion Strip · wornSKID ABRASION STRIP WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH 2 EACH NEW UNITS, CORRECTED PROBLEM.SDR 97ZZZX675Retain Nut · groovedBLADE RETAIN BOLT UNIT EXCESSIVELY GROOVED. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX666Bushing · wornSWASHPLATE BUSHING WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW 5 EACH UNITS, CORRECTED PROBLEM.SDR 97ZZZX656Valve · stuckBLEED AIR CHECK VALVE STUCK CLOSED. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX652Retain Bolt · groovedBLADE RETAIN BOLT UNIT EXCESSIVELY GROOVED. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX651Retain Bolt · groovedBLADE RETAIN BOLT UNIT EXCESSIVELY GROOVED. REPLACED WITH NEW UNIT, CORRECTED PROBLEMSDR 97ZZZX645Seal · leakM/R HEAD SEAL LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX641Latch · wornCOWL LATCH WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX673Tube · leakTUBE REPLACED PER SL 900-016. CORRECTION OF ENGINE OIL LEAK. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX4682Display System · errorDISPLAY SYSTEM FUEL QUANTITY INDICATOR FLUCTUATES 200 POUNDS. REPLACED WITH USED UNIT, CORRECTED PROBLEM.SDR 97ZZZX670Bearing · wornTHRUST BEARING WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH 3 EACH NEW UNITS, CORRECTED PROBLEM.SDR 97ZZZX639Seal · wornM/R HEAD SEAL WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 97ZZZX671Bearing · wornTHRUST BEARING WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH 4 EACH NEW UNITS, CORRECTED PROBLEM.SDR 96ZZZX3596Pinion Assy · leakingPINION ASSY LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX3595Pinion Assy · leakingPINION ASSY LEAKING BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.
Back to N901CF