N773SK
Service difficulty reports · 160
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 = 'N773SK' 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 = 'N773SK' 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 SWIA202163237None · dented*LEFT WING INBOARD FLAP UPPER SKIN €“ DENT APPROXIMATELY WS84.00, 12€? FORWARD OF THE TRAILING EDGE. (MARKED) (C-CHECK RO 12/26/2021) COMPLIED WITH REPAIR ON DENT AT LH WING IB FLAP UPPER SKIN REF MHIRJ REO 670-57-52-510 REV. -- DATED 2021-11-19. COMSDR SWIA202163236None · damaged*LEFT WING OUTBOARD FLAP UPPER SKIN €“ 5 SMOKING RIVETS ON THE INTERCOSTAL BETWEEN THE RIB AT WS171.96 AND RIB AT WS179.96. (MARKED) (C-CHECK RO 12/26/2021) REMOVED AND INSTALLED NEW 5EA FASTENERS TO LH WING OUTBD FLAP UPPER SKIN REF REO 670-57-53-303 SDR SWIA202163235None · damaged*LEFT WING OUTBOARD FLAP UPPER SKIN €“ 10 SMOKING RIVETS AFT OF THE REAR SPAR ON THE RIB WS254.96. (MARKED) (C-CHECK RO 12/26/2021) REMOVED AND INSTALLED NEW 10EA FASTENERS TO LH WING OUTBD FLAP UPPER SKIN REF REO 670-57-53-303 REV -- DATED 2021-11-21 SDR SWIA202163281None · wornREMOVE AND REPLACE BUSHINGS AND HARDWARE ON RH AILERON WING AFT SPAR PER AMM (C-CHECK RO 12/26/2021) REMOVED AND REPLACED WITH NEW 8 BUSHINGS FROM R/H WING AFT SPAR REF CRJ 700 AMM 20-31-00-400-801-A01.SDR SWIA202163280None · wornREMOVE AND REPLACE BUSHINGS AND HARDWARE ON LH AILERON WING AFT SPAR PER AMM (C-CHECK RO 12/26/2021) REMOVED OLD BUSHINGS AND INSTALLED NEW BUSHINGS IN L/H AILERON WING AFT SPR MOUNTS REF CRJ 700 AMM 20-31-00-400-801-A01SDR SWIA202160626Anti-Ice System · malfunctionedWE RECEIVED A L COWL ANTI ICE DUCT MASTER WARNING IN CRUISE. PERFORMED QRH PROCEDURE EMERGENCY 12-4 WHICH INSTRUCTED AN IN FLIGHT SHUTDOWN. THE MSG PERSISTED. (FLIGHT 3161) REFERENCE AML 721053. REFERENCE AML 721095. T/S L COWL ANTI ICE DUCT WARNING MESSAGSDR SWIA202159549Window · delaminatedTRANSFER FROM EAML 681107 : DELAMINATION ON LEFT WINDOW OUTSIDE LIMITS (FLIGHT 3055 - FILED CLOSED) / REMOVED AND REPLACED LH SIDE WINDOW ASSY AS REQUIRED. OPS CHECK GOOD AT THIS TIME. REFERENCE APPLICABLE STEPS IN MIP 56-220-1000-SKY / TORQUE WRENCH SNSDR SWIA202158380Landing Gear · slowGEAR DISAGREE ON TAKEOFF. GEAR EVENTUALLY CAME UP ON ITS OWN AROUND 7000FT, MINUTE OR TWO AFTER TAKEOFF. RETURNED TO PHX. (FLIGHT 3097 - FILED CLOSED) AFTER SPEAKING WITH THE CAPTAIN FOUND BOTH MLG'S HAD OPERATED NORMALLY, THE NLG WAS SLOW TO STOW. INTERSDR SWIA2020030248869Seal · failedGEAR DISAGREE AFTER TAKEOFF AFTER GEAR WAS SELECTED UP. RAN QRH, GEAR CAME DOWN. FLIGHT 3104 - FILED CLOSED THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 20549129 WITH THE FOLLOWING CORRECTIVE ACTION: "REFERENCE CAMP CP20550120-1("FOUND NLG STRUT COMPLETELYSDR SWIA2019122747343Frame · crackedBS 235 FRAME HAD A CRACK INDICATION NOTED IN THE I/B RADIUS AT STINGGER 13L. 0.130" LONG. FAILED NDT. REMOVED, LOCATED, DRILLED , AND INSTALLED NEW FRAME IAW SRM.SDR SWIA2019122747340Angle · crackedRH AFT UPLOCK ANGLE CRACKED. RH AFT UPLOCK ANGLE WAS REMOVED AND REPLACED IAW SRM.SDR SWIA2019122747337Angle · crackedL/H FWD UPLOCK ANGLE CRACKED. L/H FWD UPLOCK ANGLE WAS REMOVED AND REPLACED IAW SRM.SDR SWIA2019122747333Frame · crackedLH FS 220.00 UPPER FRAME SECTOR HAS A VISUAL CRACK BTWEEN STR 13L & STR 14L. REMOVED, LOCATED AND DRILLED UP TO SIZE, INSTALLED L/H 220 FRAME IAW SRM.SDR SWIA2019122747358Structure · weakFS144.00 TO FS280.00 - REINFORCEMENT OF THE FRAMES AT FS222.00 AND FS235.00 REV C PART(S) A, B (C-CHECK) RO 12/26/2019 COMPLIED WITH SB FUSELAGE FS 144 TO FS 280 REINFORCEMENT OF THE FRAMES AT FS 220 AND FS 235 PARTS A AND B INCORPORATED SEE ATTACHED DOCUMSDR SWIA2019122747357Structure · weakPRIMARY STRUCTURE FS280.00 TO FS295.00 - INSPECTION AND REINFORCEMENT OF LINTEL STRINGER 3 OF THE MAIN PASSENGER DOOR REV C PART(S) A, B (C-CHECK) RO 12/26/2019 COMPLIED WITH SB, INSPECTION AND REINFORCEMENT OF STR 3 OF MAIN PASSENGER COMPARTMENT. REFER TOSDR SWIA2019122747356Structure · weakFORWARD FUSELAGE, FS144.00 TO FS280.00 - INSTALLATION OF STRUCTURAL PARTS ON THE NOSE LANDING GEAR (NLG) BOX AND ON THE FS202.75 BULKHEAD REV G PART(S) 0 (C-CHECK) RO 12/26/2019 COMPLIED WITH SB REV G, FUSELAGE FORWARD FUSELAGE FS 144 TO FS 280 INSTALLATIONSDR SWIA2019122747355Bulkhead · weakFS144.00 TO FS280.00 - REINFORCEMENT OF THE LEFT AND RIGHT SIDES OF THE FS202.75 BULKHEAD ABOVE THE FLOOR AND NOSE LANDING GEAR (NLG) BOX. REV E PART(S) A, C. COMPLIED WITH SB FUSELAGE PRIMARY STRUCTURE FS 144 TO FS 280 REINFORCEMENT OF THE LEFT AND RIGHTSDR SWIA2017102543920Angle · corrodedNUMEROUS AREAS OF CORROSION ON FRAMES AND ANGLES. CORROSION REMOVED IAW SRM AND INSTALLED A NEW ANGLE AT BS 939 IAW SRM.SDR SWIA2017102543919Striker · corrodedCORROSION DETECTED AT SERVICE DOOR LWR SILL ON SEAL STRIKER AROUND FLOOR PROTECTOR PLATE ATTACHING FASTENER HOLES. REPLACED THE DOOR SEAL STRIKER IAW SRM.SDR SWIA201642868Landing Gear · malfunctionedTHE NOSE GEAR DID NOT RETRACT AFTER TAKEOFF. GEAR DISAGREE. NO EMERGENCY DECLARED. COULD NOT DUPLICATE. REPLACED LANDING GEAR CONTROL PANEL AS A PRECAUTION OPS GOOD AT THIS TIME.SDR SWIA201541702Control Handle · failedGEAR DISAGREE ON TAKEOFF. R & R THE MLG CONTROL HANDLE AND LANDING GEAR SELECTOR VALVE, OPS CHECKED GOOD IAW AMM. PERFORMED LANDING GEAR EXTENSION AND RETRACTION IAW AMM. OPS CHECK GOOD.SDR SWIA201541439Skin · corrodedPASSENGER DOOR INNER SKIN REQUIRES REPLACEMENT DUE TO OUT OF LIMITS CORROSION. R & R PAX DOOR INNER IAW SRM.SDR SWIA201541438Floor Panel · crackedINTERNAL FWD EQUIPMENT COMPARTMENT, TRU BAY, FLOOR ON LT SIDE CRACKED. REMOVED DAMAGE FROM ELECTRICAL BAY FLOOR AND INSTALLED DOUBLER REPAIR IAW REO.SDR SWIA201541437Door Frame · corrodedPAX DOOR FWD FORMER REQUIRES REPLACEMENT DUE TO OUT OF LIMITS CORROSION. R & R PAX DOOR FWD IAW REO. PRESSURE CHECKED GOOD AT THIS TIME.SDR SWIA201438765Battery Pack · inoperativeAFT FLASHLIGHT INOPERATIVE. REPLACED AFT F/A FLASHLIGHT BATTERY. OPS CHECKED GOOD.SDR SWIA201437820Battery Pack · weakEMERGENCY LIGHT BATTERY PACK NR 4 IS WEAK. REPLACED BATTERY PACK IAW AMM.SDR SWIA201437154Lamp · burned outLEFT OVER WING EMERGENCY EXIT SIGN JUST ABOVE FLOOR HAS ONE LAMP BURNED OUT. REPLACED LAMP.SDR SWIA201437005Cover · missingSERVICE DOOR EMERGENCY LIGHT LOWER FLOOD LIGHT COVER MISSING. REPLACED .SDR SWIA201436625Seat Track · corrodedCORROSION ON RT SIDE SEAT RAIL FS 485 TO FS 590. C CHECK REMOVED CORROSION ON RT SIDE SEAT RAIL FS485 TO FS 590 IAW SRM & REO.SDR SWIA201436624Seat Track · corrodedCORROSION ON RT SIDE SEAT RAIL FS 590 TO FS 761.85. C CHECK REMOVED CORROSION ON RT SIDE SEAT RAIL FS 590 TO FS 761.85 IAW SRM & REO.SDR SWIA201436623Seat Track · corrodedCORROSION ON RT SIDE SEAT RAIL FS 785.15 TO FS 863. C CHECK REMOVED CORROSION ON RT SIDE SEAT RAIL FS 785.15 TO FS 863 IAW SRM & REO.SDR SWIA201436622Seat Track · corrodedCORROSION ON RT SIDE SEAT RAIL FS 893.0. C CHECK REPAIRED CORROSION ON RT SIDE SEAT RAIL IAW SRM & REO.SDR SWIA201436621Seat Track · corrodedCORROSION ON LT SIDE SEAT RAIL FS 379.0 TO FS 485.0. C CHECK REPLACED SEAT RAIL WITH NEW RAIL IAW AMM & REO.SDR SWIA201436620Seat Track · corrodedCORROSION ON LT SIDE SEAT RAIL FS 758.15 TO FS 830.40. C CHECK REMOVED CORROSION ON LT SIDE SEAT RAIL FS 758.15 TO FS 830.40 IAW SRM & REO.SDR SWIA201436619Seat Track · corrodedCORROSION AT LT OTBD SEAT RAIL AT FS 437.0. C CHECK BLENDED CORROSION ON LT OTBD SEAT RAIL AT FS 437.0 IAW SRM & REO.SDR SWIA201436618Seat Track · corrodedCORROSION AT LT INBD SEAT RAIL AT FS 533.0 TO FS 565.0. C CHECK REMOVED CORROSION ON LT INBD SEAT RAIL FS 533.0 TO FS 565.0 IAW SRM & REO.SDR SWIA201436617Seat Track · corrodedCORROSION AT LT INBD SEAT RAIL AT FS 581.0 TO FS 693.0. C CHECK REMOVED CORROSION ON LT INBD SEAT RAIL FS 581.0 TO FS 693.0 IAW SRM & REO.SDR SWIA201436616Seat Track · corrodedCORROSION AT RT SEAT RAIL AT FS 485.0 TO FS 581.0. C CHECK REPAIRED CORROSION AT RT SEAT RAIL FS 485.0 IAW REO.SDR SWIA201436615Seat Track · corrodedCORROSION AT RT SEAT RAIL AT FS 629.0. C CHECK BLENDED CORROSION AT SEAT RAIL FS 629.0 IAW SRM & REO.SDR SWIA201436614Angle · crackedRT HAND OTBD ANGLE PN CC670-53-11-579-4 IS CRACKED. C CHECK REPLACED FS 280 RBL 9 OTBD ANGLE PN CC670-53-11-579-4 IAW SRM.SDR SWIA201436628Intercostal · corrodedAFT CARGO SILL INTERCOSTAL AT RT 1051 - 1070 CORRODED. C CHECK BLENDED CORROSION & RESTORED FINISH IAW REO.SDR SWIA201436627Intercostal · corrodedAFT CARGO SILL INTERCOSTAL AT RT 1031 - 1051 CORRODED. C CHECK BLENDED & RESTORED FINISH ON AFT CARGO SILL AT RT 1031 - 1051 IAW REO.SDR SWIA201436626Intercostal · corrodedAFT CARGO SILL INTERCOSTAL AT RT 1000 - 1031 CORRODED. C CHECK BLENDED CORROSION & RESTORED FINISH IAW REO.SDR SWIA201436631Skin · chafedCHAFING ON SKIN AT FS 977.00, STRINGER 27. C CHECK REPAIRED IAW SRM & REO.SDR SWIA201436630Support Angle · corrodedSERVICE DOOR SILL TO FLOOR SUPPORT ANGLE HAS CORROSION. C CHECK REPLACED SERVICE DOOR SILL FLOOR SUPPORT ANGLE IAW SRM.SDR SWIA201436629Support Angle · corrodedPAX DOOR SILL TO FLOOR SUPPORT ANGLE CORRODED. C CHECK REPLACED FLOOR SUPPORT ANGLE FWD, MID & AFT PN SH670-31875-3, -6 & -7 & CAP ANGLE PN SH670-31825-9 IAW SRM.SDR SWIA201436633Slat · gougedLT NR 3 SLAT GOUGED ON TE 3 FEET INBD OF OTBD EDGE. C CHECK REPAIRED LT NR 3 SLAT IAW STS EA.SDR SWIA201436632Skin · chafedLT ENG PANEL 433AB HAS INNER SKIN CHAFE JUST FWD OF THE MOST FWD LATCH. C CHECK LT ENG PANEL 433AB INNER SKIN CHAFE REPAIRED IAW REO.SDR SWIA201334340Light · inoperativeEMERGENCY EXIT SIGN AT GALLEY SERVICE DOOR BURNED OUT. FLT#6331 RELAMPED.SDR SWIA201334290Light · inoperativeEMERGENCY LIGHT ON CEILING BURNED OUT. FLT#5223 RELAMPED.
Back to N773SK