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 = 'C99' 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 = 'C99' 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 JIKA2020122901Light · shortedDURING APPROACH TO KIST, THE FLIGHT CREW NOTED A STRONG SMELL AND A SMALL CLOUD OF WHITE SMOKE STARTED COMING OUT FROM THE INSTRUMENT PANEL MOMENTARY AND THEN DISAPPEARED. THE PILOT GOT DISTRACTED AND DECIDED EXECUTING A GO AROUND. WHEN THE SMELL STARTED GETSDR JIKA2020102802Amplifier · false indicationON CLIMB OUT AT ABOUT 300' AGL THE LEFT T-HANDLE LIGHT ILLUMINATED. PILOT RAN MEMORY ITEMS CHECKLIST COMPLETING CLIMB THROUGH 4500 MSL WITH NO CHANGE AND AT THAT DECLARED AN EMERGENCY. CREW COMPLETED THE REST OF THEIR CHECKLISTS FOR LANDING AND LANDED ON RUNSDR TIMA20201014005Current Limiter · inoperativeON FINAL APPROACH INTO KSLC 34R, PILOT ATTEMPTED TO LOWER THE GEAR ABOUT 4 NM FROM 4-5 NM FROM TOUCHDOWN. PILOT NOTICED THE GEAR TRANSITION LIGHT DID NOT ILLUMINATE AND THAT THE CONTROL CB HAD POPPED. PILOT RESET THE CB, AND RECYCLED THE LANDING GEAR HANDLE SDR JIKA2020070262201Amplifier · shortedAFTER TAKEOFF FROM KBGR THE PILOT REPORTED THE 26 VAC CIRCUIT BREAKER TRIPPED. AFTER RESET CIRCUIT BREAKER, SMOKE NOTED FROM CIRCUIT BREAKER. PILOT RETURNED TO KBGR AND LANDED WITHOUT INCIDENT. MAINTENANCE TRAVELED TO KBGR AND INSPECTED THE COMPASS SYSTEM ASDR AXSA2020040300000Wire · arcedSMELL OF BURNING WIRES AND WHISP OF SMOKE OBSERVED BEHIND LANDING GEAR HANDLE.SDR JIKA20200317301Gcu · out of adjustENROUTE TO PHX FROM OLS WHEN CREW WAS ADVISED TO HOLD FOR WEATHER AROUND THE SAMETIME THE AIRCRAFT LOST SEVERAL INSTRUMENTS AND LIGHTING, AND RECEIVED INSTRUMENT INOP FLAGS ON CAPTAIN SIDE INCLUDING BUT NOT LIMITED TO, THE ALTIMETER INOP FLAG, TURN COORDINATORSDR JIKA201910312501Wire · sparksAMF FLT# 3361 - ENROUTE TO KBUF PILOT OBSERVED AN ELECTRICAL FLASH BEHIND THE TOP LEFT CORNER OF THE INSTRUMENT PANEL AND SMELLED ELECTRICAL SMOKE. PILOT FOLLOWED THE ABNORMAL CHECKLIST AND TURNED OFF BOTH WINDSHIELD HEAT SWITCHES AND NOTICED THE SMELL DISSIPSDR JIKA2019092301Fire Detector · inoperativePILOT DISCREPANCY, ENROUTE FROM KPDX TO KEUG DURING CRUISE FLIGHT A 9000’ MSL WHILE FLYING THROUGH LIGHT RAIN THE PILOT REPORTED THAT THE LEFT ENGINE FIRE WARNING LIGHT ILLUMINATED. THE PILOT DID NOT SEE ANY EVIDENCE OF AN ENGINE FIRE FROM THE LEFT ENGINE, THESDR JIKA2019070501Cam · bentDISCREPANCY: THE PILOT REPORTED JUST AFTER TAKE-OFF AND ON INITIAL CLIMB OUT FROM KPHX, THAT WHEN THE LANDING GEAR WAS SELECTED TO THE UP POSITION, THE GEAR HANDLE REMAINED ILLUMINATED (RED) INDICATING A GEAR UNSAFE CONDITION. THE PILOT CONTINUED AND BEGAN TO SDR JIKA2019060352901Boot · burned outDISCREPANCY: THE PILOT REPORTED AFTER TAKE OFF AND WHILE CLIMBING OUT THAT THE ANTI-ICE SYSTEMS WERE ACTIVATED. THEN FIRST OFFICER NOTED THE RIGHT ENGINE INLET GLOWING AND SPARKS EMANATING WITH A SMELL OF SMOKE IN THE COCKPIT. THE CREW PERFORMED AND AIR RETURNSDR JIKA2018111301Cap · unsecureMAINTENANCE DISCREPANCY: THE PILOT REPORTED WHILE IN CRUISE FLIGHT THAT THE LEFT ENGINE OIL PRESSURE WAS INDICATING 50 PSI (NORMAL OPERATING RANGE 70-90 PSI). THE PILOT FOLLOWING PROCEDURES NOTIFIED ATC, THEN PERFORMED AN INFLIGHT SHUT DOWN OF THE LEFT ENGINE.SDR JIKA20181106201Control Cable · out of positionMAINTENANCE DISCREPANCY: THE PILOT REPORTED WHILE IN CRUISE FLIGHT TO KPDX THAT THE LEFT ENGINE WAS UNABLE TO REDUCE TORQUE POWER SETTINGS. THE PILOT FOLLOWING PROCEDURES ELECTED TO SHUT THE LEFT ENGINE DOWN AND DECLARED AN EMERGENCY AND THEN LANDED WITHOUT INSDR JIKA2018121100501Landing Gear · collapsedUPON LANDING DURING THE ROLL OUT THE PILOT REPORTED THAT THE RIGHT MAIN LANDING GEAR COLLAPSED FOLLOWED BY THE LEFT MAIN AND NOSE GEAR COLLAPSING. THE PILOT FOLLOWED THE EMERGENCY PROCEDURES, SHUT DOWN THE AIRCRAFT AND EXITED. NO INJURIES REPORTED. MAINTENASDR TIMA2018092100000Warning Switch · out of adjustBAGGAGE DOOR ANNUNCIATOR ILLUMINATED DURING CLIMB. AIRCRAFT RETURNED TO ORIGINATING AIRPORT. MAINTENANCE ADJUSTED THE RT NOSE BAGGAGE DOOR SWITCH.SDR JIKA201809241801Actuator · defectiveON APPROACH INTO KPPA FROM KLBB, THE PILOT SELECTED GEAR DOWN AND DISCOVERED THE LEFT LANDING GEAR DID NOT DEPLOY. AFTER COMPLYING WITH THE QRH CHECKLIST, THE PILOT MANUALLY EXTENDING THE LANDING GEAR AND DECLARED AN EMERGENCY. THE LANDING AT KLBB WAS WITHOUT SDR TIMA201807100622Wire · shortedELECTRICAL SYSTEM FAILURE AFTER DEPARTURE. THE INVESTIGATION FOUND ANNUNCIATOR WIRE SHORTED TO STRUCTURE PREVENTING VISUAL INDICATION TO PILOT THAT THE GENERATORS WERE OFFLINE.SDR JIKA201806110601Diode · defectiveTHE PILOT REPORTED DURING FINAL, THAT THE GEAR HAD NO DOWN AND LOCKED INDICATION. THE PUSH TO TEST FOR GEAR WAS INOPERATIVE. PERFORMED MANUAL GEAR EXTENSION WITH GEAR HANDLE AND WAS ABLE TO VERIFY THAT ALL GEAR WAS IN THE DOWN POSITION. NO EMERGENCY WAS DECSDR JIKA2018040901Dipstick · unsecureTHE PILOT REPORTED DURING CRUISE AFTER DEPARTING KDFW THAT THE RIGHT ENGINE LOW OIL PRESSURE WARNING LIGHT ILLUMINATED. THE PILOT SHUT RIGHT ENGINE DOWN, DECLARED AN EMERGENCY, AND RETURNED TO KDFW WITHOUT INCIDENT. MAINTENANCE INSPECTED RIGHT ENGINE AND FOUNDSDR TIMA20180223004Tire · failedDURING POST-FLIGHT INSPECTION, FOUND A CHUNK OF RE-TREAD MISSING.SDR JIKA2017122801Light · defectiveTHE PILOT WAS APPROACH TO KPDX WHEN HE BEGAN TO SMELL SMOKE IN THE COCKPIT. DURING HIS SCAN HE NOTED THAT AROUND THE STALL HEAT AND PITOT HEAT SWITCHES WAS THE SOURCE OF THE SMOKE AND HE SAW A BRIGHT FLASH FROM THE ADJACENT AREA. HE QUICKLY TURNED THE SWITCHESSDR JIKA2017122701O-Ring · failedTHE PILOT WAS IN CRUISE TO KSLC WHEN HE DISCOVERED HIS RT BRAKE PEDAL COULD NOT BUILD PRESSURE TO APPLY THE BRAKES. THE PILOT INFORMED ATC AND DECLARED AN EMERGENCY, THEN LANDED WITHOUT INCIDENT AND NO RIGHT BRAKING POWER IN KSLC. THE PILOT WAS ABLE TO TAXI TOSDR JIKA2017120501Bonding Jumper · unsecureTOOK OFF AND WAS ON INITIAL CLIMB, NOTICED A FLASH AND SMELLED AN ODOR. RETURNED TO DEPARTURE AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED THE AIRCRAFT AND DISCOVERED THAT A BRAIDED AIRFRAME BONDING GROUND STRAP HAD CHAFED INTO A WIRE GOING TO THE PROPESDR JIKA2017100301Wire · looseTHE PILOT REPORTED, DURING APPROACH, SELECTED THE LANDING GEAR DOWN AND RECEIVED A THREE GREEN DOWN AND LOCKED INDICATION, WHEN SELECTED THE FLAPS TO FULL THE LANDING GEAR SELECTOR HANDLE ILLUMINATED, INDICATING A GEAR IN TRANSIT CONDITION. FOLLOWED PROC6EDSDR JIKA2017062701Governor · leakingTHE AIRCRAFT WAS IN CRUISE FLIGHT WHEN THE FLIGHT CREW REPORTED THAT THERE WAS A SMALL AMOUNT OF OIL LEAKING EXTERNALLY FROM THE RT COWLING BEHIND THE PROPELLER. NOTIFIED ATC AND RECEIVED A DIRECTIVE TO PROCEED STRAIGHT TO KABQ. THE RIGHT OIL PRESSURE BEGAN TOSDR TIMA20170606009Tire · separatedDURING LANDING ROLL THE TIRE TREAD SEPARATED FROM THE NR 2 MAIN LDG TIRE. THE TIRE WAS A RECAP.SDR JIKA201706120001Motor · failedTHE PILOT WAS ON APPROACH, WHEN THE LANDING GEAR WAS SELECTED DOWN, THERE WAS NO MOVEMENT OF THE GEAR AND NO INDICATION OF MOVEMENT. THE PILOT CALLED FOR A GO AROUND TO TROUBLESHOOT AND CYCLED THE LANDING GEAR AGAIN WITH THE SAME RESULT. ON THE THIRD ATTEMPTSDR JIKA2017052500001Wire · brokenDURING APPROACH, THE PILOT REPORTED THAT THE THREE LANDING GEAR DOWN AND LOCK INDICATOR LIGHTS WERE NOT ILLUMINATED WITH THE GEAR HANDLE IN THE DOWN POSITION. THE PILOT PERFORMED A MANUAL GEAR EXTENSION TO VERIFY GEAR WAS DOWN AND LOCKED AND LANDED WITHOUT INSDR TIMA20170503008Tire · separatedDURING LANDING ROLL THE TIRE TREAD SEPARATED FROM THE NR 3 MLG TIRE. TIRE WAS A RECAP.SDR JIKA2017042200001Actuator · failedON APPROACH TO KBFI AND SELECTED THE GEAR TO THE DOWN POSITION. MLG INDICATORS ILLUMINATED GREEN INDICATING A DOWN AND LOCKED INDICATION WHILE THE NOSE INDICATOR DID NOT ILLUMINATE. THE GEAR SELECT HANDLE ILLUMINATED RED SHOWING A GEAR IN UNSAFE CONDITION. AFTSDR JIKA2017022201Diode · failedON DESCENT INTO KBWD WHEN THE RT ENGINE OIL PRESSURE AND TEMPERATURE INDICATIONS BEGAN TO READ ZERO. FOLLOWED THE EMERGENCY PROCEDURES AND PERFORMED A PRECAUTIONARY SHUT DOWN OF THE RIGHT ENGINE. SELECTED THE LANDING GEAR TO THE DOWN POSITION THE LANDING GEAR SDR JIKA2017011701Motor · slowAFTER TAKE OFF, THE LANDING GEAR WAS SELECTED TO THE UP POSITION AND THE LANDING GEAR DID NOT RETRACT THE PILOT SELECTED THE GEAR HANDLE TO THE DOWN POSITION AND NOTED THAT ONLY THE LEFT AND RIGHT MAIN GEAR WERE INDICATING DOWN AND THE GEAR SELECTOR HANDLE RESDR JIKA2017010301Fire Detector · failedAFTER TAKE OFF , THE RIGHT FIRE WARNING T-HANDLE ILLUMINATED INTERMITTENTLY AND THEN STEADY. THE CREW TROUBLESHOT, BUT COULD NOT GET THE LIGHT TO EXTINGUISH, ALL ENGINE INDICATIONS WERE NORMAL AND VISUALLY THERE WERE NO SIGNS OF FIRE. RETURNED TO DEPARTURE SDR JIKA2016122401Dipstick · unsecureTHE TAKE OFF WAS NORMAL. THE PILOT REPORTED THAT AFTER LEVEL OFF IN CRUISE FLIGHT THE RIGHT ENGINE TORQUE INDICATION STARTED TO FLUCTUATE FOLLOWED BY A DROP IN OIL PRESSURE. THE PILOT SHUT DOWN THE RIGHT ENGINE, DECLARED AN EMERGENCY, RETURNED AND LANDED WITSDR 2017F00176Bolt · brokenDURING A SCHEDULED BORESCOPE OF THE RT ENGINE FOUND THE CT BLADES WERE FOUND TO BE DAMAGED DUE TO FOD. A POWER TURBINE CONTAINMENT SHROUD BOLT HEAD WAS FOUND BROKEN OFF AND STILL TIED WITH SAFETY WIRE. THE REMAINDER OF THE BOLT HAD VIBRATED OUT OF ITS HOLE ASDR AXSA2019112800001Bolt · failedDURING A SCHEDULED BOROSCOPE OF THE RT ENGINE, THE COMPRESSOR TURBINE BLADES WERE FOUND DAMAGED BY FOD AND A POWER TURBINE CONTAINMENT SHROUD BOLT HEAD WAS FOUND BROKEN OFF AND RETAINED BY SAFETY WIRE. THE REST OF THE BOLT BACKED OUT OF ITS THREADED HOLE AND PSDR JIKA2016110301Receiver · unsecureTHE PILOT DEPARTED KLBB AND IMMEDIATELY AFTER TAKEOFF THE DME INDICATOR AND THE NUMBER 2 COMM HAD ABNORMAL INDICATIONS, RESET BOTH UNITS BY TURNING THEM OFF AND BACK ON AND THE UNITS READ NORMALLY FOR ABOUT FIVE MINUTES THEN THE DISPLAYS OF BOTH UNITS BEGAN TOSDR JIKA2016102901Bearing · failedON THE ROLL-OUT AFTER AN UNEVENTFUL LANDING AT KMQY, THE PILOT REPORTED NO BRAKE AUTHORITY ON THE RT SIDE. DURING HIS POST FLT INSP IT WAS DISCOVERED THE NR 3 WHEEL TIRE ASSEMBLY WAS NOT PRESENT ON THE AC AND THE NR 3 BRAKE ASSEMBLY APPEARED TO BE LEAKING. MSDR TIMA20160822014Skin · corrodedTHE LEFT WING LEADING EDGE CENTER SECTION WAS FOUND TO HAVE CORROSION ON SKIN BETWEEN BONDED LAYERS DURING MAINTENANCE.SDR JIKA2016060901Downlock Switch · faultyON APPROACH, PILOT SELECTED THE LANDING GEAR HANDLE TO THE EXTEND POSITION, PILOT DID NOT RECEIVE 3 DOWN AND LOCKED INDICATOR LIGHTS. PILOT DECIDED TO PERFORM A MANUAL EXTENSION OF LANDING GEAR; PILOT RECEIVED 3 GREEN DOWN AND LOCKED INDICATOR LIGHTS AND LANDSDR JIKA2016042401Relay · shortedON FINAL APPROACH AFTER THE PILOT SELECTED THE LG TO THE DOWN POSITION AN ELEC SMELL WAS REPORTED. THEY LANDED WITHOUT INCIDENT & DURING TAXI TO PARKING THE SMELL BECAME STRONGER & SMOKE BEGAN TO FILL THE COCKPIT. THE PILOT STOPPED THE ACFT AT THE PARKING RASDR TIMA20160330007Rib · crackedDURING A WALK AROUND INSPECTION, A LOOSE WEIGHT WAS DISCOVERED ON THE OTBD EDGE OF THE LT ELEVATOR. INSPECTION REVEALED 2 CRACKS IN THE LT ELEVATOR LE RIB, AROUND THE INBD WEIGHT ATTACH NUTPLATES. THE RIB WAS REPLACED WITH A NEW RIB.SDR TIMA20160304004Torque Knee · crackedDISCOVERED A CRACK IN THE RT MLG UPPER TORQUE KNEE, DURING A SCHEDULED INSPECTION. THE CRACK WAS IN THE RADIUS TO THE SINGLE BOSS. REPLACED THE UPPER TORQUE KNEE WITH A NEW PART. CRACK DISCOVERED AT 2772 CYCLES SINCE OVERHAUL.SDR TIMA20160227003Battery · weakSHORTLY AFTER LEVEL OFF, BOTH FUEL QTY INDICATORS SHOWED ZERO FUEL. PILOT ELECTED TO RETURN TO TAKEOFF LOCATION. TROUBLESHOOTING REVEALED A LOW VOLTAGE CONDITION DUE TO A WEAK ACFT BATTERY.SDR JIKA2016022301Fuel Control · stickingON APPROACH, THE PILOT COULD NOT REDUCE THE POWER BELOW 1100 LBS TQ ON THE RT ENGINE. AT APPROX 10 MILES OUT THE PILOT PERFORMED AN INFLIGHT SHUTDOWN OF THE RT ENGINE & LANDED WITHOUT INCIDENT. FOUND THE FUEL CONTROL STICKING AT 1100 LBS TORQUE. R & R FUEL SDR JIKA2016013101Circuit Breaker · openAPPROACHING, THE PILOT REPORTED THAT THE LG DID NOT RECEIVE 3 GREEN DOWN & LOCKED INDICATION WITH THE GEAR HANDLE IN THE DOWN POSITION. THE PILOT PERFORMED THE EMER EXTENSION PROCEDURES & CONFIRMED THE LG WAS DOWN & LOCKED. THE PILOT DECLARED AN EMER & LANDESDR JIKA2015120101Motor · faultyON APPROACH, THE PILOT SELECTED THE LG HANDLE TO THE EXTEND POSITION, THE LG WOULD NOT EXTEND & THE TIME DELAY RELAY CB POPPED. THE PILOT TRIED TO RESET THE CB WITH THE SAME RESULTS. THE PILOT PERFORMED A MANUAL EXTENSION OF THE LG & RECEIVED A THREE GREEN DSDR JIKA201510291501Downlock · brokenON APPROACH TO AIRPORT, THE PILOT EXTENDED THE LG & DID NOT RECEIVE A DOWN & LOCKED INDICATOR LIGHT ON THE RT MLG, THE RED GEAR UNSAFE LIGHT WAS ILLUMINATED & THE GEAR WARNING HORN WAS SOUNDING BELOW 84% RPM. THE PILOT PERFORMED AN EMER LG EXTENSION PROCEDURESDR JIKA2015093002Motor · faultyON APPROACH, WHEN PILOT SELECTED LG HANDLE TO THE EXTEND POSITION, THE LG CONTROL CB POPPED. PILOT DECIDED TO DIVERT & PERFORMED AN EMER MANUAL EXTENSION OF THE LG. PILOT LANDED WITHOUT FURTHER INCIDENT. TROUBLESHOOTING REVEALED FAULTY LG MOTOR. REPLACED LSDR JIKA2015092501Control Arm · obstructedON FINAL, THE RT ENG POWER STUCK AT 800 LBS TORQUE & WOULD NOT ADJUST. PILOT DECIDED TO SHUT DOWN RT ENG. PILOT FOLLOWED PROCEDURES IN PILOT OPERATING HANDBOOK & PERFORMED A PRECAUTIONARY ENG SHUTDOWN. PILOT LANDED WITHOUT FURTHER INCIDENT. INSPECTION REVESDR JIKA2015091101Unknown · malfunctionedDURING CRUISE FLIGHT, THE PILOT OBSERVED THE LT ENG OIL TEMP WAS HIGHER THAN NORMAL & APPEARED TO BE APPROACHING THE RED LINE. PERFORMED A PRECAUTIONARY IN FLIGHT SHUT DOWN OF THE LT ENG & LANDED WITHOUT INCIDENT. INSPECTED THE LT ENG OIL FILTER, OIL COOLER
Back to Beech C-99