N205US, cancelled May 9, 2023
Service difficulty reports · 20
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 = 'N205US' AND deregistration_id = 'N205US-2023-05-09' 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 = 'N205US' AND deregistration_id = 'N205US-2023-05-09' 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 Y2PA2018092530030Pitot Tube · obstructedCREW REPORTED 60 KNOT AIRSPEED DISCREPANCY DURING CLIMB. RAN COM 5.31.5 WITH NO SUCCESS. RETURNED TO KLRD AND DECLARED EMERGENCY. NO FURTHER INCIDENT. MAINTENANCE AT KLRD DISCONNECTED CAPT/FO’S PITOT LINES FROM PITOT TUBES. DURING INSPECTION PITOT OF TUBES FOUSDR Y2PA201804170013Control Panel · inoperativeENCOUNTERED AN ELECTRICAL PROBLEM DURING CLIMB. RETURNED TO DEPARTURE. NO FURTHER ISSUES OCCURRED AND LANDED SAFELY. EMERGENCY DECLARED WITH ATC. LEFT GENERATOR OFF LIGHT ILLUMINATED DURING CLIMB. RAN COM PROCEDURE, NO HELP. APU DID NOT COME ONLINE. MAINSDR Y2PA2017112300031Sensor · failedCREW REPORTED DURING GEAR RETRACTION, LEFT GEAR UNSAFE LIGHT REMAINED ILLUMINATED. PERFORMED COM PROCEDURE, DECLARED EMERGENCY, REMAINED AIRBORNE TO BURN OFF FUEL TO MEET LANDING WEIGHT REQUIREMENTS. LANDING GEAR EXTENDED NORMALLY. COMPLETED UNEVENTFUL LANDISDR Y2PA2016092900024Warning System · malfunctionedIMMEDIATELY AFTER TAKEOFF, COULD SMELL AN ELECTRICAL BURNING ODOR FOLLOWED BY A MASTER CAUTION LIGHT. SEVERAL ANNUNCIATORS CAME ON AND OFF, FOLLOWED BY THE GPWS FAIL, STALL INDICATION FAIL AND FLAP/RUDDER/STOP INOPERATIVE REMAINING ON. IMMEDIATELY STARTED A SDR Y2PA2016011200001Skin · corrodedMAINTENANCE DISCOVERED A MISSING RIVET FROM THE BELLY SKIN AT FS 585. UPON FURTHER INSPECTION, IT WAS DETERMINED THAT THERE WAS INTERNAL AND EXTERNAL CORROSION AND A TEMPORARY REPAIR WAS INSTALLED AND THE AIRCRAFT WAS FERRIED FOR REPAIR. MAINTENANCE INSTALLESDR Y2PA20130306010Skin · crackedEMERGENCY PROCEDURE, EMERGENCY DESCENT, UNSCHEDULED LANDING. FUSELAGE SKIN CRACKED AT BS 950 BETWEEN L14-15R, DISCOVERED DURING C-CHECK INSPECTION. MX REPAIRED IAW SRM 54-04, FIG 46.SDR Y2PA20130306009Shear Tie · crackedUNSCHEDULED LANDING, EMERGENCY DESCENT, ETC. SHEAR TIE CRACKED AT BS 945 BETWEEN LONGERONS 14R AND 17R, DISCOVERED DURING C-CHECK INSPECTION. MX REPLACED SHEAR TIE IAW SRM 51-30-5.SDR Y2PA20130306008Fitting · crackedUNSCHEDULED LANDING, EMERGENCY DESCENT. RT PYLON REAR SPAR UPPER CAP FITTING AT STATION Y 1038 FOUND CRACKED DURING C-CHECK INSPECTION. MX REPLACED FITTING IAW SRM 51-30-1, 51-30-3 AND 51-30-5.SDR Y2PA20130306007Fitting · crackedUNSCHEDULED LANDING, EMERGENCY DESCENT, ETC. LT PYLON REAR SPAR UPPER CAP FITTING AT STATION 1038 FOUND CRACKED DURING C-CHECK INSPECTION. MX REPLACED FITTING IAW SRM 51-30-1, 51-30-3 AND 51-30-5.SDR Y2PA20130306006Skin · chafedEVIDENCE OF DAMAGE ON UPPER RT SIDE OF VERTICAL STABILIZER BETWEEN STATION ZV120 NEAR FORWARD END OF UPPER AND LOWER BODY FAIRINGS, DISCOVERED DURING C-CHECK. MX REPAIRED IAW DWG 55301301-1 AND APPROVED 8110-3 DATED 02/19/13.SDR Y2PA20130306005Attach Angle · crackedEMERGENCY PROCEDURE, UNSCHEDULED LANDING, EMERGENCY DESCENT. RT PYLON UPPER PYLON TO FUSELAGE ATTACH ANGLE 12, AFT OF LEADING EDGE HAS 1 CRACK AT CORNER, DISCOVERED DURING C-CHECK INSPECTION. MX REPAIRED IAW SRM 54-04, FIG 10.SDR Y2PA20120910041Turbine Blades · damagedCREW REPORTED AFTER DEPARTURE WHEN TRANSITIONING TO QUIET EPR POWER SETTING A SUDDEN LOUD AND EXTREME VIBRATION OCCURRED. OBSERVED LOSS OF EPR, N1 & N2. LT ENGINE WAS VERIFIED AS FAILING AND SOURCE OF VIBRATION WITH THROTTLE TO IDLE. EMERGENCY DECLARED AND SDR ABXR080108Attach Angle · crackedATTACH ANGLE FOR STA 41 TO STA 69 PRESSURE PANEL INTERCOSTAL CRACKED JUST RIGHT OF PLUG DOOR. REMOVED AND REPLACED ANGLES IAW DC9 SRM 51-30-5.SDR ABXR080107Attach Angle · crackedATTACH ANGLE FOR STA 41 TO STA 69 PRESSURE PANEL INTERCOSTAL CRACKED. SECOND INTERCOSTAL TO THE LEFT OF THE PLUG DOOR. REMOVED AND REPLACED IAW DC9 SRM 51-30-5.SDR ABXR080106Fitting · crackedPYLON UPPER REAR SPAR STRAP CLIP JUST INSIDE PYLON CRACKED. REMOVED, FABRICATED, AND INSTALLED NEW CLIP IAW DC9 SRM 51-30-1 AND 51-30-5.SDR ABXR080105Attach Angle · crackedLEFT WHEEL WELL KEEL WEB UPPER ATTACH ANGLE AT STA 718 CRACKED. REMOVED AND REPLACED FITTING IAW DC9 SRM 51-30-1 AND 51-30-5.SDR ABXR080104Attach Angle · crackedINBOARD BULKHEAD STA 718 ATTACH ANGLE CRACKED. REMOVED AND REPLACED FITTING IAW DC9 SRM 51-30-5.SDR ABXR080103Skin · crackedAFT LOWER CARGO DOOR SKIN CRACKED AT DOOR HANDLE. REPAIRED DOOR IAW DC9 SRM 52-05, FIGURE 30, SHEET 1.SDR ABXR080102Skin · crackedFORWARD LOWER CARGO DOOR SKIN CRACKED AT DOOR HANDLE. REPAIRED AND PAINTED IAW DC9 SRM 25-05 AND 51-10.SDR Y2PA00039Proximity Switch · out of rigYIP - UPON CLIMB-OUT AFTER TAKEOFF, GEAR DOWN LIGHT WOUDLD NOT EXTINGUISH. CREW PERFORMED PROCEDURE 2-32-6 IAW COM. CREW REQUESTED FIRE EQUIP PRIOR TO LANDING. AIRCRAFT LANDED WITHOUT FURTHER INCIDENT AT YIP. MAINTENANCE FOUND THE LEFT GEAR DOOR PROXIMITY
Back to N205US, cancelled May 9, 2023