N299SW, cancelled Jan 14, 2019
Service difficulty reports · 100
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 = 'N299SW' AND deregistration_id = 'N299SW-2019-01-14' 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 = 'N299SW' AND deregistration_id = 'N299SW-2019-01-14' 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 SWIA200920926Wire · looseFLT 7754 - FIRST FOUR EMERGENCY FLOOR LIGHTS INOP. SECURED LOOSE WIRE.SDR SWIA200920775Unknown · smokeFLT 7811 - WHEN RIGHT BLEED SET TO AUTO-NORM CABIN FILLED WITH SMOKE. RAN RIGHT PACK WITH APU BLEED AND RIGHT ENGINE BLEED, BOTH AUTO AND LOW BLEED SELECTED. UNABLE TO DUPLICATE.SDR SWIA200820066Frame · crackedC-CHECK, CRACK IN FRAME IN FRONT OF LEFT HEAT EXCHANGER. INSTALLED DOUBLER.
SDR SWIA200820065Frame · crackedC-CHECK, CRACK IN FRAME IN FRONT OF RIGHT HEAT EXCHANGER. INSTALLED DOUBLER REPAIR ON FRAME.
SDR SWIA200820064Frame · crackedC-CHECK, RIGHT INBOARD NACELLE FRAME CRACKED. REPLACED FRAME.
SDR SWIA200820067Wire · looseFLT 3563 - EMERGENCY EXIT LIGHT AT 6 A INOP. CONNECTED LOOSE WIRE.
SDR SWIA200819734Battery · inoperativeROW 6 EMERGENCY LIGHTS ARE INOP. (FLT 5785) REPLACED EMERGENCY LIGHT BATTERY. OPS CHECK GOOD.SDR SWIA200819596Window · crackedFLT 5717 - FIRST OFFICERS DV WINDOW IS CRACKED. REPLACED COPILOT'S WINDOW IAW MM 56-11-01.SDR SWIA200819560Battery Pack · inoperativeFLT 5464 - EMERGENCY EXIT SIGNS WILL NOT ILLUMINATE WHILE TESTING. REPLACED ELBP ABOVE ROW 6. OPS CHECK GOOD.SDR SWIA200718961Battery Pack · dischargedFLT 3722 - AFT EMERGENCY LIGHT AT ROW 9 IS INOP. INSTALLED SERVICEABLE ELBP IAW AMM 33-50-02. OPS CHECK GOOD.SDR SWIA200718080Sign · missingENTRY WAY EXIT PLACARD IS MISSING. REMOVED REMAINING EXIT SIGN HOUSING AT AND INSTALLED NEW LIGHT ASSEMBLY. OPERATIONAL CHECK GOOD, P/N 10-1301-15.SDR SWIA200718061Battery Pack · dischargedFIRST SECTION OF EMERGENCY FLOOR LIGHTING DOES NOT ILLUMINATE. REPLACED FORWARD EMERGENCY LIGHTING BATTERY PACK. OPERATIONAL CHECKS GOOD.SDR SWIA200717814Windshield · crackedCAPTAIN'S WINDSHIELD PANE AND FO'S WINDSHIELD PANE SHATTERED ON LANDING ROLLOUT. REPLACED CAPTAIN'S WINDSHIELD IAW EMB120 AMM REF NR 56-10-01, P/N NP-151311-1 S/N OFF 04149146184. REPLACED FIRST OFFICER'S WINDSHIELD IAW EMB120 MM 56-10-01 AND RII 56-200-1000SDR SWIA200717766Nacelle · contaminatedUPON AIRCRAFT POWER DOWN CREW NOTICED SMOKE COMING FROM THE LEFT ENGINE NACELLE. INSPECTED ENGINE COMPARTMENT AND NOTED EXCESS GLYCOL. NO OTHER DISCREPANCIES NOTED.SDR SWIA200617672Angle · corrodedPAX ENTRANCE LOWER THRESHOLD ANGLE IS CORRODED, DISCOVERED DURING C-CHECK INSPECTION. REPLACED PAX ENTRANCE LOWER THRESHOLD ANGLE AND CLEANED AND TREATED ALL OTHER AREAS BELOW ANGLE IAW CPM 51-14-00.SDR SWIA200617671Skin · crackedFUSELAGE SKIN CLEAT CRACKED JUST FORWARD AND ABOVE FORWARD CARGO DOOR TRACK, DISCOVERED DURING C-CHECK INSPECTION. REPLACED SKIN CLEAT IAW RII 53-800-1000 AND IAW RM 57-40-02 AND 51-10-02, PG 3, SEC 3A.SDR SWIA200515988Actuator · malfunctionedFLAP LIGHT AND ADVANCE STALL WARN LIGHT ON MAP ASYMMETRY, CONTROL FAULT AND DISAGREEMENT LIGHTS CAME ON IN CRUISE. REPLACED FLAP ANNUNCIATOR ASSY AND RIGHT NACELLE FLAP ACTUATOR IAW EMB MM 27-50-05 AND 27-50-03. OPERATIONAL CHECK GOOD, PN OFF 306900-10176; SSDR SWIA200515487Button · stuckSTALL WARNING BUTTON STICKS IN DOWN POSITION. REMOVED AND REPLACED STALL WARNING PANEL. OPERATIONAL CHECKS GOOD IAW 27-00-00.SDR SWIA200515078Gasper Fan · inoperativeSMELLED SMOKE IN THE CABIN RIGHT BEFORE LANDING. REPLACED GASPER FAN. OPERATIONAL CHECK GOOD.SDR SWIA200515088Buttstrap · corrodedCENTER BUTT STRAP BELOW CABIN FLOOR AFT OF ROW 10 CORRODED, ITEM FOUND AT C-CHECK INSPECTION. NEW BUTT STRAP INSTALLED IAW SRM 120 51-10-02 PG 3 SEC 3.A.SDR SWIA200514373Actuator · malfunctionedON DESCENT FROM FLIGHT LEVEL 270 A/P FAILED FOUND ELEVATOR TRIM FROZEN. REPLACED BOTH LEFT AND RIGHT ELEVATOR TRIM TAB LINEAR ACTUATORS IAW EMB 120 MM 27-32-02 AND ACCOMPLISHED CABLE TENSION IAW EMB 120 MM 27-00-01 PAGE 209 FIG 201. OPERATIONAL CHECK GOOD. SDR SWIA200414336Actuator · contaminatedUPON LEVEL OFF AT 270 ELEVATOR TRIM WHEEL SPRANG FORWARD ABOUT 1/2 TURN AND AUTOPILOT KICKED OFF. INSPECTED TRIM ACTUATORS FOR BOTH ELEVATOR AND AILERON TRIM AND FOUND MOISTURE ON ALL ACTUATOR SHAFTS. CLEANED RESIDUAL MOISTURE FROM ALL ACTUATORS AND LUBRICATSDR SWIA200414337Sensor · faultySTALL WARNING SYSTEM ALARM ON F/O SIDE ILLUMINATES WITH ASSOCIATED AURAL WARNING. REMOVED AND REPLACED SIDE SLIP SENSOR. OPERATIONAL CHECK GOOD.SDR SWIA200414314Rccb · faultyDURING INITIAL POWER UP, AN ELECTRICAL ODOR AND SMOKE DEVELOPED IN THE COCKPIT. REPLACED RCCB FOR GREEN HYDRAULIC AUX PUMP. OPERATIONAL CHECK GOOD.SDR SWIA200414067Wire · damagedBOTH FORWARD EXIT FLOOR LIGHTS (RED) INOPERATIVE. REPAIRED WIRES TO FLOOR TRACK LIGHTS (2 RED FWD). OPERATIONAL CHECK GOOD.SDR SWIA200414029Fan · smokeON GROUND RIGHT PACK FILLED CABIN WITH SMOKE. REPLACED RIGHT GROUND COOLING FAN. OPERATIONAL CHECKED GOOD.SDR SWIA200414010Heat Exchanger · smokeRIGHT PACK PUTS SMOKE IN THE CABIN WHEN IT IS RUN ON THE APU BLEED. REMOVED AND REPLACED RIGHT HEAT EXCHANGER IAW EMB 120 MM 21-50-03. OPERATIONAL CHECK GOOD. P/N 194546-3, S/N OFF 10-576.SDR SWIA200412865Smoke Detector · false activationSMOKE AURAL WARNING FOR CARGO SOUNDED. REPLACED AFT CARGO SMOKE DETECTOR. OPS CHECK GOOD.SDR SWIA200312530Rod End · out of adjustRIGHT GEAR DOOR REMAINS OPEN AFTER GEAR SELECTOR UP. VISUALLY VERIFIED THAT GEAR WAS UP WITH DOORS OPEN. RED INTRANSIT LIGHT IS REMAINING ON. ADJUSTED ACTUATOR ROD END (LENGTHENED 1 TURN) PER32-32-10 AND ADJUSTED UPLOCK TARGET PER MM 32-61-01. OPS CHECKS GSDR SWIA200312506Seat Track · crackedOBS SEAT FRAME, BELOW FLOOR, AFT SIDES CRACKED AS MARKED. DISCOVERED DURING C-CHECK INSPECTION. REPAIRED FRAME BELOW FLOOR IAW SRM 120 51-10-02 PG 2 SEC 2B.SDR SWIA200312100Light · will not testEMERGENCY LIGHTS DO NOT TEST PROPERLY. CENTER SECTION LIGHTS GO INOP AFTER COUPLE SECONDS. INSTALLED NEW K201 RELAY AND OPS CHECK GOOD.SDR SWIA200312072Power Supply · malfunctionedFIRST THREE (FORWARD) EMERGENCY EXIT FLOOR LIGHTS, AS WELL AS FIRST (FORWARD) OVERHEAD POD LIGHT INTERMITTENT OPERATION. REPLACED FORWARD EMERGENCY LIGHT BATTERY PACK. OPS CHECK GOOD.SDR SWIA200312004Inverter · failedF/O'S AUTO PILOT FAILED ON THE APPROACH MODE. RED AP LIGHT ON MAP AND FCP. REMOVED AND REPLACED NR 1 INVERTER WITH SERVICEABLE UNIT IAW MM 24-22-00. OPS CHECK GOOD. P/N OFF: AL-251-1G, S/N OFF: 6074.SDR SWIA200211581Ejector Valve · failedDURING CLIMB IN MODERATE ICING CONDITIONS, THE LEFT AND RIGHT MIDDLE WING DEICE BOOTS FAILED REPEATEDLY ON BOTH TIMERS. RETURNED TO FAT. REPLACED EJECTOR VALVE FOR LEFT AND RIGHT MIDDLE DEICE BOOTS WITH SERVICEABLE UNITS IAW MM 30-10-04. OPS CHECK GOOD.SDR SWIA200211237Bulkhead · crackedAPU BULKHEAD CRACKED BY BIG CANNON PLUG. DISCOVERED DURING A-CHECK INSPECTION. INSTALLED SERVICEABLE DOUBLER AT APU BULKHEAD IAW SRM. NO OTHER DEFECTS NOTED.SDR SWIA200211037Battery · dischargedT/O BRAKES AURAL WARNING ON T/O ROLL WITH BRAKES RELEASED. ABORTED T/O. REMOVED AND REPLACED EMERGENCY BATTERY, OPS CHECK GOOD.SDR SWIA200210954Computer · malfunctionedABORTED TAKEOFF FOR ATTITUDE DISPLAY MESSAGE. REPLACED NR 1 AHRS COMPUTER WITH SERVICEABLE UNIT AND REINITIALIZED AS REQUIRED. OPS CHECKS GOOD.SDR SWIA200110319Bracket · crackedUPPER BRACKET FORWARD OF FRAME 9 IS CRACKED ON LEFT AND RIGHT SIDES OF COCKPIT. ELIMINATED SHEAR CLIPS AND CUT END OF LEFT AND RIGHT FRAME 9 CHANNEL PER SB 120-53-0073.SDR SWIA200110313Control Cable · wornAILERON CABLES WORN. REPLACED AILERON CABLES WITH TIN CARBON STEEL CABLE PER EMB120 MM 27-00-01.SDR SWIA200110312Connector · corrodedCORROSION FOUND INSIDE CO-AX CONNECTOR OF COMM NR 2 ANTENNA. ANTENNA REQUIRES REPLACEMENT. REPLACED NR 2 COMM ANTENNA WITH NEW SERVICEABLE ANTENNA. ALL WORK CONFORMS TO MM REMOVAL AND REPLACEMENT INSTRUCTIONS CHAPTER 34-55-01. P/N OFF: 16-21B MOD 1 S/N OSDR SWIA200110310Bracket · crackedBRACKET AT FRAME 13 AFT OF DIRECT VISION WINDOW ON LEFT SIDE OF COCKPIT CRACKED. REPLACED BRACKET AT FRAME 13 AFT OF DV WINDOW ON LEFT SIDE OF COCKPIT IAW MM 53-00-00.SDR SWIA972317Door · damagedDURING TAKEOFF ROLL PRIOR TO V1 RECEIVED RED DOOR LIGHT ON MAP AND RED FLASHING WARNS LIGHT. ABORTED TAKEOFF. FOUND OUTBOARD REFUEL DOOR FWD FASTENER BAD AND POPPED OUT. REPLACED FASTENER AND RESECURED FORWARD DOOR. OPS CHECKS GOOD.SDR SWIA972320Uplock · out of adjUPON ATTEMPTING TO RAISE LANDING GEAR, RECEIVED A RED-A LIGHT AND A RED-B LIGHT. VISUALLY NOTICED THAT GEAR DOORS FOR LEFT AND RIGHT GEAR DO NOT CLOSE. DIVERTED TO FAT. ADJUSTED LEFT AND RIGHT UPLOCK HOOK PLUNGERS IAW 32-11-01. SWUNG GEAR SEVERAL TIMES IAWSDR SWIA971593unknownFLAP DISAGREEMENT AFTER TAKEOFF. RETURNED TO PSP REPLACED FLAP SELECTOR HANDLE. OPS CHECKS GOOD.SDR SWIA971464Ahrs · malfunctionedCAPTAIN'S AHRS FAILED AFTER TAKEOFF, WOULD NOT RESET (GYRO FLAG AND RED HEADING). RETURNED TO ACV. PERFORMED REORIENTATION OF AHRS (PILOTS). CHECKED OK.SDR SWIA971273Fcu · looseNACELLE FLAP ASYMMETRY INDICATION, NO ADVERSE ROLL TENDENCY NOTED. THIS OCCURED ON APPROACH TO IMPERIAL, RETURNED TO PSP. FOUND FCU LOOSE IN MOUNT, CYCLED FLAPS NUMEROUS TIMES, OPS CHECKS GOOD.SDR SWIA971253Venturi Tube · failedLEFT DUCT LEAK LIGHT ILLUMINATED IN FLIGHT. RETURNED TO FAT. INSTALLED SERVICEABLE VENTURI TUBE ON LEFT ACM.SDR SWIA971213Fuel Filter · dirtyLEFT FUEL FILTER LIGHT ILLUMINATED IN FLIGHT. DIVERTED FROM FAT TO ACV. REPLACED LEFT ENGINE FUEL FILTER WITH SERVICEABLE UNIT. OPS CHECKS GOOD WITH NO LEAKS NOTED.SDR SWIA97910Warning Light · illuminatedAT V1 GOT A FLAP ASYMMETRY AND CONTROL FAULT. CONSULTED QRH AND HIT RESET. EVERYTHING NORMAL BUT RETURNED TO LAX FOR LONG RUNWAY. CYCLED FLAPS SEVERAL TIMES AND COULD NOT DUPLICATE DISCREPANCY. RERACKED FLAPS COMPUTER AND CYCLED FLAPS 10 TIMES ON GROUND. SDR SWIA97872Switch · out of adjustCARGO DOOR LIGHT CAME ON RIGHT AFTER TAKEOFF AND DID NOT EXTINGUISH UNTIL LANDING. RETURNED TO FIELD. MEL 52-70-1. RE-ADJUSTED CARGO DOOR MICROSWITCH IAW MM 52-22-00. OPS CHECKS GOOD.
Back to N299SW, cancelled Jan 14, 2019