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 = '205A1' 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 = '205A1' 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 CA980521006Support · cracked(CAN) CRACK FOUND ON ONE OF THE EARS WHICH MOUNTS THE LIFT LINK ASSY. CRACKED FROM BOLT HOLE TO EDGE.SDR CA980512002Bearing · overheated(CAN) AFTER 1.2 HOURS TSN, BEARING HOTTER THAN NORMAL. BEARING ASSY REMOVED. TEARDOWN REVEALED THE SEAL FACE HAD STARTED TO TURN BLUE. BEARING ITSELF WAS SMOOTH AND HAD NO ROUGH SPOTS.SDR 98ZZZX2880Shroud · crackedIT WAS NOTED DURING OPERATION, ENGINE EGT WAS OBSERVED TO BE ABOVE NORMAL. UPON TEARDOWN OF HOT SECTION, THE FIRST STAGE TURBINE NOZZLE OUTER SHROUD WAS FOUND SEVERELY CRACKED. (X)SDR CA980421004Bearing · rough(CAN) VIBRATION FROM OIL COOLER BLOWER. BOTH BEARINGS DRY AND ROUGH RUNNING. BEARING SEALS BROKEN.SDR CA980504001Blade · cracked(CAN) BLADE CRACKED ON BOTH SKINS AT 77.25 INCHES FROM TIP T/E. CRACK IS 15 INCHES CHORDWISE FORWARD FROM TRAILING EDGE THEN INBOARD 9 INCHES TOP AND BOTTOM.SDR CA980305002Nut · loose(CAN) DURING DISASSEMBLY OF THE ENGINE DUE TO ICE INGESTION, THE CARRIER ASSEMBLY WAS PULLED. CLOSER INSPECTION REVEALED THAT THE BEARING RETAINING NUT WAS SPINNING FREE (NO TORQUE) ON HE GEARSHAFT, HELD BY ONLY ONE TANG OF THE KEYWASHER. THE GEAR IN QUESTION SDR CA980403008Tube Assembly · broken(CAN) TUBE ASSEMBLY, PURGE SYSTEM, FOUND BROKEN AT THE BRAZING. THIS ASSEMBLY IS IN THE FUEL STARTING SYSTEM.SDR 97ZZZX4895Lockcup · crackedFOLLOWING DISASSEMBLY OF ENGINE FOR METAL CONTAMINATION, DISCOVERED 2 EACH OF THE LOCKCUPS HAD FAILED. CUPS CRACKED AND SPLIT AT THE LOCKING TANGS WHICH ENGAGE THE PLANETARY GEARSHAFTS. THE RETAINING NUTS WHICH THE LOCKCUPS RETAIN, REMAINED IN PLACE AND THE SDR CA971231024Fuel Cell · peeling(CAN) WHEN RIGHT HAND FUEL SUMP DRAINED, BLACK PARTICLES WERE FOUND. RUBBER COATING OF THE FUEL CELL HAD PEELED OFF.SDR 97ZZZX4824Blade · failedWHILE CARRYING OUT OPERATIONS ON THE AFTERNOON OF 10-23-97, PILOT REPORTED INCREASE OF VIBRATION WHILE IN-FLIGHT RETURNING TO LANDING SITE. AIRCRAFT WAS SHUT DOWN. ON EXAMINATION OF TAIL ROTOR, INSIDE PART OF TIP WAS FOUND MISSING. NO OTHER DAMAGE WAS APPARSDR 97ZZZX4823Oil Pump · failedPILOT REPORTED LOSS OF OIL PRESSURE IN-FLIGHT. THE FLIGHT WAS TERMINATED IMMEDIATELY AND THE ENGINE WAS SHUT DOWN. UPON INVESTIGATION, THE ENGINE OIL PUMP DRIVESHAFT WAS FOUND BROKEN. WHEN PUMP WAS REMOVED, A PIECE OF GEAR TOOTH FELL FROM PUMP OIL PASSAGE. SDR CA970916001Spar · cracked(CAN) FOUND CRACK ORIGINATING FROM A RIVET HOLE TO THE EDGE OF THE SPAR AND ANOTHER CRACK FROM RIVET HOLE INBOARD PER AD 97-18-01.SDR CA970716001Tube · chafed(CAN) AIRCRAFT LOST HYDRAULIC POWER. HOSE WAS CLAMPED TO A FLEX HOSE ASSY AND THE RELATIVE MOVEMENT BETWEEN THE TWO ALLOWED THE TUBE TO CHAFE. IN-FLIGHT, THE MASTER CAUTION SHOWED LOW HYDRAULIC FLUID AND THE CREW COULD ALSO SMELL FLUID THAT WAS LEAKING FROM SDR CA970526001Actuator Lever · worn(CAN) DURING INSPECTION EXCESSIVE PLAY WAS FOUND ON THE INLET GUIDE VANES. FURTHER INSPECTION FOUND THE STRUT PIN HOLES WERE WORN.SDR CA970114002Gp Section · damaged(CAN) AIRCRAFT LANDED AND ENGINE WAS SHUTDOWN. ON THE NEXT START THE ENGINE WAS GOING TO A HOT START, SO THE START WAS ABORTED. ON THE SECOND START ATTEMPT AN ENGINE VIBRATION WAS FELT AND THE EGT BEGAN TO RISE RAPIDLY AND COULD NOT BE CONTAINED BY CUTTING OFFSDR CA960916007Skin · debonded(CAN) MAIN ROTOR BLADE UPPER AND LOWER SKINS DEBONDED FROM TRAILING EDGE EXTRUSION FOR 66 INCHES FROM THE TIP INBOARDSDR CA960919006Engine · failed(CAN) THE HELICOPTER WAS ON THE INITIAL GROUND RUN AFTER A 1000 HOUR INSPECTION. THE AIRCRAFT WAS RUNNING IN FLIGHT IDLE FOR APPROXIMATELY 10 MINUTES AND ALL PARAMETERS WERE NORMAL. THE PILOT ACCELERATED THE ENGINE TO MAX POWER TURBINE (N2) SPEED TO ESTABLISH SDR CA960909023Fitting · cracked(CAN) LIFT BEAM ASSEMBLY FITTING CRACKED AT THE HOLE ON THE AFT EAR.SDR CA960909002Blade · cracked(CAN) BLADE TOP SKIN CRACKED AT STATION 203 5 CRACKED APPROXIMATELY 6 INCHES FROM SPAR REARWARDSDR CA960412011Output Shaft · cracked(CAN)DURING PREMATURE OVERHUAL INCLUDING A MAGNAFLUX OF THE OUTPUT DRIVESHAFT, A CRACK WAS DETECTED ON THE SHAFT IN THE TAIL ROTOR CONE AREA, JUST INBOARD OF THE SPLINES SUPPORTING THE TAIL ROTOR YOKE. THECRACK EXTENDED FOR 0.5 INCHES IN A CIRCUMFERENTIAL DIRESDR CA960412010Drag Brace · cracked(CAN) DURING A SCHEDULED 1200 HOUR INSPECTION OF THE DRAG BRACE ASSEMBLY, THE NUT 204-011-144-003 WAS FOUND TO HAVE A LONGTITUDINAL CRACK ACROSS THE OUTSIDE SURFACE.SDR CA960418002Retainer · broken(CAN)LOCKING TANG OF CUP WASHER RETAINER BROKEN. NUT LOST TORQUE AND FELL-OFF FROM GEARSHAFT CAUSING GEAR TO SHIFT AND DISENGAGE INTERMITTENTLY. NUT AND RETAINER FROUND IN NOSE HOUSING.SDR CA960329003Engine · failed(CAN)N2 FAILURE, N2 INDICATOR FLUCTUATED, NR ENGINE WARNING ON.SDR CA960227011Spur Gear · broken(CAN) ENG ACCESSORY DRIVE FAILED. ENGINE REPAIRED.SDR CA960205010Engine · faulty(CAN)N2 FAILURE. #N2 INDICATION. CHIP DETECTOR LIGHT CAME ON. METAL FOUND IN AIRFRAME OIL FILTER. NO METAL IN ENGINE FILTER.SDR CA960116101Fitting · cracked(CAN)LOWER LEFT TAILBOOM ATTACHMENT FITTING CRACKED. STA 243.116 WL35.17. CRACK RUNNING FROM BOLT HOLE TO OUTER EDGE.SDR CA960206101Bolt · sheared(CAN)THE DRIVE LINK WAS BEING REMOVED TO REPLACE THE TRUNNION BEARING IN THE SWASHPLATE OUTER RING ASSEMBLY. THE BOLT HEAD SHEARED OFF UPON DISASSEMBLY.SDR CA960123101Drive · failed(CAN)ENGINE HAD CATASTROPHIC FAILURE, AIRCRAFT DESTROYED. ACCIDENT HAPPENED IN AUSTRALIA AND IS BEING INVESTIGATED BY BUREAU OF AIR SAFETY INVESTIGATION, FILE #9504205. PRELIMINARY OBSERVATIONS INDICATE FA ILURE OF N2 GEARBOX DRIVE.SDR CA951209104Diffuser Housing · cracked(CAN)ON DAILY INSPECTION IT WAS FOUND THAT THE PAN HAD CRACKED AROUND THE INSERT.SDR CA951209103Diffuser Housing · cracked(CAN)ON DAILY INSPECTION IT WAS FOUND THAT THE PAN HAD CRACKED AROUND THE INSERT.SDR CA960122015Spur Gear · broken(CAN)SPUR GEAR BROKEN IN TWO PIECES.SDR CA951219105Main Case · cracked(CAN) CRACK FOUND ON WEB ABOVE INPUT BORE.
Back to Bell 205A-1