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 = '400A' 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 = '400A' 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 9JLA2021100630732Indicator · false indicationTHE FLIGHT CREW REPORTED THE RIGHT ENGINE ITT INTERMITTENTLY READING 150 DEGREES HIGHER THAT THE LEFT AT HIGH POWER SETTINGS WITH NOW OTHER INDICATIONS OF ISSUES. THE MAINTENANCE VENDOR REMOVED AND REPLACED THE RIGHT TURBINE TEMP INDICATOR WITH OVERHAULED UNITSDR 9JLA2021100630733Control Cable · defectiveTHE FLIGHT CREW REPORTED THAT THE NO1 ENGINE REQUIRES FIREWALL THRUST TO MAKE TAKEOFF POWER. SPLIT IN LEVERS AND AT IDLE N2 IS OVER 56%. THE MAINTENANCE VENDOR REMOVED AND REPLACED THE NO1 ENGINE AFT CONTROL CABLE (52" CABLE) WITH NEW CABLE. COMPLIED WITH ENGISDR 9JLA2021093030730Actuator · intermittentTHE MAINTENANCE TEAM REPORTED THAT THE RIGHT ROLL TRIM ACTUATOR WAS INTERMITTENT. THE DEFECTIVE TRIM ACTUATOR WAS REMOVED AND REPLACED WITH AN OVERHAULED UNIT. OPS CHECKS SATISFACTORY AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR OEJA2021101500001Seal · leakingCABIN ALTITUDE WAS HIGHER THAN NORMAL, NOTICED THE CABIN RATE CLIMBING @ 1000' PER MIN. THEN HEARD A WHISTLING NOISE CLOSE TO THE CABIN DOOR. "CABIN PRESS LD" LIGHT CAME ON. ONCE WE REACHED BELOW 20,000' THEN THE NOISE GOT QUIETER AFTER WE SELECTED "BOTH HSDR 9JLA2021100630727Control Cable · out of adjustTHE FLIGHT CREW REPORTED THAT BEFORE BRAKE RELEASE FOR TAKEOFF THAT THE NO1 ENGINE WAS NOT MAKING MINIMUM TAKEOFF POWER REQUIREMENTS. THE TAKEOFF ATTEMPT WAS ABORTED. THE MAINTENANCE VENDOR CONFIRMED THE POWER KNOB SPILT AND LACK OF N1 TARGET FOR THE DAY. THE SDR 9JLA2021100630725Control Valve · defectiveTHE FLIGHT CREW REPORTED THAT THE COCKPIT TEMP CONTROL SYSTEM WOULD NOT WARM WHEN TURNED FULLY HOT. ONLY BLOWS COLD AIR. THE MAINTENANCE TEAM FOUND THE COCKPIT TEMP CONTROL VALVE WAS DEFECTIVE AND WAS REPLACED WITH A NEW VALVE. OPS CHECKS WERE SATISFACTORY ANDSDR 9JLA2021100623873Motor · defectiveTHE FLIGHT CREW REPORTED THE FREON COMPRESSOR CIRCUIT BREAKER TRIPPED TWICE. THE CORRECTIVE ACTION WAS DEFERRED PER MEL 21-50-01. THE MAINTENANCE VENDOR THEN FOUND THE AC MOTOR WAS FAULTY. THE MOTOR WAS REMOVED AND REPLACED WITH AN OVERHAULED UNIT. OPS CHECKS SDR E0YA2021091600004Pump · failedSTARTED DESCENDING INTO KPHL WE NOTICED THE HYDRAULIC GAUGE WENT UP PAST RED LINE (HIGH HYDRAULIC PRESSURE). PULLED OUT THE CHECKLIST AND AS PER THE CHECKS PERFORMED A HYDRAULIC SYSTEM RELIEF WHICH HAD US DO AN EMERGENCY GEAR EXTENSION, NO FLAP LANDING AND POWSDR 9JLA2021091323871Controller · defectiveTHE FLIGHT CREW REPORTED THE HORIZONAL STAB HEAT FAIL ANNUNCIATOR ILLUMINATED 3 SECONDS AFTER TURNING ON STAB HEATING SYSTEM AT FL350. NO VISIBLE MOISTURE. THE MAINTENANCE VENDOR TROUBLESHOT AND FOUND THE HORIZONTAL STAB DE-ICE CONTROLLER DEFECTIVE. THE DEFECTSDR 9JLA2021090230721Pressure Switch · defectiveDURING PREFLIGHT CHECKS BY THE MAINTENANCE TEAM IT WAS DISCOVERED THE LEFT ENGINE OIL FILTER BYPASS ANNUNCIATOR WAS ILLUMINATED. IT WAS DISCOVERED THAT THE LEFT ENGINE OIL FILTER BYPASS PRESSURE SWITCH WAS DEFECTIVE. IT WAS REPLACED WITH A SERVICEABLE UNIT. OPSDR 2021FA0000242Duct · deformedAIR CRAFT LOST PRESSURIZATION AT IN FLIGHT AND HAD TO EMERGENCY DESCENDSDR 9JLA2021090224792Shutoff Valve · defectiveTHE FLIGHT CREW REPORTED THAT DURING PREFLIGHT CHECKS THE RIGHT FUEL SHUT OFF VALVE FAILED TESTING. THIS CAUSED THE CANCELLATION OF FLIGHT. THE MAINTENANCE TEAM DETERMINED THE RIGHT FUEL SHUTOFF VALVE WAS DEFECTIVE. THE VALVE ASSY WAS REMOVED AND AN OVERHAULEDSDR 9JLA2021081924792Shutoff Valve · failedTHE FLIGHT CREW FOUND DURING PREFLIGHT CHECKS THAT THE RIGHT FUEL SHUT OFF VALVE FAIL PREFLIGHT TESTS. THE MAINTENANCE TEAM REMOVED THE FAILED FUEL SHUTOFF VALVE AND REPLACED IT WITH AN OVERHAULED VALVE. OPERATIONAL AND LEAK CHECKS WERE SATISFACTORY. THE AIRCRSDR 9JLA2021081023865Protector · defectiveTHE FLIGHT CREW REPORTED THAT DURING FLIGHT THE EMERGENCY BUS FDR AND BATTERY CUT OFF LIGHTS ILLUMINATED. NO VOLTAGE WAS INDICATED ON THE VOLTAGE METER. THE MAINTENANCE TEAM TROUBLESHOT AND DETERMINED A DC GROUND FAULT PROTECTION PAN P/N 50284-003 S/N P1198C. SDR 2021F00213Warning Message · illuminatedON TAKE OFF RUN RECEIVED LEFT ENGINE OIL FILTER BYPASS LIGHT AT APPROXIMATELY 55KIAS.SDR 9JLA2021073034788Blower · intermittentFLIGHT CREW REPORTED THAT THE COCKPIT VAPOR CYCLE AIRCON BLOWER INTERMITTENT INOP. TRIP WAS DELAYED. OPERATIONS CONTINUED PER MEL. THE MAINTENANCE VENDOR ACTIVATED AIRCON SYSTEM AND RAN BLOWER FOR .5HR TROUBLESHOT AND FOUND LOOSE TERMINAL ON BLOWER SWITCH. RETSDR 9JLA2021080527037Computer · faultedTHE FLIGHT CREW REPORTED THE ANGLE OF ATTACK INDICATOR (AOA) WAS INOP. OPERATIONS CONTINUED MEL DEFERRAL. THE MAINTENANCE TEAM TROUBLESHOT AND FOUND A FAULT WITH THE RIGHT STALL WARNING COMPUTER. THE COMPUTER WAS REMOVED AND A SERVICEABLE COMPUTER WAS INSTALLESDR 9JLA2021080527087Static Inverter · failedTHE FLIGHT CREW REPORTED THAT THE NO2 INVERTER WAS INTERMITTENTLY FAILING DURING FLIGHT. THE MAINTENANCE TEAM REMOVED AND REPLACED THE NO2 INVERTER WITH INSPECTED UNIT. OPERATION CHECKS WERE SATISFACTORY. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR 9JLA2021072827088Heater · defectiveTHE FLIGHT CREW REPORTED THAT THE LEFT WINDSHIELD WILL NOT HEAT UP PROPERLY. THE LEFT OVERHEAD TEMP CONTROL LIGHT WILL NOT ILLUMINATE IN ANY OPERATION. WHEN SYSTEM IS TURNED ON, THE CREW STATED THEY WERE NOT ABLE TO SEE THROUGH THE DISTORTED VIEW. ONLY A 3 INCSDR 9JLA2021072830716Seal · leakingTHE FLIGHT CREW REPORTED THAT WHEN LANDING THE DOOR SEAL STARTED LEAKING, DIFFERENTIAL PRESSURE WOULDN'T HOLD MORE THAN 7.0 PSI. BELOW 6.0 PSI SOUND OF LEAK SUBSIDED. THE MAINTENANCE VENDOR REMOVED THE INFLATABLE MAIN CABIN DOOR SEAL AND INSTALLED NEW INFLATABSDR 9JLA2021072723860Rccb · failedTHE FLIGHT CREW REPORTED THAT DURING TAXI OUT FOR DEPARTURE THE RIGHT BUS TIE CIRCUIT BREAKER TRIPPED. THE FLIGHT CREW ELECTED TO RETURN TO BLOCKS FOR MAINTENANCE CONSIDERATIONS. THE MAINTENANCE VENDOR TROUBLESHOT AND DETERMINED THAT THE RIGHT BUS TIE REMOTE CSDR IZ2R2021062320210Cable · brokenDURING A SCHEDULED MAINTENANCE INSPECTION, IT WAS NOTICED THAT THE RIGHT FLAP OUTBOARD CABLE DID NOT HAVE TENSION AND THE FLAP FORWARD CABLE WAS TOUCHING THE RIGHT-WING REAR SPAR. FURTHER INVESTIGATION REVEALED THAT THE CABLE WAS BROKEN FROM THE SWAGED FITTINSDR 9JLA2021060334968Support Bracket · crackedTHE FLIGHT CREW REPORTED THAT THE CABIN ENTRY STEPS SIDE SUPPORT BRACKET (PART THAT SUPPORTS STAIRS UNDER/AGAINST FUSELAGE) IS RUBBING ALONG BODY, SCRATCHING PAINT AND NOT ALIGNING WITH SUPPORT STOP. THE MAINTENANCE TEAM DETERMINED THAT THE SIDE STAY SUPPORT HSDR CVGA20210601001Mixing Valve · intermittentLOSS OF BRAKE PRESSURE ON ALL BRAKE PEDALS AFTER LANDING. BRAKE PRESSURE DID COME BACK AFTER ABOUT 1O SECONDS. HYDRAULIC PRESSURE WAS IN THE GREEN.SDR 9JLA2021060419001Wire · brokenTHE FLIGHT CREW REPORTED THAT IN-FLIGHT THE RIGHT ELECTRONIC FUEL CONTROL (EFC) ANNUNCIATOR ILLUMINATED. THEY RESET IT PER THE CHECKLIST, BUT WOULD NOT RESET. RIGHT N1 HAD ASSOCIATED DROP. THE MAINTENANCE VENDOR TROUBLESHOT AND FOUND THE RIGHT ENGINE T-O PROBESDR 9JLA2021052729346Protector · faultyFLIGHT CREW REPORTED THAT THE BATTERY FEED TEST DID NOT TEST CORRECTLY DURING PREFLIGHT CHECKS, FLIGHT WAS CANCELLED. THE MAINTENANCE VENDOR TROUBLESHOT AND FOUND A FAULTY BATTERY FEEDER PROTECTOR UNIT P/N 50284-003 S/N 98054. THE UNIT WAS REMOVED AND A NEW UNSDR 9JLA2021051834961Relay · failedTHE FLIGHT CREW REPORTED UPON AIRCRAFT SHUTDOWN FOUND THE MFD NO1 REMAINED POWERED ON AFTER AIRCRAFT BATTERIES WERE TURNED OFF. THE MAINTENANCE VENDOR TROUBLESHOT AND FOUND RELAYS 3931K3 AND 3931K4 DEFECTIVE. THE RELAYS WERE REPLACED WITH NEW. FUNCTIONAL CHECKSDR 9JLA2021051829344Oxygen Mask · brokenTHE FLIGHT CREW REPORTED THAT A SMALL PIECE OF CO-PILOTS OXYGEN MASK SEPARATED FROM THE MASK ASSEMBLY. THE PLANNED FLIGHT WAS CANCELLED. THE MAINTENANCE TEAM REMOVED THE DEFECTIVE CO-PILOTS OXYGEN P/N 174252-92 S/N10710 AND INSTALLED AN OVERHAULED MASK ASSEMBLSDR 9JLA2021052728380Master Switch · defectiveTHE FLIGHT CREW REPORTED THAT THE EMERGENCY BATTERY WOULD NOT DISCONNECT WHEN SELECTED OFF. THE MAINTENANCE VENDOR TROUBLESHOT AND SUSPECTED THE RIGHT GENERATOR MASTER SWITCH P/N MS24524-23 TO BE DEFECTIVE. THE DEFECTIVE MASTER SWITCH WAS REMOVED AND INSTALLEDSDR CVGA20210507001Circuit Breaker · intermittentEXPERIENCED TOTAL LOSS OF CAPTAINS SIDE PFD, MFD, AND #1 FMS AND AUTOPILOT. YAW DAMPER.SDR 9JLA2021041624289Skin · crackedTHE MAINTENANCE TEAM DISCOVERED DURING THE POSTFLIGHT CHECKLIST THE LEFT PYLON LOWER SHIN HAD A 3 INCH LONG CRACK. THE LEFT LOWER PYLON PANEL WAS REMOVED, A REPAIR WAS FABRICATED AND INSTALLED ON THE PYLON PANEL. THE PANEL WAS REINSTALLED ONTO AIRCRAFT AND THESDR 9JLA2021041624768Pressure Sensor · faultyTHE FLIGHT CREW REPORTED THAT DURING FLIGHT THE ANGLE OF ATTACH INDICATOR (AOA) WAS NOT FUNCTIONING PROPERLY. THE MAINTENANCE PROVIDER TROUBLESHOT AND DETERMINED THE LEFT PRESSURE SENSOR HAD FAILED. THE FAULTY SENSOR WAS REMOVED AND REPLACED WITH A NEW PRESSURSDR 9JLA2021040524765Transmitter · faultedTHE FLIGHT CREW REPORTED THAT DURING PREFLIGHT CHECKS THAT THE LEFT ENGINE FUEL FLOW INDICATOR WAS READING ZERO WITH THE ENGINE RUNNING. THIS DISCREPANCY CAUSED THE FLIGHT TO BE CANCELLED. THE MAINTENANCE VENDOR TROUBLESHOT AND DETERMINED THAT THE LEFT ENGINE SDR AHTA20210408001Windshield · brokenJUST AS WE HAD LEVELED OFF AT 17,000 FEET AT APPROXIMATELY 1820Z ABOUT 100 MILES SOUTH OF ORL WE HEARD A VERY LOUD BANG AND THE PILOT SIDE WINDSCREEN HAD COMPLETELY SHATTERED THE OUTER GLASS PANE. WE WERE BETWEEN LAYERS IN CLEAR AIR. IT WAS A VERY WARM DAY, PRSDR 2021FA0000289Igniter · crackedREMOVED IGNITER FOR INSPECTION, FOUND A CRACK 180 DEGREES AROUND THE BASE OF THE IGNITER ABOVE THE THREADS AND BELOW THE HEX AREA.SDR 9JLA2021033034755Pcb · defectiveTHE FLIGHT CREW REPORTED THAT THE LEFT BOOST PUMP LIGHT WOULD NOT EXTINGUISH DURING BEFORE TAXI CHECKS. MOMENTARY FLASH OF LEFT FUEL PRESSURE LOW ANNUNCIATOR WHEN CYCLING THE BOOST PUMP SWITCH. THE MAINTENANCE TECH DETERMINED THE CIRCUIT CARD ASSY WAS DEFECTIVSDR 9JLA2021030430702Asymmetry Switch · defectiveTHE FLIGHT CREW REPORTED RECEIVING AN INTERMITTENT CAUTION LIGHT FLAP ASYMMETRY ANNUNCIATOR IN ALL PHASES OF FLIGHT. YELLOW MASTER CAUTION ASSOCIATED. THE MAINTENANCE TEAM TROUBLESHOT AND DETERMINED THAT THE LEFT FLAP FOLLOW UP SWITCH WAS DEFECTIVE. THE DEFECTSDR WI5R2021021600001Turbine Blades · separatedFLIGHT CREW REPORTED THAT DURING CRUISE FLIGHT AT FL410, RIGHT-HAND ENGINE SERIAL NUMBER 252736 EXHIBITED AN UNUSUAL NOISE ANOMALY ACCOMPANIED BY RISE IN INTER-TURBINE TEMPERATURE, VIBRATION, AND BLEED ODOR IN THE COCKPIT. AS A PRECAUTIONARY MEASURE, THE FLIGSDR 9JLA2021021227023Anti-Ice Valve · defectiveTHE FLIGHT CREW REPORTED A RIGHT ENGINE TEMP LOW ANNUNCIATOR WHILE IN FLIGHT AND REMAINED ILLUMINATED WITH N2 AT 82%. THEY INDICATED THE ITT DID SHOW A RISE DURING SWITCH OPERATION. THE MAINTENANCE TEAM TROUBLESHOT AND DETERMINED THE ENGINE ANTI-ICE VALVE WAS SDR 9JLA2021120224278Seal · deterioratedTHE FLIGHT CREW REPORTED THAT THE HSTAB ICE FAIL ANNUNCIATOR ILLUMINATED IN FLIGHT. OPS CHECKS ON THE GROUND WAS NORMAL. THE MAINTENANCE TEAM TROUBLESHOT AND FOUND NUMEROUS AREAS OF DETERIORATING AND MISSING SEALANT ON LEADING EDGES, HEATED HORNS AND VERTICAL SDR MGOR20210209001Cable · corrodedUPON DEPARTURE, FLIGHT CREW LEVELED OFF AT 5000 FEET MSL TO VERIFY PROPER FLAP OPERATION. IN LEVEL FLIGHT 160KTS OF AIRSPEED, RECEIVED "FLAP ASYMMETRY" INDICATION AFTER EXTENDING FLAPS 20 DEGREES TO 30 DEGREES. UPON TAXI IN, FLAP ASYM EXTINGUISHED AND FLAPS SESDR 9JLA2021020324276Link · brokenTHE FLIGHT CREW REPORTED THAT THE MAIN ENTRY DOOR STEP LINK BROKE DURING USE. THE MAINTENANCE TEAM REPLACED THE STEP LINK WITH A NEW CONDITION LINK. THE AIRCRAFT WAS RETURNED TO SERVICE. THIS IS A VERY COMMON PROBLEM WITH THE BEECHJET AND COULD CAUSE HARM IF SSDR 9JLA2021010827018Skin · damagedDURING PREFLIGHT CHECKS THE MAINTENANCE TEAM DISCOVERED ELEVATOR SKIN DAMAGE NEAR THE MIDDLE HINGE ON THE BOTTOM SIDE. INVESTIGATION DETERMINED THAT THIS DAMAGE WAS CAUSED WHEN A MAINTENANCE VENDOR COMPLETING INSPECTION CHECKS ON THE HORIZONAL STAB, INSTALLEDSDR S2KA202101040001Console · smokeDURING FLIGHT A SMALL AMOUNT OF SMOKE CAME FROM CENTER PEDESTAL WHEN INTEG LIGHTS WERE TURNED ON. WHEN INTEG SWITCH WAS TURNED OFF SMOKE DISSIPATED. NO CIRCUIT BREAKERS POPPED.SDR 9JLA2021010828358Transponder · malfunctionedIT WAS REPORTED FROM AIR TRAFFIC CONTROL (ATC) THAT THE AIRCRAFTS NR 1 TRANSPONDER SYSTEM WAS NOT TRANSMITTING MODE C ON MULTIPLE LEGS. THE MAINTENANCE VENDOR FUNCTIONAL CHECKED THE SYSTEM AND WAS NOT ABLE TO VERIFY THE DISCREPANCY ON THE GROUND. ALL TESTINGSDR 9JLA20201209Warning Message · false activationTHE FLIGHT CREW REPORTED THAT DURING FLIGHT THE "LEFT BOOST PUMP" ANNUNCIATOR ILLUMINATED. THE CREW RAN THE LOSS OF PUMP CHECKLIST AND COMPLETED THE FLIGHT. THE MAINTENANCE VENDOR PERFORMED AN OPERATIONS CHECK OF THE LT BOOST PUMP, PER THE AMM WITH NO DEFECTSDR 9JLA2020120920341Starter Gen · defectiveA FLIGHT WAS CANCELLED AFTER THE FLIGHT CREW WAS UNABLE TO START THE NR 1 ENGINE. THE FLIGHT CREW PUSHED THE STARTER BUTTON AND NOTED NO ENGINE ROTATION. THE MAINTENANCE VENDOR TROUBLE SHOT AND DETERMINED THAT THE NR 1 STARTER/GENERATOR WAS DEFECTIVE. THE SSDR 9JLA2020120927175Motor · defectiveFLIGHT CREW REPORTED THAT DURING GROUND OPERATIONS THAT THE VAPOR CYCLE AIR CONDITIONING SYSTEM CIRCUIT BREAKER TRIPPED. THE MAINTENANCE VENDOR DETERMINED THAT THE AIR CONDITIONING COMPRESSOR MOTOR WAS DEFECTIVE AND INSTALLED AN OVERHAULED MOTOR. P/N 1134014SDR 9JLA20201202Igniter · wornA FLIGHT WAS CANCELLED WHEN THE FLIGHT CREW WAS UNABLE TO ACHIEVE NR 2 ENGINE START. THE FLIGHT CREW REPORTED THAT THE ENGINE FAILED TO LIGHT OFF. THE MAINTENANCE VENDOR DETERMINED THAT THE IGNITOR PLUGS WERE WORN AND REQUIRED TO BE REPLACED. THE VENDOR REPSDR 9JLA2020120220338Starter Gen · defectiveA FLIGHT WAS CANCELLED DUE TO THE RIGHT ENGINE WOULD NOT START. THE FLIGHT CREW REPORTED THAT THE ENGINE STARTER WOULD SPIN, BUT WAS NOT ENGAGED WITH THE ENGINE FOR ROTATION. THE MAINTENANCE VENDOR TROUBLESHOT AND DETERMINED THAT THE STARTER/GENERATOR WAS DE
Back to Beech 400A