N791SK
Service difficulty reports · 128
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 = 'N791SK' 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 = 'N791SK' 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 SWIA202157212Strap · corrodedSTRAP THAT ATTACHES FUSELAGE PANEL 195DL/196DR IS CORRODED. (C-CHECK RO 4/1/2021) REMOVED DAMAGE FROM STRAP THAT ATTACHED FUSELAGE PANEL 195DL/196DR BY BLENDING AND EVALUATED IAW CRJ700 SRM 53-00-00-101-001-A01. MEASURED ORIGINAL THICKNESS AT 0.063", REMSDR SWIA202157144Skin · dentedDENT FOUND AT APPROXIMATELY FS 240 STRINGER 19/20L. (C-CHECK RO 4/1/2021) DENT ON EXTERNAL FUSELAGE SKIN AFT OF FS250 ABOVE STGR 25L REPAIRED. REF REO 670-53-11-1670 REV -- DATED 2021-03-08.. COMPLIED WITH 51-900-1002-SKY.SDR SWIA202157203Cup · crackedDOOR SURROUND HINGE CUP 151 ELW CRACKED (C-CHECK RO 4/1/2021) RECEIVED NEW HINGE CUP 151 ELW P/N: KBA670-51064-19@. LOCATED AND DRILLED NEW HINGE / CUP 151ELW IAW CRJ 700 SRM 51-40-11-001-001-A01. (SEE CONTINUATION FOR FURTHER DETAILS)SDR SWIA202157202Cup · crackedDOOR SURROUND HINGE CUP 151 JLW CRACKED (C-CHECK RO 4/1/2021) RECEIVED NEW HINGE CUP 151 JLW P/N: KBA670-51064-17@. LOCATED AND DRILLED NEW HINGE CUP 151 JLW IAW CRJ 700 SRM 51-40-11-001-001-A01. ( SEE CONTINUATION FOR FURTHER DETAILS).SDR SWIA202157211Latch · corrodedRH OVERWING EMERGENCY EXIT LATCH HAS CORRODED HARDWARE (C-CHECK RO 4/1/2021) REMOVED CORRODED HARDWARE AND INSTALLED NEW HARDWARE (10EA BOLTS, 10EA WASHERS, 10EA NUTS) ON RH OVERWING EMERGENCY EXIT LATCH. REF: CRJ700 AMM 20-21-00-910-801-A01. CALIBRATED SDR SWIA202157210Latch · corrodedLH OVERWING EMERGENCY EXIT LATCH HAS CORRODED HARDWARE (C-CHECK RO 4/1/2021) REMOVED CORRODED HARDWARE AND INSTALLED NEW HARDWARE (10EA BOLTS, 10EA WASHERS, 10EA NUTS) ON LH OVERWING EMERGENCY EXIT LATCH. REF: CRJ700 AMM 20-21-00-910-801-A01. CALIBRATED SDR SWIA202157143Skin · dentedDENT LOCATED ON RIGHT SIDE OF AIRCRAFT NOSE BETWEEN STRINGER 12A & 13A AFT OF FS220.00. DAMAGE DIMENSIONS: 4€? X 1.5€? X .102 DEEP. COMPLIED WITH TEMP REPAIR PER REO 670-53-11-1548 REV -- DATE 2019-10-06 AND REO 670-51-00-085 REV €“ A, DATED 2017-08-23. PSDR SWIA2019071246052Sleeve · leakingWHILE CLIMBING RECEIVED A LEFT BLEED DUCT WARNING AND PLANE BEGAN TO DE-PRESSURIZE. INITIATED AN EMERGENCY DESCENT. (FLT#5355) CLOSED FOUND BLEED AIR LEAK AT THE LEFT AC PACK HEAT EXCHANGER INLET SLEEVE BLOWING TOWARD BLEED LEAK DETECTION LOOPS MT141 AND MTSDR SWIA201541667Frame · corrodedFRAME BELOW CABIN FLOOR, FS 295.00 APPROXIMATELY STR 27. REPAIRED FRAME BELOW CABIN FLOOR , FS295.00, STR 27, IAW REO.SDR SWIA201541668Frame · corrodedFRAME CORRODED, BELOW CABIN FLOOR, FS 310.00 APPROXIMATELY STR 27. PERFORMED SECTION 1 PERMANENT REPAIR IAW SRM AND STS EA. LEAK CHECK GOOD AT THIS TIME.SDR SWIA201438608Cover · missingGALLEY FLOOR EMERGENCY EXIT FLOOD LIGHT MISSING COVER. INSTALLED NEW COVER ON THE GALLEY FLOOR EMERGENCY EXIT FLOOD LIGHT IAW AMM.SDR SWIA201438399Light · inoperativeEXTERIOR EMERGENCY LIGHT NR 5 INOPERATIVE. R & R EXTERIOR EMERGENCY LIGHT IAW AMM.SDR SWIA2014062338261Fms · lockedFMS LOCKED UP IN FLT.SDR SWIA201438261Fms · lockedFMS LOCKED UP IN FLIGHT.SDR SWIA201438113Floorbeam · crackedFS 280, LBL 13 FLOORBEAM ANGLE CRACKED AT CHEM MILL. C-CHECK FLOORBEAM, LT ANGLE REPLACED IAW SRM.SDR SWIA201438116Skin · corrodedAVIONICS DOOR SURROUND STRUCTURE, THE INTERNAL SURROUND SKIN AT THE CUTOUT HAS CORROSION IN SEVERAL AREAS. C-CHECK, REMOVED CORROSION FROM AVIONICS BAY DOOR SURROUND STRUCTURE INTERNAL SKIN IAW REO.SDR SWIA201438115Fitting · gougedFWD BAGGAGE BAY DOOR SURROUND STRUCTURE THE UPPER AFT FITTING HAS A GOUGE. C-CHECK, CREATED SMOOTH CONTOUR BY REMOVING SHARP EDGES AND NOT INCREASING DEPTH OF GOUGE IAW EA.SDR SWIA201438114Skin · gougedRT SIDE SKIN GOUGED BS 358 AND WL 80. C-CHECK, BLENDED IAW REO.SDR SWIA201438117Panel · chafedPANEL 699BB HAS A SMALL CHAFE. C-CHECK, BLENDED CHAFE ON PANEL 699BB IAW STS EA.SDR SWIA201438118Skin · dentedLEFT INBD FLAP SKIN DENTED. BOTTOM SIDE. C-CHECK, REPAIRED IAW REO.SDR SWIA201335480Battery Pack · dischargedNR 4 EMERGENCY LIGHT ON SIDEWALL AT 12D DOES NOT ILLUMINATE. FLT 5620 REPLACED NR 4 EMERGENCY BATTERY PACK. PN AD-2013-1A SN ON 125862 SN OFF 77248.SDR SWIA201335209Switch · faultyMAIN CABIN DOOR HARD TO OPEN, WHEN DOOR IS OPEN, IT TRIES TO CLOSE ON ITS OWN. FLT5196 INSTALLED MAIN CABIN DOOR CLOSE SWITCH.SDR SWIA201334857Battery · dischargedEMERGENCY LIGHTS BURNED OUT. SERVICE REPLACED NR 2 POWER SUPPLY BATTERY ASSEMBLY, PN 2013-1A, SN ON 34966, SN OFF 79423.SDR SWIA201231836Release Mech · dirtyCAPTAIN'S SEAT BELT RELEASE DOES NOT RELEASE SEAT BELT EASILY. (FLT 6478) CLEANED AND LUBED CAPTAINS SEAT BELT RELEASE BUCKLE.SDR SWIA201231580Sign · missingEMERGENCY EXIT SIGN RIGHT SIDE OF GALLEY DOOR IS MISSING. (SERVICE) REPLACED MISSING EMERGENCY EXIT SIGN.SDR SWIA201229851Light · inoperativeNR 3 LEFT EXTERIOR EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229106Actuator · failedSLAT FAIL ON APPROACH IN TO DEN. (FLT 5538) REPLACED THE LEFT WING SLAT ACTUATOR 3-1. P/N: 766385C S/N OFF: B3273SDR SWIA201024315Light · inoperativeEMERGENCY LIGHT COVER INOP AT GALLEY SERVICE DOOR. (FLT 6567) REPLACED LIGHT ASSEMBLY.
Back to N791SK