N703SK
Service difficulty reports · 246
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 = 'N703SK' AND registry_match = 'registration' 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 = 'N703SK' AND registry_match = 'registration' 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 SWIA201126861Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 17 IS OUT. (FLT 5322) RELAMPED EMERGENCY LIGHT.SDR SWIA201126591Light · inoperativeTHE 2ND FROM AFT OVERHEAD EMERGENCY LIGHT. (FLT 6289) RELAMPED EMERGENCY LIGHT.SDR SWIA201126511Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126430Light · inoperativeOVERHEAD EMERGENCY LIGHT BURNED OUT BY ROW 10. (FLT 1197) RELAMPED EMERGENCY LIGHT.SDR SWIA201126429Light · inoperativeAFT MOST OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126088Light · inoperativeAFT CEILING EMERGENCY LIGHT IS OUT. (FLT 7007) RELAMPED EMERGENCY LIGHT.SDR SWIA201126038Light · inoperativeNR 4 CEILING EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126011Light · inoperativeAFT CEILING EMERGENCY LIGHT IS OUT. (FLT 1150) RELAMPED EMERGENCY LIGHT.SDR SWIA201125637Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6503) RELAMPED EMERGENCY LIGHT.SDR SWIA201025061Floorbeam · corrodedFS 280 FLOORBEAM CORRODED OUT OF LIMITS. (C-CHECK) REPLACE FS 280 FLOORBEAM PER SRM.SDR SWIA201025246Floorbeam · corrodedFOUND CORROSION OUT OF LIMITS ON FS 280 FLOORBEAM. (C-CHECK) REPAIRED PER REO.SDR SWIA201023862Light · inoperativeCEILING EMERGENCY LIGHT AT ROW 10 INOP. (FLT 5827) RELAMPED EMERGENCY LIGHT.SDR SWIA201023736Light · inoperativeEMERGENCY OVERHEAD FLOODLIGHT NR 3 INOP. (FLT 6089) RELAMPED EMERGENCY LIGHT.SDR SWIA200923258Light · inoperativeTHE MOST AFT CEILING LEVEL EMERGENCY FLOOD LIGHT INOP. (FLT 6278)RELAMPED.SDR SWIA200922212Light · inoperativeEMERGENCY LIGHT AT ROW 15 INOP. (FLT 6053) RELAMPED EMERGENCY LIGHT.SDR SWIA200921948Lamp · burned outAFT EMERGENCY CEILING LIGHT INOP. (FLT 6572) RELAMPED EMERGENCY LIGHT.SDR SWIA200921718Oxygen Mask · leakingFLT 6452 - OXYGEN LEAK IN COCKPIT OVERHEAD PANEL. REPLACED OBSERVER MASK AND CREW OXYGEN BOTTLE.SDR SWIA200921699Lamp · burned outFLT 6448 - SECOND TO LAST CEILING EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200922031Skin · chafedRIGHT AILERON LEADING EDGE SKIN CHAFED. (C CHECK) REPLACED PER SRM.SDR SWIA200920887Selector Valve · failedFLT 6467 - "GEAR DISAGREE" WARNING ILLUMINATED. GEAR EXTENDED WITH MANUAL RELEASE. REPLACED MLG SELECTOR VALVE, PN: 53340-7.SDR SWIA200820035Strut · discharged"STEERING INOP" CAUTION MSG. AFTER TAKEOFF, NLG STRUT BOTTOMED OUT. OPS CHECK OF NLG STEERING NORMAL.
SDR SWIA200819691Window · crackedFLT 6716 - COPILOT SIDE WINDOW IS CRACKED. REPLACED COPILOT'S SIDE WINDOW IAW MM 56-11-01. ALL OPS CHECKS GOOD, P/N OFF 601R33033-18, S/N OFF 03321H8789.
SDR SWIA200819410Strip · damagedFLT 5911 - FORWARD EMERGENCY LIGHT STRIP IS DAMAGED. REPLACED LIGHT STRIP IAW 33-31-01.
SDR SWIA200819081Smoke Warning · false activationFLT 5876 - RECEIVED A "SMOKE AFT LAV" WARNING MESSAGE. INSPECTED LAV AREA AND ASSOCIATED SYSTEMS WITH NO DEFECTS NOTED.SDR SWIA200718957Fixture · brokenFLT 6048 - EMERGENCY LIGHT ON THE GALLEY WALL IS BROKEN. REPLACED FLOOR LEVEL FLOOD LIGHT FIXTURE IN GALLEY IAW CRJ AMM 33-51-11.
SDR SWIA200718732Sign · missingFLT 6570 - EMERGENCY EXIT SIGN IS MISSING AT ROW 3. FOUND EMERGENCY EXIT SIGN COVER AND REINSTALLED IT.SDR SWIA200718495Lamp · burned outOVERHEAD EMERGENCY LIGHT AT ROW 16 IS OUT. RELAMPED OVERHEAD EMERGENCY LIGHT. OPS CHECK GOOD.SDR SWIA200718032Wire · shortedFO'S CHART HOLDER LIGHT SPARKED, THEN WENT OUT. REPAIRED CHART LIGHT POWER SUPPLY IAW WDM 20-33-00 AND ALSO REPLACED LAMP CONTROL ASSEMBLY. OPERATIONAL CHECKS GOOD.SDR SWIA200617457Unknown · odorSMOKE LAV WARNING MESSAGE AFTER TAKEOFF WITH SMELL OF SMOKE THROUGHOUT CABIN. RETURNED TO TUS. RAN PACKS WITH BOTH APU AND ENGINE BLEED AIR PER MM 71-00-00, 21-00-00 AND THE SMOKE ODOR DISSIPATED. UNABLE TO DUPLICATE DISCREPANCY.SDR SWIA200617698Floorboard · crackedCOCKPIT FLOORBOARD AT SUPPORT ATTACHED 280 BEAM IS CRACKED AT THE LT AND RT SIDES, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW FLOOR SUPPORT AFT COCKPIT PART NR CC670-33282-13 P/O 74023 PER SRM 51-42-21.SDR SWIA200617697Floorbeam · cracked280 BEAM CRACKED AT LOWER AND UPPER SIDES BRACKETS ON THE LT AND RT SIDES, DISCOVERED DURING C-CHECK INSPECTION. INSTALL NEW CROSSBEAM AT FR ST 280 PER 1S70531100026 AND SRM 51-42-06-001-001-A01.SDR SWIA200617696Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. REPAIRED AFT PAX DOOR DRAG ANGLE PER REO 670-52-11-072.SDR SWIA200617695Web · crackedPAX DOOR AFT WEB AT 2ND STEP CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PART AT AFT WEB 2ND STEP PER REO 670-52-11-104 REV B.SDR SWIA200617694Web · crackedPAX DOOR FWD WEB AT 2ND STEP CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS AT 2ND STEP FWD SIDE OF PAX DOOR PER REO 670-52-11-104 REV B.SDR SWIA200617693Web · crackedPAX DOOR AFT WEB AT 3RD STOP CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS AT 3RD STEP AFT SIDE OF PAX DOOR PER REO 67052-11-104 REV 'B'.SDR SWIA200617692Handle · crackedPAX DOOR OUTER HANDLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. REPLACED OUTER HANDLE PER CRJ7/9 AMM 51-11-03-400-801-A01. OPERATIONAL CHECKS GOOD.SDR SWIA200616126Control Unit · malfunctionedRECEIVED SSCU 2 STATUS AND PITCH FEEL MSG'S. REPLACED SSCU2 IAW MM 27-61-05. OPERATIONAL CHECK GOOD.SDR SWIA200515910Sensor · malfunctioned"SLATS FAIL" MSG ON POWER-UP. REPLACED RT SENSOR, BRAKE POSITION UNIT IAW CRJ 700 MM 27-52-03. OPERATIONAL CHECK GOOD.SDR SWIA200515865Control Unit · malfunctionedSPOILER/STAB FAILED. REPLACED NR 2 SSCU IAW CRJ MM ATA CHAPT 27-61-05. OPERATIONAL CHECK GOOD.SDR SWIA200515341Battery Pack · dischargedEMERGENCY LIGHTS SWITCH ON F/A PANEL LEFT IN "ON" POSITION, EMERGENCY LIGHTS INOP. REPLACED FOUR ELBP'S IAW CRJ 700 MM 33-51-17. OPERATIONAL CHECK GOOD.SDR SWIA200515119Control Unit · malfunctionedSTAB CHANNEL/2 STATUS MESSAGE ON EICAS. REPLACED STAB TRIM MOTOR CONTROL UNIT IAW CRJ 700 MM 27-42-07. OPERATIONAL CHECK GOOD IAW CRJ MM 27-61-05.SDR SWIA200514734Door · bindingMAIN CABIN DOOR IS DIFFICULT TO OPEN FROM INSIDE. LUBED CABIN DOOR. OPERATIONAL CHECK GOOD.SDR SWIA200414282Control Unit · malfunctionedOUTBOARD SPOILERONS & OUTBOARD GROUND SPOILERS CAUTION MESSAGE. REMOVED AND REPLACED NR 2 SSCU IAW CRJ MM 27-61-05. OPERATIONAL CHECK GOOD.SDR SWIA200414103Controller · malfunctionedSPLR/STAB FAULT, RUD LIMITER FAULT & PITCH FEEL FAULT DISPLAYED ON EICAS. REMOVED AND REPLACED SFECU NR 1 IAW CRJ MM 27-51-05. COMPLIED WITH SLAT/FLAP AUTO RIG AS REQUIRED. OPERATIONAL CHECK GOOD.SDR SWIA200413781Bulb · burned outRIGHT OVERWING EXIT LOWER EMERGENCY LIGHT INOP. RELAMPED LOWER EMERGENCY EXIT LIGHT. OPERATIONAL CHECK GOOD.SDR SWIA200413106Flap · out of rigFLAPS HALF SPEED MSG ON EICAS. RIGGED FLAPS IAW MM 27-52-00-802-A01, TR 27-0190.
Back to N703SK