N814SK
Service difficulty reports · 110
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 = 'N814SK' 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 = 'N814SK' 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 SWIA201437039Door Sill · corrodedAFT CARGO BAY, DOOR SILL HAS CORROSION AROUND NUTPLATES, BS 1000- 1047, TOP SIDE. C-CHECK, REMOVED CORROSION IAW REO.SDR SWIA201437046Door Frame · dentedPAX DOOR SURROUND STRUCTURE HAS A DENT IN THE FRAME WHERE THE SEAL REST AGAINST THE ACFT IN THE CLOSED POSITION, UPPER AREA AFT SIDE. C-CHECK, REPAIRED DENT ON PAX DOOR SURROUND STRUCTURE, UPPER AFT SIDE IAW REO.SDR SWIA201437045Door Frame · dentedPAX DOOR SURROUND STRUCTURE HAS A DENT IN THE FRAME WHERE THE SEAL RESTS AGAINST THE ACFT IN THE CLOSED POSITION, UPPER AREA FWD SIDE. C-CHECK, REPAIRED DENT ON PAX DOOR SURROUND STRUCTURE, UPPER FWD SIDE, IAW REO.SDR SWIA201437044Angle · corrodedPAX DOOR EXTERIOR SURROUND STRUCTURE, LOWER SILL HAS CORROSION THROUGHOUT UPPER SIDE, BS 310- 349. C-CHECK, PAX DOOR SILL KICK PLATE ANGLE FOUND TO BE CORRODED BEYOND LIMITS. INSTALLED NEW PAX DOOR SILL KICK PLATE ANGLE IAW SRM.SDR SWIA201437043Skin · corrodedPAX DOOR FWD ACCESS HOLE, HAS CORROSION AROUND NUTPLATE ON SKIN, 832DL. C-CHECK, REMOVED CORROSION ON PAX DOOR FWD ACCESS HOLE AROUND NUTPLATE AREA ON SKIN, 832DL, IAW EA.SDR SWIA201437042Skin · corrodedPASSENGER DOOR FWD ACCESS HOLE, HAS CORROSION AROUND NUTPLATE ON SKIN, 832EL. C-CHECK, REMOVED CORROSION ON PAX DOOR FWD ACCESS HOLE AROUND NUTPLATE AREA ON SKIN, 832EL IAW EA.SDR SWIA201437041Skin · corrodedPAX DOOR HAS CORROSION ON SKIN, BELOW BOTTOM STEP, AROUND NUTPLATE AREA. C-CHECK, REMOVED CORROSION ON PAX DOOR SKIN, BELOW BOTTOM STEP, AROUND NUTPLATE AREA IAW EA.SDR SWIA201437047Seat Track · corrodedRIGHT FLOOR SEAT TRACK CORRODED BS 628, 630, 645 AND 661. C-CHECK, BLENDED CORRODED AREA IAW REO.SDR SWIA201436646Light · inoperativeNR 1 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT 4798 RELAMPED.SDR SWIA201334732Unknown · malfunctionedRECEIVED INTERMITTENT NR 2 HYD LOW PRESS, "INBD SPOILERON" & "INBD FLIGHT SPOILERS" CAUTION MESSAGES. RESERVOIR QUANITY INDICATED 5%, RAN QRH FOR "HYD 2 LOW PRESS" CAUTION & LANDED UNEVENTFULLY. FLT#4625 RAN NR 2 ENGINE AT 85 1/2 % FOR 10 MINUTES. NO LEAKS SDR SWIA201334101Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 10 IS BURNED OUT. FLT#4448 RELAMPED.SDR SWIA201333023Light · inoperativeNR 3 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. (FLT 4684) RELAMPED EMERGENCY LIGHT.SDR SWIA201333015Brake · malfunctionedNR 1 TIRE LOCKED UP WHILE BRAKING AS WE WERE COMING INTO THE GATE. BRAKE TEMP ON THE NR 1 TIRE GOT UP TO 11. AIRCRAFT DIFFICULT TO STOP. (FLT 4618) REMOVED AND REPLACED THE NR 1 BRAKE ASSEMBLY IAW AMM, BRAKE NO LONGER DRAGS. P/N 90001201-1 S/N ON FEB13-2SDR SWIA201332865Light · inoperativeLEFT AFT EMERGENCY LIGHT BURNED OUT. (FLT 2057) RELAMPED EMERGENCY LIGHT.SDR SWIA201332709Unknown · malfunctionedAFT TWO SECTIONS OF EMERGENCY LIGHTS DO NOT ILLUMINATE. (SERVICE) CYCLED AIRCRAFT POWER, RESET EMERGENCY LIGHTS, OPS CHECK GOOD.SDR SWIA201332509Light · inoperativeAFT EMERGENCY OVERHEAD LIGHT BURNED OUT. (FLT 4452) RELAMPED EMERGENCY LIGHT.SDR SWIA201232491Light · inoperativeCEILING EMERGENCY FLOOD LIGHT AT ROW 5 IS BURNED OUT. (FLT 4537) RELAMPED EMERGENCY LIGHT.SDR SWIA201232488Light · inoperativeCEILING EMERGENCY LIGHT ABOVE ROW 10 IS BURNED OUT. (FLT 4537) RELAMPED.SDR SWIA201232228Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT BURNED OUT. (FLT 4678) RELAMPED EMERGENCY LIGHTS.SDR SWIA201232166Beam · crackedTHE 280 BEAM CRACKED BOTH SIDES. (C-CHECK) COMPLIED WITH REPAIR TO 280 CROSS BEAM IAW REO.SDR SWIA201232163Drag Angle · crackedPASSENGER DOOR AFT SIDE CRACK ON AFT DRAG ANGLE. (C-CHECK) REPAIRED PASSENGER DOOR AFT DRAG ANGLE IAW REO.SDR SWIA201231615Light · inoperativeEMERGENCY LIGHTS BURNED OUT AT RIGHT SIDE EXIT ROW. (FLT 4626) RELAMPED EMERGENCY LIGHTS.SDR SWIA201231040Duct · dirtySMOKE AFT TOILET MESSAGE. (FLT 4843) CLEANED RIGHT 6TH STAGE DUCT IN REFERENCE TO CRJ MM.SDR SWIA201230999Duct · crackedRIGHT FIRE WALL FAIL MESSAGE. FOUND A CRACKED BLEED DUCT. (FLT 4469) REPLACED THE RIGHT ENGINE 6TH STAGE DUCT ASSEMBLY.SDR SWIA201230812Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4786) RELAMPED EMERGENCY LIGHT.SDR SWIA2012021529662Smoke Detector · false activationFLT 7316, SMOKE AFT LAVATORY WARNING MESSAGE CAME ON FOR ABOUT 5 MINUTES. CHECKED LAVATORY AND NO SMOKE. REPLACED AFT LAVATORY SMOKE DETECTOR. PN: SN OFF:SDR SWIA2012020329661Smoke Detector · false indicationFLT 7315, SMOKE AFT LAVATORY WARNING MESSAGE DISPLAYED FOR ONE MINUTE, THAN EXTINGUISHED. PERFORMED AN OPERATIONAL CHECK OF THE AFT LAVATORY SMOKE DETECTION SYSTEM. CHECKS GOOD AT THIS TIME.SDR SWIA201229400Engine · failedAT TAKEOFF ROTATION RIGHT ENGINE N1 DROPPED TO 79.37. LEFT ENGINE APR FIRED FOR APPROXIMATELY 5 SECONDS. SHORTLY AFTER TAKEOFF ALL ENGINE INDICATIONS RETURNED TO NORMAL. RIGHT ENGINE OIL LOW PRESSURE STATUS MESSAGE ALSO APPEARED SHORTLY THEN WENT AWAY. (FLSDR SWIA201128591Light · inoperativeROW 9 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4818) RELAMPED EMERGENCY LIGHT.SDR SWIA201128536Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 9 IS OUT. (FLT 4816) RELAMPED EMERGENCY LIGHT.SDR SWIA201128405Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4484) RELAMPED EMERGENCY LIGHT.SDR SWIA201128270Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4705) RELAMPED EMERGENCY LIGHT.SDR SWIA201128124Pseu · failedGEAR DISAGREE WITH WOW INPUT AND WOW OUTPUT MESSAGES. (FLT 4821) REPLACED PSEU. P/N ON 8-953-04 S/N OFF D491.SDR SWIA201127921Light · inoperativeAFT 3 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 4814) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127744Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROWS 14, 17 AND 20 ARE OUT. (FLT 4547) RELAMPED EMERGENCY LIGHT.SDR SWIA201127691Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 17 IS OUT. (FLT 4692) RELAMPED EMERGENCY LIGHT.SDR SWIA201127591Light · inoperativeNR 1, 2 AND 3 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 4820) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127590Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 10 IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201127391Light · inoperativeAFT 3 OVERHEAD EMERGENCY LIGHTS ARE OUT. (SERVICE) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127221Light · inoperativeOVERHEAD EMERGENCY LIGHTS OUT AT ROWS 10 & 17. (FLT 4546) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127098Light · inoperativeNR 7 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4614) RELAMPED EMERGENCY LIGHT.SDR SWIA201127012Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4611) RELAMPED EMERGENCY LIGHT.SDR SWIA201126733Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4494) RELAMPED EMERGENCY LIGHT.SDR SWIA201126643Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4494) RELAMPED EMERGENCY LIGHT.SDR SWIA201126576Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4777) RELAMPED EMERGENCY LIGHT.SDR SWIA201125808Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 15 IS OUT. (FLT 4498) RELAMPED EMERGENCY LIGHT.SDR SWIA201125671Light · inoperativeAFT CEILING EMERGENCY LIGHT IS OUT. (FLT 4461) RELAMPED EMERGENCY LIGHT.SDR SWIA201125602Light · inoperativeNR 1 CEILING EMERGENCY LIGHT IS OUT. (FLT 4775) RELAMPED EMERGENCY LIGHT.SDR SWIA201025381Light · inoperativeNR 1 CEILING EMERGENCY LIGHT OUT. (4667) RELAMPED EMERGENCY LIGHT.SDR SWIA201025074Light · inoperativeEMERGENCY EXIT ROW LIGHT BULBS INOPERATIVE. (FLT 4695) RELAMPED EMERGENCY LIGHT.
Back to N814SK