N771SK
Service difficulty reports · 177
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 = 'N771SK' 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 = 'N771SK' 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 SWIA2019120546818Fuel Sys · unbalancedUNABLE TO CONTROL FUEL BALANCE WITH FUEL VALVE DISABLED OPEN. FUEL QUICKLY WENT OVER 1000 IMBALANCE AND CREW HAD TO USE SLIPS AND TURNS TO CONTROL FUEL BALANCE. DIVERTED TO RST. FLIGHT 3037 CLOSEDPERFORMED OPS CHECK OF FUEL TRANSFER SYSTEM. IAW AMM. OPS CHESDR SWIA2017122644096Stringer · corrodedSTRINGER 21L BETWEEN BS 310 - 333 & 333 TO 349 CORRODED. REMOVED AND REPLACED THE STRINGER IAW SRM. PRESSURE CHECKED GOOD.SDR SWIA2017122644095Angle · corrodedBS 280 FLOORBEAM UPPER SPLICE STRIP IS HAS CORROSION AT RIGHT SIDE OF THE COCKPIT DOOR OPENING. REMOVED AND REPLACED THE FLOORBEAM UPPER SPLICE STRIP IAW SRM.SDR SWIA2017122644094Fitting · chafedFORWARD CARGO DOOR, EXTERNAL SURROUND STRUCTURE FWD AND AFT UPPER GUIDE FTTINGS CHAFED. REMOVED AND REPLACED THE GUIDE FTTINGS IAW AMM. OPS CHECKED GOOD.SDR SWIA201642374Proximity Sensor · out of adjustGEAR DISAGREE NLG WOW NR 2 SN SR PX 11 OUT OF RIG. ADJUSTED BOTH NLG WOW PX 03 SENSORS IAW AMM. REPEATED GEAR SWINGS, OPS CHECK GOOD.SDR SWIA201541555Angle · corrodedPAX DOOR KICKPLATE ANGLE UNDER MID CAP ANGLE IS CORRODED. REPLACED KICKPLATE WITH NEW ANGLE IAW SRM.SDR SWIA201541556Roller · wornLEFT WING SLAT TRACK 1-2 FORWARD/OTBD SIDE ROLLER WITH A FLAT SPOT. R & R LT SLAT TRACK 1-2 FWD OTBD SIDE ROLLER IAW AMM.SDR SWIA201541554Angle · corrodedPAX DOOR THRESHOLD FWD CAP ANGLE IS CORRODED. REPLACED CORRODED ANGLE WITH NEW ANGLE IAW SRM.SDR SWIA201438815Loop · out of adjustLEFT BLEED DUCT WARNING MESSAGE, CLIMBING THRU FL2140. ALL BLEED SOURCES CLOSED. RETURNED TO FIELD. ADJUSTED LT BLEED LOOPS AND LOCATED OUTER LOOP CONTACTING INNER LOOP JUST BELOW LT HEAT EXCHANGER IAW AMM. ALL SYSTEMS OPS CHECKED NORMAL.SDR SWIA201438700Lamp · inoperativeRT SIDE EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM.SDR SWIA201437547Lens · missingOVERHEAD EMERGENCY LIGHT LENS COVER IS MISSING. INSTALLED EMERGENCY CALL LIGHT LENS ON AFT EMERGENCY SIGN IAW AMM.SDR SWIA201437356Seat Track · corrodedLT SEAT TRACK FROM BS 485-581 CORRODED. C-CHECK, FABRICATED AND INSTALLED NEW SEAT TRACK IAW SRM AND REO.SDR SWIA201437355Seat Track · corrodedLEFT SEAT TRACK AT BS 581-661 CORRODED. C-CHECK, REPLACED SEAT TRACK.SDR SWIA201437358Seat Track · corrodedRT SEAT TRACK AT BS 661-836 CORRODED. C-CHECK, INSTALLED NEW SEAT TRACK IAW AMM.SDR SWIA201437357Seat Track · corrodedLT SEAT TRACK AT BS 661- 836 CORRODED. C-CHECK, REPLACED SEAT TRACK IAW SRM.SDR SWIA201437366Seat Track · corrodedLEFT SEAT TRACK HAD SEVERAL AREAS OF CORROSION BS 483-573. C-CHECK, CORROSION REMOVED IAW REO.SDR SWIA201437365Seat Track · corrodedLT SEAT TRACK HAD SEVERAL AREAS OF CORROSION, BS 573-675. C-CHECK, REMOVED CORROSION IAW REO.SDR SWIA201437364Seat Track · corrodedRIGHT SEAT TRACK HAD SEVERAL AREAS OF CORROSION, BS 573-675. C-CHECK, REPAIRED SEAT TRACK IAW REO.SDR SWIA201437363Seat Track · corrodedLEFT SEAT TRACK HAS SEVERAL AREAS OF CORROSION, BS 675-713. C-CHECK, REPAIRED SEAT TRACK IAW REO.SDR SWIA201437362Seat Track · corrodedLT SEAT TRACK CORRODED, BS 713-763. C-CHECK, REMOVED CORROSION IAW REO.SDR SWIA201437361Seat Track · corrodedLT SEAT TRACK CORRODED BS 784-861. C-CHECK, REPLACED SEAT TRACK IAW REO AND AMM.SDR SWIA201437360Seat Track · corrodedRT SEAT TRACK SEVERAL AREAS OF CORROSION, BS 675-713. C-CHECK, SEAT TRACK REPLACED IAW AMM.SDR SWIA201437359Seat Track · corrodedRT SEAT TRACK CORRODED BS 713-763. REPAIRED SEAT TRACK IAW REO.SDR SWIA201437369Retainer · corrodedGALLEY DOOR LOWER SEAL RETAINER VERTICAL FLANGE CORRODED AT SCREW HOLES. C-CHECK, REPLACED SEAL RETAINER IAW SRM.SDR SWIA201437368Intercostal · corrodedINTERCOSTAL CORRODED BS 362 RBL 2 FWD OF MAIN AVIONICS DOOR CUTOUT. C-CHECK, REMOVED AND INSTALLED NEW INTERCOSTAL IAW SRM.SDR SWIA201437367Intercostal · corrodedINTERCOSTAL CORRODED BS 362 LBL 2 FWD OF MAIN AVIONICS DOOR CUTOUT. C-CHECK, REMOVED AND INSTALLED NEW INTERCOSTAL IAW SRM.SDR SWIA201437371Retainer · corrodedMAIN AVIONICS BAY DOOR SEAL RETAINER CORRODED AT FWD EDGE. C-CHECK, R & R SEAL RETAINER IAW SRM AND AMM.SDR SWIA201437370Retainer · corrodedMAIN AVIONICS BAY DOOR SEAL RETAINER CORRODED AT AFT EDGE. C-CHECK, R & R SEAL RETAINER IAW SRM AND AMM.SDR SWIA201437372Skin · chafedRT INBD FLAP VANE PANEL NR 684ET HAS CHAFE DAMAGE. C-CHECK, REPAIRED IAW SRM.SDR SWIA201437020Lamp · burned outFLOOR LEVEL EMERGENCY LIGHT AT MAIN CABIN DOOR APPEARS TO BE BURNED OUT, REPLACED LAMP.SDR SWIA201436772Lamp · burned outEMERGENCY EXIT SIGN BY MAIN CABIN DOOR ONE LIGHT BULB BURNED OUT. REPLACED LAMP.SDR SWIA201436379Light · inoperativeEMERGENCY EXIT ROW AB LIGHT BULB IS BURNED OUT. FLT 6369 RELAMPED.SDR SWIA201436008Printed Ckt Board · failedEMERGENCY LIGHT ON WHEN PILOTS SWITCH IS IN THE ARM POSITION. FLT 5485 REPLACED JB11 PCB5 IAW AMM.SDR SWIA201335661Light · inoperativeSECOND TO LAST EMERGENCY LIGHT IN CEILING IS BURNED OUT. FLT 6368 RELAMPED.SDR SWIA201335191Light · inoperativeBOTTOM LT EMERGENCY EXIT SIGN ROW 12 IS BURNED OUT. FLT 4974 RELAMPED.SDR SWIA201333979Light · inoperativeNR 3 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT#5559 RELAMPED.SDR SWIA201332682Light · inoperativePASSENGER DOOR EXTERNAL EMERGENCY LIGHT BURNED OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201232126Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C-CHECK) REPLACED FS 280 FLOORBEAM IN REFERENCE TO REO.SDR SWIA201231563Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201231210Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6472) RELAMPED EMERGENCY LIGHT.SDR SWIA201230965Light · inoperativeNR 4 AND NR 5 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 5581) RELAMPED EMERGENCY LIGHTS.SDR SWIA201230964Trim Panel · noisyLOUD CRACKLING SOUND AND OCCASIONAL LOUD POP. (FLT 6430) REMOVED S TRIM FROM SERVICE DOOR.SDR SWIA201230963Relay · failedEMERGENCY LIGHTS COME ON AND OFF. (FLT 6462) REPLACED RELAY K135 IN REFERENCE TO CRJ 700 MM.SDR SWIA201230917Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230567Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5572) RELAMPED EMERGENCY LIGHT.SDR SWIA201230432Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 7 IS OUT. (FLT 5548) RELAMPED EMERGENCY LIGHT.SDR SWIA201230391Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229920Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6357) RELAMPED EMERGENCY LIGHT.SDR SWIA201229491Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5321) RELAMPED EMERGENCY LIGHT.SDR SWIA201229178Charger · failedMUTIPLE CABIN EMERGENCY LIGHTS ARE OUT. (FLT 5433) REPLACED NR 3 EMERGENCY BATTERY PACK & CHARGER ASSEMBLIES. P/N: AD-2013-1A S/N OFF: 41230
Back to N771SK