N301YV, cancelled Apr 20, 2015
Service difficulty reports · 103
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 = 'N301YV' AND deregistration_id = 'N301YV-2015-04-20' 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 = 'N301YV' AND deregistration_id = 'N301YV-2015-04-20' 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 SWIA201439347Landing Gear · malfunctionedRIGHT MAIN GEAR WOULD NOT COME UP. R & R RT MLG INBD FWD DOOR ASSY. REPLACED LEVER IAW AMM. REPLACED FWD HINGE BEARING IAW AMM. REINSTALLED RT MLG INBD FWD DOOR IAW AMM. ADJUSTED SEQUENCE VALVE IAW AMM. PERFORMED EMERGENCY EXTENSION AND CYCLED LANDING GEARSDR SWIA201436860Skin · damagedLEFT NACELLE OTBD SKIN DAMAGED ABOVE OTBD FWD MLG GEAR DOOR. C-CHECK, INSTALLED DOUBLER REPAIR IAW ETD.SDR SWIA201437112Spar Cap · crackedRT WING FRONT SPAR, LOWER CAP, CRACKED AT RIB 17. REPAIRED IAW SRM.SDR SWIA201335536Light · inoperativeEMERGENCY LIGHT NEXT TO COURTESY LIGHT DOES NOT ILLUMINATE. FLT 7391 REPLACED THE EMERGENCY LAMP AT THE MAIN CABIN DOOR. OPERATIONS CHECKED GOOD PN 209.SDR SWIA201333976Pin · brokenFLT 5427, ON RAISING LANDING GEAR LEVER, RECEIVED DISAGREEMENT LIGHTS A & B FOR THE RT MAIN GEAR. RAN THE QRH & CYCLED THE GEAR LEVER. AFTER RAISING LEVER AGAIN, RECEIVED BOTH GREEN & RED A & B LIGHTS FOR THE RT MAIN GEAR. REPLACED BROKEN RT INBD GEAR DOSDR SWIA201333417Connector · corrodedDURING TAXI OUT TO RUNWAY AIRCRAFT WOULD NOT STOP WITH NORMAL BRAKING. PLANE FINALLY STOPPED WHEN ANTI-SKID WAS TURNED OFF. (FLT 5459) CLEANED HEAVY CORROSION FROM RIGHT MAIN GEAR ANTI-SKID HARNESS CONNECTOR ABOVE RIGHT MAIN GEAR STRUT. COMPLIED WITH TAXI SDR SWIA201333416Brake Sys · contaminatedUPON LANDING IN LAX, BRAKES FAILED. PARKING BRAKE STOPPED A/C. BRAKING WAS STICKY AND ABRUPT WITH ANTI-SKID OFF. (FLT 6452) PERFORMED BLEEDING OF ALL BRAKES AND HIGH SPEED TAXI WITH ANTI-SKID SELECTED ON. BRAKING ACTION NORMAL. BRAKES OPS CHECK GOOD.SDR SWIA201333237Battery · dischargedEMERGENCY LIGHT SWITCH ON, EMERGENCY LIGHTS WOULD NOT TEST PROPERLY. (FLT 5927) REPLACED FORWARD AND MIDDLE EMERGENCY LIGHT BATTERIES. P/N: D366-04-001 S/N ON: 972 S/N OFF: 265 P/N D366-04-001 S/N ON:1320 S/N OFF: 340SDR SWIA201332782Unknown · malfunctionedSELECTED GEAR DOWN, DOORS OPENED BUT LANDING GEAR DID NOT EXTEND. CYCLED GEAR HANDLE AND LANDING GEAR CAME DOWN NORMALLY NO FURTHER PROBLEMS. (FLT 6233) PERFORMED 10 GEAR SWINGS AND COULD NOT DUPLICATE DISCREPANCY. CLEANED ALL GEAR SEQUENCE VALVES AND REPLSDR SWIA201332744Shaft · lack of lubeFLIGHT ATTENDANT REPORTS THE FORWARD DOOR HANDLE IS STIFF AND HARD TO ACTUATE. (FLT 5335) LUBRICATED FWD DOOR HANDLE SHAFT, OPS CHECK GOOD.SDR SWIA201332676Roller · lack of lubeMAIN CABIN DOOR VERY HARD TO OPEN AND CLOSE. (FLT 6295) LUBED UPPER FUSELAGE ROLLERS AND MAIN HANDLE PIVOT POINT.SDR SWIA201332564Light · inoperativeONE RED EMERGENCY LIGHT AT ROW SIX DOES NOT ILLUMINATE. (FLT 7391) RELAMPED EMERGENCY LIGHT.SDR SWIA201332539Light · inoperativeEMERGENCY RED LIGHT AT ROW SIX IS OUT. (FLT 6295) RELAMPED EMERGENCY LIGHT.SDR SWIA201232494Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS BURNED OUT. (FLT 5385) RELAMPED EMERGENCY LIGHT.SDR SWIA201232403Control Unit · failedNO WHEEL BRAKES WITH ANTI-SKID ON AND PEDALS PUSHED. (FLT 6445) REPLACED THE ANTI-SKID CONTROL UNIT IAW AMM 32-42-03. P/N: 42-687-1 S/N ON: 101 S/N OFF: 422.SDR SWIA201232245Solenoid Valve · failedLANDING GEAR WOULD NOT EXTEND WHEN THE GEAR HANDLE WAS SELECTED DOWN. THE GEAR EXTENDED NORMALLY ON THE SECOND APPROACH. (FLT 7783) REPLACED LANDING GEAR SOLENOID VALVE IN REFERENCE TO AMM. P/N: 18190-003 S/N OFF: 767SDR SWIA201232059Structure · crackedLOUD RUSHING AIR NOISE COMING FROM BOTTOM OF PILLAR BETWEEN CAPTAIN'S WINDSHIELD AND DV WINDOW. (FLT 6408) FOUND CRACK ON LEFT WINDSHIELD PILLAR. REMOVED PILLAR AND INSTALLED SERVICEABLE PILLAR.SDR SWIA201231890Stringer · crackedLEFT WING AT FUEL PANEL NR 2 AFT STRINGER 8 IS CRACKED. (SERVICE) REPAIRED STRINGER NR 8 AT LEFT AFT NR 2 FUEL PANEL AREA IN REFERENCE TO SRM.SDR SWIA201230941Screw · missingENTRY COURTESY LIGHT NOT WORKING IN THE EMERGENCY MODE. (FLT 7800) FOUND EMERGENCY DOME LIGHT TO BE INOPERATIVE DUE TO A MISSING SCREW FOR TERMINAL. INSTALLED NEW SCREW.SDR SWIA201230703Light · inoperativeENTRY WAY OVERHEAD EMERGENCY COURTESY LIGHTS ARE OUT. (FLT 6327) RELAMPED EMERGENCY LIGHTS.SDR SWIA201229447Connector · looseRED EMERGENCY ON LOWER PASSENGER ENTRANCE LIGHT ON WALL CONTROL IS OUT. (FLT 7811) TIGHTENED LOOSE ELECTRICAL CONNECTOR ON LOWER PASSENGER ENTRANCE LIGHT.SDR SWIA201229270Track · brokenTRACK BELOW RIGHT FLIGHT ATTENDANT SEAT SIDE IS BROKEN. (SERVICE) REPLACED TRACK.SDR SWIA201127249Engine · malfunctionedBRINGING TORQUE BACK TO 20 PERCENT, CABIN AND FLIGHT DECK FILLED WITH SMOKE. (FLT 5626) REPLACED LEFT ENGINE. NO FURTHER SMOKE NOTED IN CABIN. P/N OFF PW188B S/N OFF AP0011.SDR SWIA201126982Engine · malfunctionedSMOKE IN THE COCKPIT DURING DESCENT. (FLT 5552) LEFT ENGINE REQUIRES REPLACEMENT. COULD NOT DUPLICATE SMOKE. LEFT ENGINE BLEED OPERATIONAL CHECKS ARE GOOD. NO SMOKE NOTED.SDR SWIA201126910Acm · malfunctionedSMOKE IN COCKPIT WITH PACKS AUTO/NORM AND AUTO/LOW. (FLT 7777) REPLACED LEFT PACK ACM, LEFT PACK TEMP CONTROL VALVE AND TIC VALVE. P/N 2204540-5 (ACM) S/N OFF 76-840.SDR SWIA201126810Extractor · malfunctionedREDUCED POWER TO 50 PERCENT TORQUE AND IMMEDIATELY GOT SMOKE IN COCKPIT FROM PACKS. (FLT 7795) REPLACED WATER EXTRACTOR UNIT AND CLEANED 2.5/3.0 BLEED VALVE. P/N 2340830-1-1, S/N ON 75-354, S/N OFF 73-295.SDR SWIA201126444Light · brokenLEFT EMERGENCY LIGHT AT ROW 6 IS BROKEN. (FLT 6695) REPLACED LEFT EMERGENCY LIGHT ASSEMBLY AT ROW 6.SDR SWIA201025265Light · inoperativeEMERGENCY LIGHT ON CABIN FORWARD BULKHEAD INOPERATIVE. (FLT 6515) RELAMPED EMERGENCY LIGHT.SDR SWIA201025161Light · brokenEMERGENCY FLOOR LIGHT NOT WORKING AT ROW 4. (FLT 6822) REPLACED FLOOR EMERGENCY LIGHT FIXTURE AT ROW 4.SDR SWIA201025130Stringer · crackedRIGHT LOWER WING STRINGER, AFT OF NR 2 FUEL PANEL IS CRACKED. (C-CHECK) PERFORMED STRINGER SPLICE TO RT WING STRINGER 8 AT NR 2 FUEL CELL ACCESS PANEL PER SRM.SDR SWIA201024853Light · inoperativeFORWARD RIGHT EXTERNAL EMERGENCY LIGHT INOPERATIVE. (MAINTENANCE)RELAMPED.SDR SWIA201024601Battery Pack · dischargedEMERGENCY LIGHTS MIDDLE OF CABIN INOP. (FLT 7799) REPLACED AFT EMERGENCY LIGHT BATTERY PACK.SDR SWIA201023884Switch · malfunctionedTHE LEFT AUTO FEATHER TEST SWITCH STUCK IN THE TEST POSITION ON TAKEOFF RESULTING IN OVER TORQUE. (FLT 7759) REPLACED SWITCH, RIGHT PROP HUB AND BLADES.SDR SWIA200923545Seal · crackedRIGHT INBOARD RUDDER CABLE PRESSURE SEAL FLANGE CRACKED AT AFT SIDE OF WING BOX. (C CHECK) REPLACED SEAL FLANGE PER AMM.SDR SWIA200923523Skin · corrodedFUSELAGE SKIN AT FRAME 21 CORRODED. (C CHECK) REPAIRED PER ETD2009-120/10021.SDR SWIA200923524Stringer · corrodedSTRINGERS 18 AND 19 BETWEEN RIBS 15 AND 16 CORRODED. (C CHECK) REPAIRED PER SRM.SDR SWIA200923522Seat Track · corrodedLEFT FORWARD FLOOR SEAT TRACK CORRODED. (C CHECK) REPLACED SEAT TRACK PER AMM.SDR SWIA200922689Sign · brokenEXIT SIGN ON 6C IS BROKEN. (FLT 7769) REPLACED EMERGENCY EXIT SIGN AT 6C IAW MM 20-21-00.SDR SWIA200922280Stringer · crackedRIGHT WING FUEL TANK STRINGER 10 IS CRACKED. (C CHECK) REPAIRED PER SRM.SDR SWIA200922264Sensor · dirtyGEAR WOULD NOT RETRACT. (FLT 7760) CLEANED RIGHT MLG WOW SENSOR CONNECTOR.SDR SWIA200921965Battery Pack · dischargedFRONT ROW OF EMERGENCY LIGHTS INOP. (FLT 7769) REPLACED ELBP.SDR SWIA200820571Unknown · odorFLT 5442 - BURNING ODOR IN COCKPIT AND CABIN ACCOMPANIED WITH SMOKE. CLEANED AIR CONDITIONING HEAT EXCHANGERS, RAN BOTH PACKS OFF ENGINE BLEEDS AND APU BLEED FOR OVER AN HOUR, NO DISCREPANCIES NOTED. INSPECTED WIRING AND CONTACTORS NO DISCREPANCIES NOTED.SDR SWIA200819881Wire · damagedDAMAGED WIRE W206-0051019 FOUND IN LT DC 1 RELAY BOX. (FOUND AT C-CHECK) REPLACED THE WIRE IAW EMB 120, WDM 21-51-00 AND THE RCCB IAW MM 24-52-05. OPS CHECKS GOOD.
SDR SWIA200819880Buttstrap · corrodedBUTT STRAP IN FRONT OF LAV IS CORRODED. (FOUND AT C-CHECK) REPLACED BUTT STRAP IN FRONT OF LAV IAW SRM 51-10-02 AND SECURED IAW 51-40-07.
SDR SWIA200819879Frame · crackedPAX DOOR FWD AND AFT MID CORNERS ARE CRACKED. (FOUND AT C-CHECK) REPLACED FRAME AND INSTALLED DOUBLERS IAW SRM 120 52-10-02.
SDR SWIA200819878Rod End · corrodedRUDDER II ROD ENDS HAVE SURFACE CORROSION. (FOUND AT C-CHECK) REPLACED UPPER AND LOWER RUDDER II CONTROL ROD ENDS IAW AMM 27-21-02
SDR SWIA200819411Acm · malfunctionedLEFT PACK PRODUCES SMOKE. REPLACED LEFT AIR CYCLE MACHINE IAW MM 21-50-05.
SDR SWIA200718603Retainer · looseTHE O2 MASKS DROPPED AFTER TAKEOFF FLIGHT NR 5774. RESECURED CARGO DOOR SEAL AND RETAINER. PRESSURIZATION CHECK GOOD.SDR SWIA200718611Windshield · crackedLEFT WINDSHIELD CRACKED, FLIGHT NR 5778. REPLACED WINDSHIELD IAW MM 56-00-00, OPS CHK GOOD.SDR SWIA200718557Sign · brokenEXIT ROW "EXIT" SIGN BROKEN AT ROW 6, FLIGHT NR 5471. REPLACED EXIT SIGN WITH A SERVICEABLE UNIT. OPS TEST GOOD, P/N: 10-1262-1.
Back to N301YV, cancelled Apr 20, 2015