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 aircraft_model_key = '650' 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 aircraft_model_key = '650' 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 62MA2025120800797Autopilot Sys · false activationAFTER TAKEOFF MASTER WARNING COME ON, PRIMARY TRIM FAILED. NOTED FLIGHT DIRECTOR WENT DOWN (INDICATOR ERRATIC). ACCOMPLISHED RE RACK OF THE AUTO PILOT COMPUTERS OPS CHECK SUCCESSFUL AFTER THE MX ACTION PER. AMM 22-10-02SDR PLCA202408230200Switch · out of adjustAFTER TAKEOFF FROM KSAT TO KRDU LANDING GEAR WOULD NOT RETRACT, GEAR HANDLE WOULD NOT MOVE FROM THE DOWN AND LOCK POSITION, FLIGHT CREW DIVERTED BACK TO SAT AND LANDED WITH WITHOUT INCIDENT. MAINTENANCE INSPECTED THE THE AIRCRAFT LANDING GEAR RETRACTION SYSTEMSDR 2024F00195Squat Switch · out of adjustAFTER TAKEOFF FROM KAUS TO KPBI LANDING GEAR WOULD NOT RETRACT, GEAR HANDLE WOULD NOT MOVE FROM THE DOWN AND LOCK POSITION, FLIGHT CREW DIVERTED TO SAT AND LANDED WITH WITHOUT INCIDENT. MAINTENANCE INSPECTED THE THE AIRCRAFT LANDING GEAR RETRACTION SYSTEM AND SDR 2024F00161Pump · failedFROM KSAT TO MYNN WHEN WE EXPERIENCED AN ENGINE FAILURE IN FLIGHT. AT FLIGHT LEVEL 390 APPROXIMATELY 100 MILES WEST OF THE SOUTHERN COAST OF FLORIDA, THE LEFT (#1) ENGINE ROLLED BACK QUITE ABRUPTLY IN FLIGHT. WE DECLARED AN EMERGENCY DUE TO THE LOSS OF THRUSSDR 62MA2024051400369Control Box · faultyAFTER TAKE OFF THE LG HANDLE WAS HARD TO MOVE.SDR SOWA2024FA0000213Control Cable · frayedLH ROLL SPOILER UP CABLE WORN AND FRAYED. REQUIRED REPLACEMENT.SDR 2023FA0000203Unknown · unknownFLIGHT CREW ON ROLLOUT FOR TAKE FROM FTW. THE NO TAKE OFF WARNING HORN SOUNDED AND WARNING LIGHT ILLUMINED AND THE FLIGHT CREW ABORTED THE TAKEOFF . THE FLIGHT CREW NOTIFIED THE TOWER WHILE TAXI OFF THE RUNWAY THAT THE NO TAKEOFF WARNING LIGHT AND WARNING CAMESDR 2023FA0000087Sensor · openON TAKEOFF ROLL OUT AT LIT NUMBER 2 BATTERY OVERTEMPERATURE ANNUNCIATOR ILLUMINATE . FLIGHT CREW NOTIFY TOWER ABORTED TAKEOFF WHILE TAXI BACK TO FBO CREW CHECKED BATTERY TEMPERATURE GAUGE READING AND TEMPERATURE WAS NORMAL. . INSPECTED BATTERY FOUND NOT OVERHESDR 2023FA0000064Not Entered · not enteredON DESCENT FOR APPROACH INTO KHOU THE FLIGHT CREW SELECTED LANDING DOWN AFTER LANDING GEAR EXTENDED DOWN THE CREW DID NOT HAVE NOSE GEAR DOWN AND LOCK LIGHT COME ON ALL OTHER INDICATION AND WERE GOOD. FLIGHT CREW NOTIFIED ATC THAT THEY WOULD LIKE TO CIRCLE THESDR 2022F00348Access Panel · damagedAIRCRAFT ON DESCEND INTO SAT HOME BASE THE CREW HEARD A BANG TO UNDER SIDE OF THE AIRCRAFT POSSIBLE BIRD STRIKE AND LANDED NORMALLY. WHEN CREW WERE PERFORMING THE AFTER FLIGHT WALK THEY WERE CHECK ANY DAMAGE FROM A BIRD STRIKE POSSIBLE. THE CREW FOUND THE BONSDR 2022FA0000425Wire · openACCESSORY DOOR WARNING LIGHT ILLUMINATED AFTER TAKEOFF FROM SAT .CREW RETURN THE AIRCRAFT TO BASE. MAINTENANCE INSPECTED ACCESSORY DOOR INDICATING SYSTEM FOUND BROKEN WIRE AT AFT TAIL CONE ACCESS DOOR WARNING SWITCH. REPAIRED WIRE AT SWITCH PERFORMED OPERATIOSDR 2021FA0000427Control Module · failedWHILE PERFORMING A MAINTENANCE CHECK FLIGHT FOR REPAIRS PERFORMED FOR PRIMARY PITCH TRIM SYSTEM FAILING INTERMIT ON DESCENT. ON ALL OTHER PHASE OF FLIGHT AND ON THE GROUND SYSTEM WORKS CORRECTLY. MAINTENANCE TROUBLESHOOT THE PITCH TRIM SYSTEM AND REPLACED WORSDR 2021FA0000428Control Module · failedWHILE PERFORMING A MAINTENANCE CHECK FLIGHT FOR REPAIRS PERFORMED FOR PRIMARY PITCH TRIM SYSTEM FAILING INTERMIT ON DESCENT. ON ALL OTHER PHASE OF FLIGHT AND ON THE GROUND SYSTEM WORKS CORRECTLY. MAINTENANCE TROUBLESHOOT THE PITCH TRIM SYSTEM AND REPLACED WORSDR XXD2021F00000Connector · damagedAFTER TAKEOFF, THE LANDING GEAR WAS STUCK IN THE DOWN POSITION. THE CREW DECIDED TO RETURN TO DEPARTURE. DURING INSPECTION, FOUND A PIN IN THE CONNECTOR, LOOSE.SDR T8VA2021111700001Shaft · wornCREW REPORTED FLAPS INOPERATIVE, STUCK AT 7 DEGREES. FAILED FL23 CURRENT LIMITER, REPLACED FL23 CURRENT LIMITER P/N ANL4. INVESTIGATED REASON FOR FAILED CURRENT LIMITER AND FOUND SEVERAL FLAP ACTUATORS SCREW SHAFTS TO BE ROUGH AND POSSIBLY BINDING UNDER A LOASDR JGVR20210819001Line · damagedFLIGHT CREW REPORTED NEARLY DEPLETED HYDRAULIC SYSTEM AND MADE AN EMERGENCY LANDING. MAINTENANCE TROUBLESHOT AND FOUND A HYDRAULIC LINE CHAFED THROUGH BY THE ADJACENT CLAD AILERON CONTROL CABLE LOCATED IN THE RH WING TRAILING EDGE AREA AT THE OB SPOILER PANEL SDR 2021F00100Control Head · burned outAFTER TAKE OFF FROM HOU ON CLIMB OUT ENROUTE TO ASE. THE NUMBER ONE FMS SCREEN FLASHED BRIGHT AND WHEN BLANK AND CREW NOTE FUMES/ODOR LIKE ELECTRIC SMELL THAT SOMETHING BURN OUT. CREW SHUT OFF THE NUMBER ON FMS CONTROL AND PULLED CIRCUIT BREAKER FOR THAT UNIT SDR FDIA202107260001Line · splitA HYDRAULIC LINE FAILED AT A FOUR POINT UNION IN THE AFT SERVICE AREA, AT OR NEAR THE TIME OF ROTATION. THIS CAUSED A TOTAL LOSES OF HYDRAULIC PRESSURE SYSTEM WIDE. AIRCRAFT COMPLETED TAKEOFF AND CLIMBED TO PATTERN ALTITUDE AND COMPLETED A NORMAL APPROACH AND SDR 2022FA0000633Actuator · brokenAFTER TAKEOFF, GEAR WAS SELECTD UP AND THE GEAR UNLOCK LIGHT ILLYMINATED. CYCLED THE GEAR ONCE WITH THE SAME EFFECT. AT LANDING, GEAR WAS SELECTED DOWN WITH 3 GREEN. MAINTENANCE FOUND MAIN GEAR ACTUATOR BROKE FROM WING ATTACH POINT. COMPONENT HAD 6016 LANDINGSSDR 2021F00099Link Pin · damagedAFTER TAKEOFF FROM TEB .WHEN CREW WHEN TO MOVE THE LANDING LEVER TO RETRACT LANDING GEAR THE LEVER WOULD NOT MOVE OUT DOWN AND LOCK POSITION. FLIGHT CREW RETURN BACK TO BASE TO HAVE LANDING SYSTEM CHECKED OUT. MAINTENANCE FOUND NOSE GEAR CENTERING SWITCH LINKSDR 2021FA0000248Warning Light · illuminatedRIGHT ENGINE PRESSURE LIGHT ILLUMINATED DURING FLIGHT.SDR T4BA20210314001Tire · failedUPON DEPARTURE FROM KASE TO KHOU, CREW FELT A SMALL BUMP. SHORTLY AFTER TAKEOFF, BOTH CREWMEMBERS NOTICED COMPLETE LOSS OF HYDRAULIC FLUID AND PRESSURE. CREW DECIDED TO DIVERT TO DENVER WHERE A LONG RUNWAY WAS AVAILABLE AS THERE WOULD ONLY BE EMERGENCY BRAKINSDR I5JA20210114001Link · distortedAFTER ROTATION AIR CREW HEARD A CLUNKING NOISE AND LANDING GEAR WOULD NOT RETRACT. GEAR HANDLE WILL NOT MOVE INTO RETRACT POSITION. ALL GEAR DOWN AND LOCKED "GREEN" LIGHTS STAYED ILLUMINATED. CREW PERFORMED A FLY BY AND HAD TOWER VERIFY THAT GEAR WAS DOWN. SDR JGVR20201215002Screw · strippedWHILE ATTEMPTING TO REPLACE MOUNTING HARDWARE DUE TO HARDWARE BEING SEIZED IN PLACE ON LT AND RT FLAP ANGLE GEAR BOX PN: 9914393-1 WHICH CALLS FOR A PN: WD6000-21. WE HAD TO DRILL AND EXTRACT THE SCREWS. THIS PARTICULAR SCREW HAS A COUNTERSUNK HEAD, WHICH ISSDR 2020F00474Landing Gear · malfunctionedAFTER TAKEOFF FROM SAT, WHEN THE FLIGHT CREW WERE SELECTING LANDING GEAR UP WITH THE SELECTOR LEVER THE LEVER WOULD NOT MOVE OUT THE DOWN AND LOCK POSITION. FLIGHT CREW RADIO TOWER AND REQUESTED TO FLY BY AND HAVE THEM LOOK AT NOSE LANDING GEAR TO SEE IF LOOKSDR T8VA11042020Wire · detachedPILOT REPORTED THE RIGHT GREEN GEAR LIGHT ILLUMINATED WHEN THE GEAR WAS UP DURING CLIMB. CAUSE: FOUND BROKEN WIRE AT PIN "C" OF THE UPLOCK SWITCH JW8. THIS WAS GIVING A FALSE INDICATION THAT THE RIGHT GEAR WAS ALREADY UP AND CAPTURED WHICH DISCONTINUED HYDRASDR SFOA2020032500000Transducer · fluctuatesUPON REACHING CRUISE ALTITUDE THE LEFT OIL PRESSURE GAUGE BEGAN TO FLUCTUATE WILDLY FROM ZERO UP TO MAXIMUM PSI. NO LOW OIL PRESSURE ANNUNCIATOR WAS OBSERVED AND ALL OTHER ENGINE PARAMETERS WERE NORMAL. THE AIRCRAFT RETURNED TO HOME BASE WHERE AN UNEVENTFUL LASDR T8VA2019060760001Hose · rupturedWHILE ON CLIMB OUT AND TEN MINUTES INTO FLIGHT GOT HYDRAULIC VOLUME LOW ANNUNCIATOR. CREW VERIFIED THE VOLUME LOW AND PERFORMED THE HYDRAULIC VOLUME LOW CHECKLIST, PILOT DECLARED AN EMERGENCY AT KHOU AND RETURNED AND LANDED THE AIRCRAFT FURTHER INCIDENT. POSISDR WNDA2019F00098Accumulator · failedLANDING GEAR WOULD NOT RETRACT.SDR WNDA2018FA0000377Trim System · malfunctionedAT CRUISE THE PILOT NOTICED THE HORIZONTAL PRIMARY TRIM FAIL LIGHT AND SWITCHED TO STAND-BY TRIM BUT THE TRIM SYSTEM WOULD NOT MOVE, THE PILOT IN COMMAND CONTACTED CENTER AND INFORMED CENTER HE HAD AN EMERGENCY AND WANTED TO CHANGE HIS AIRPORT TO ONE THAT HAD SDR WNDA2019F00040Unknown · odorON TAKE OFF THE CABIN AND COCKPIT FILLED WITH SMOKE.SDR WAIA2017122200001Unknown · odorSMELLED A SMOKE ODOR IN THE COCKPIT. FIRST IMPRESSION WAS THAT IT WAS FUMES FROM ANOTHER AIRPLANE. CONTINUED TO THE HOLDING POINT AND RECEIVED A TAXI CLEARANCE. AT THIS POINT THE ODOR HAD BECOME MUCH STRONGER.IMMEDIATELY CANCELED TAXI CLEARANCE AND TURNED BACKSDR SFOA201701230001Pump · faultyDURING LANDING, THE LT ENGINE OIL PRESSURE ANNUNCIATOR ILLUMINATED AND CREW NOTED THE OIL PRESSURE WAS AT 23PSI, THE ENGINE WAS SHUT DOWN AND THE AIRCRAFT WAS GROUNDED AND TURNED OVER TO MAINTENANCE FOR TROUBLESHOOTING. CREW ALSO NOTED THE OIL FILTER BYPASS INSDR 9PVA2015111200001Seal · leakingDOOR SEAL LIGHT CAME ON AT FLT LEVEL 410. DOOR SEAL SQUEALED THEN LOST PSI ON DECENT. DECLARED AN EMERGENCY AND LANDED AT KPHL.SDR SFOA201612140001Latch · bindingAFTER LANDING AT DESTINATION AIRPORT AND AFTER SUBSEQUENT ENGINE SHUT DOWN THE CREW COULD NOT OPEN THE CABIN DOOR. INITIALLY ICE WAS SUSPECTED AS THE CAUSE BUT AFTER THAWING THE DOOR STILL COULD NOT BE OPENED. MAINTENANCE WAS CALLED AND IT WAS DETERMINED THAT SDR SFOA2016100500002Ground Wire · detachedAPPROXIMATELY 1 HOUR INTO FLIGHT BOTH LT ITT INDICATORS AGAIN BEGAN TO FLUCTUATE WITH NO ENGINE COMPUTER ANNUNCIATION. THE AIRCRAFT CONTINUED ON TO SCHEDULED DESTINATION WHERE AN UNEVENTFUL LANDING WAS MADE. THIS WAS 4 LANDINGS AND APPROXIMATELY 6 HOURS SINCE SDR SFOA2016100500001Indicator · malfunctionedAPPROXIMATELY 10 MINUTES INTO FLIGHT BOTH LT ITT INDICATORS BEGAN TO FLUCTUATE APPROXIMATELY 200 DEGREES. NO ENGINE COMPUTER ANNUNCIATION WAS NOTED. THE AIRCRAFT RETURNED TO HOME BASE WHERE AN UNEVENTFUL LANDING WAS MADE. THE ITT INDICATOR WAS REPLACED AND GROSDR SFOA201609190001Indicator · malfunctionedUPON ENGINE START THE RT ITT INDICATOR SHOWED NO INDICATION ON THE TAPE OR DIGITAL INDICATORS. NO ENGINE COMPUTER FAULTS WERE INDICATED. MEL ALLOWS FOR THE TAPE OR THE DIGITAL TO BE INOPERATIVE BUT NOT BOTH. A SPECIAL FLIGHT PERMIT WAS ACQUIRED AND THE ACFTSDR 2016FA0000458Relay · failedON APPROACH, FLAPS FAILED AT 7 DEGREES, DIVERTED . TROUBLESHOT SYSTEM, FOUND FAULT CODE NR 4 ON FLAP CONTROLLER.REPLACED HIGH SPEED RELAY WITH NEW PART. OPS CHECKED GOOD, WORK PERFORMED IAW MM 27-54-01. AIRCRAFT RETURNED TO SERVICE.SDR SFOA201607290001Chip Detector · faultyWHILE AT CRUISE FLIGHT, THE RT ENGINE CHIP DETECTOR ANNUNCIATOR ILLUMINATED, ALL OTHER ENGINE PARAMETERS WERE NORMAL. AFM PROCEDURES WERE FOLLOWED AND A PRECAUTIONARY AND SAFE LANDING WAS MADE. THE ENGINES WERE SHUTDOWN AND THE ACFT TURNED OVER TO MAINTENANCSDR SFOA201607220001Computer · failedAT CRUISE FLIGHT MULTIPLE AMBER ANNUNCIATIONS ILLUMINATED, AOA PROBE, FLAP SPEEDBRAKE AND STALL WARNING, OFF FLAGS ALSO CAME INTO VIEW ON THE AOA INDICATOR AND BOTH FAST/SLOW INDICATORS. CREW FOLLOWED AFM PROCEDURES AND A SAFE LANDING WAS MADE AT DESTINATION SDR 9PVA2016053100132Pressure Switch · false indicationDEPARTED, DURING CLIMBOUT THROUGH 16,000 FT RECEIVED A LEFT LOW FUEL PRESSURE LIGHT FOLLOWED BY STANDBY BOOST PUMP LIGHT. THE CREW COMPLETED THE CHECK LIST AND BOTH LIGHTS REMAINED ON.SDR SFOA20160308002Fastener · missingUPON DECENT FROM CRUISE A SHUDDER WAS DETECTED WHEN THE POWER LEVERS WERE RETARDED. FLIGHT CREW WAS ABLE TO DETERMINE IT WAS THE RT ENG CAUSING THE SHUDDER. ALL ENG PARAMETERS WERE NORMAL, AS SAFE LANDING WAS MADE. INVESTIGATION RESULTED IN THE DISCOVERY OFSDR SFOA20160308001Line · contaminatedUPON TAKE OFF THE LT RUDDER PEDAL DEFLECTED FULL LT. THE RUDDER BIAS SYS WAS DEACTIVATED & THE RUDDER SYS RETURNED TO NORMAL. AFTER LANDING THE RUDDER BIAS SYS WAS TESTED & CHECKED OK, BUT RUDDER PEDAL WOULD STILL DEFLECT WHEN ENG POWER WAS APPLIED. IT WAS SDR WNDA2016FA0000105Acm · overheatedON CLIMBOUT AFTER TAKEOFF, PILOT NOTICED SMOKE IN THE CABIN FOLLOWED BY RT PAC OVERHEAT LIGHT. AFTER FURTHER INVESTIGATION BY MAINTENANCE FOUND THE RT AIR CYCLE MACHINE TO HAVE A LOCK UP IMPELLER SHAFT.SDR SFOA20151230001Indicator · faultyUPON ENG START UP FOR DEPARTURE, PILOT NOTED LT DIGITAL TURBINE INDICATOR SHOWED NO DIGITS. ENG STARTED NORMALLY & ALL OTHER INSTRUMENTS READ NORMAL & THERE WERE NO ENG COMPUTER FAULTS. A SPECIAL FLIGHT PERMIT WAS ISSUED & ACFT WAS FLOWN TO HOME BASE WHERE ISDR T8VA2016F00013Actuator · failedPRIMARY TRIM FAILED IN FLIGHT. IAW CHECKLIST SWITCH TO SECONDARY TRIM. SECONDARY TRIM FAILED. ACCOMPLISHED DUAL TRIM FAILURE CHECKLIST. DECLARED AN EMERGENCY AND LANDED WITHOUT ANY FURTHER INCIDENT.SDR UVVR2015100800034Tire · debondedLEFT INBD MAIN TIRE TREAD SEPARATED FROM CARCASS ON LANDING. LEFT GEAR WIRE HARNESS AND INBD FLAP SUFFERED SIGNIFICANT DAMAGE.SDR CWQA20150908001Pump · leakingSHORTLY AFTER TAKEOFF, CREW RECEIVED HYD LOW PRESS INDICATION, ACCOMPANIED WITH LOW LEVEL INDICATION. CHECKLIST FOLLOWED, EMER DECLARED & AN UNSCHEDULED LANDING PERFORMED WITHOUT INCIDENT. EVALUATION FOUND LT MAIN ENG HYD PUMP LEAKING FROM MAIN BODY MATING SSDR T8VA2015FA0000224Bulb · burned outHAD NO NOSE GEAR INDICATION ON INITIAL APPROACH TO LAND. WENT AROUND AND CYCLED THE GEAR MULTIPLE TIMES. FLEW BY THE TOWER TO GET A VISUAL INSPECTION, THEY SAID THE GEAR APPEARED TO BE DOWN. THEN WE PERFORMED THE EMERGENCY GEAR EXTENSION CHECKLIST. STILL HAD
Back to Cessna 650