N795SK
Service difficulty reports · 78
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 = 'N795SK' 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 = 'N795SK' 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 SWIA202161096None · chafed* RH SLAT TRACK 1-3, TRACK IS CHAFED. FLAGGED (C-CHECK RO 9/21/2021) REPAIRED RH SLAT TRACK 1-3, TRACK IS CHAFE REF CRJ-700 SRM 51-12-00-001-001-A01 AND REO 670-57-42-1161 REV -- DATED:2021-08-24. COMPLIED WITH 51-900-1002-SKYSDR SWIA202161094None · chafed* RH SLAT TRACK 1-1 HAS CHAFE. FLAGGED (C-CHECK RO 9/21/2021) REPAIRED RH SLAT TRACK 1-1 HAS CHAFE REF CRJ-700 SRM 51-12-00-001-001-A01 AND REO 670-57-42-1160 REV -- DATED 2021-08-24.COMPLIED WITH 51-900-1002-SKY.SDR SWIA202161093None · dented*PROTRUDING DENT ON EXTERNAL FUSELAGE SKIN BETWEEN FS 280.00 €“ 295.00, STGR 25R €“ 26R (C-CHECK RO 9/21/2021) PERMANENTLY REPAIRED PROTRUDING DENT AND GOUGE ON INTERNAL AND EXTERNAL SKINE BETWEEN FS280-FS295 STGR 25R TO 26R REF REO 670-53-21-2117 REVSDR SWIA202161092None · dented*PROTRUDING DENT ON EXTERNAL FUSELAGE SKIN BETWEEN FS 280.00 €“ 295.00, STGR 24R €“ 25R (C-CHECK RO 9/21/2021) PROTRUDING DENT AND GOUGE ON EXTERNAL FUSELAGE SKIN BETWEEN FS 280.00 €“ 295.00, STGR 24R €“ 25R PERMANENTLY REPAIRED REF REO 670-53-21-21SDR SWIA202161091None · dented*MULTIPLE DENTS ON EXTERNAL FUSELAGE SKIN BETWEEN FS 1031.00 €“ 1051.00, STGR 26R €“ 21R (C-CHECK RO 9/21/2021) REPAIRED MULTIPLE DENTS ON EXTERNAL FUSELAGE SKIN BETWEEN FS 1031.00 €“ 1051.00, STGR 26R €“ 21R REF CRJ-700 SRM 51-26-01-001-001-A01,REOSDR SWIA2019082046194Unknown · smokeSMOKE IN THE CABIN AT GATE. THE APU WAS ON AND THE RIGHT PACK WAS ON. AFTER POWERING DOWN AIRCRAFT, SMOKE DISSIPATED. EXPEDITED DEPLANEMENT THROUGH MAIN CABIN DOOR. UPON ARRIVAL TO AIRCRAFT NO SIGN OF SMOKE/SMELL IN CABIN. ACCORDING TO FLIGHT CREW, APU AND OSDR SWIA2019031245619Computer · failedCONTINUOUS GEAR HORN AND FLASHING YELLOW GEAR UP INDICATIONS ON EICAS 1 AT TOP OF DESCENT. LASTED APPROXIMATELY 1 MINUTE. RETURNED TO FIELD. (FLT 5598) CLOSED REMOVED AND REPLACED NR 2 RAD. ALT. COMPUTER WITH SERVICEABLE UNIT IAW AMM. OPS CHECK GOOD. ALL GEAR SDR SWIA201744046Fireshield · chafedRT ENGINE LOWER CORE COWL HAS CHAFING ON BLOW OFF DOOR FIRE SHIELD. (C-CHECK) REPLACED OUT OF LIMITS RT LOWER CORE COWL BLOW OFF DOOR FIRESHIELD, P/N: CN624-3171-203 IAW SRM.SDR SWIA201744045Floor Support · corrodedCOCKPIT FLOOR SUPPORT FORWARD OF FS280 CROSS BEAM, CORROSION BETWEEN RBL9 AND LBL9. (C-CHECK) REMOVED AND REPLACED COCKPIT FLOOR SUPPORT FWD OF FS280.00 CROSS BEAM IAW SRM.SDR SWIA201744044Angle · corrodedFLOOR SILL ANGLE AT SERVICE DOOR CORRODED. (C-CHECK) REMOVED AND REPLACED THE CORRODED SVC DOOR FLOOR SILL ANGLE IAW SRM.SDR SWIA201744043Door Sill · corrodedAFT CARGO DOOR SILL HAS CORROSION. (C-CHECK) RO: 12/06/2017 REMOVED AND REPLACED AFT CARGO DOOR SILL IAW SRM. PRESSURIZATION LEAK CHECK C/W. NO LEAKS DETECTED.SDR SWIA201641932Angle · corrodedCRAWLWAY ANGLE ON FRAME FS 295.00 HAS CORROSION. REPLACED CRAWLWAY ANGLE AT FS 295.00 BETWEEN STR 26L AND STR 26R IAW SRM.SDR SWIA201641931Frame · corrodedFRAME AT FS 295.00 HAS CORROSION AROUND FASTENERS BETWEEN STR 26L TO STR 26R. REPAIRED FRAME AT FS 295.00 BETWEEN STR 26L AND 26R IAW SRM. PERFORMED LEAK CHECK OF FRAME AT FS 295 BETWEEN STRINGERS 26L AND 26R IAW AMM. LEAK CHECK GOOD.SDR SWIA201439104Battery Pack · inoperativeFWD EMERGENCY FLASHLIGHT INOPERATIVE. REPLACED FWD GALLEY EMERGENCY FLASHLIGHT BATTERY WITH A SERVICEABLE UNIT. OPS CHECKED GOOD.SDR SWIA201438847Battery Pack · failedMULTIPLE EMERGENCY LIGHTS INOPERATIVE. R & R NR 2 AND 3 EMERGENCY BATTERY PACKS AND CHARGERS IAW AMM,SDR SWIA201438848Floorbeam · damagedRT BS 274, RBL 12 COCKPIT FLOORBEAM HAS ONE MISDRILLED HOLE IN RADIUS OF STIFFENER AND GOUGE IN STIFFENER. C-CHECK, COMPLIED WITH REPAIR FOR RT FS 274, RBL 12.00, REF REO.SDR SWIA201438851Floorbeam · corrodedCORROSION ON BS 280 COCKPIT FLOORBEAM, C-CHECK, INSTALLED NEW FLOORBEAM LBL 9 - RBL 9 IAW SRM.SDR SWIA201438850Floorbeam · corrodedCORROSION ON RT BS 280, FLOORBEAM ANGLE. REPLACED FLOORBEAM ANGLE IAW SRM.SDR SWIA201438849Bulkhead Web · corrodedLEFT SIDE LOWER BULKHEAD WEB AT BS 280, LBL 12 HAS CORROSION. C-CHECK, REPLACED LT SIDE LOWER BULKHEAD WEB IAW REO.SDR SWIA201438854Floorbeam · crackedCOCKPIT FLOORBEAM CRACKED AT LBL 12, BS 274, C-CHECK, REPAIRED FLOORBEAM IAW REO.SDR SWIA201438853Floorbeam · crackedCOCKPIT FLOORBEAM CRACKED AT RBL 12, BS 274, C-CHECK, REPAIRED FLOORBEAM IAW REO.SDR SWIA201438852Floorbeam · crackedBS 280 FLOORBEAM IS CRACKED, C-CHECK, INSTALLED NEW FLOORBEAM IAW SRM.SDR SWIA201438855Skin · chafedCHAFE FOUND ON FUSELAGE STRINGER 27 APPROXIMATELY AT BS 977. C-CHECK, REPAIRED IAW REO.SDR SWIA201438857Skin · chafedPANEL 684EB HAS SMALL CHAFE MARK. C-CHECK, BLENDED PANEL 684EB, REF SRM.SDR SWIA201438856Skin · chafedLEFT INBD FLAP PANEL NR 584 EB IS CHAFED, C-CHECK, BLENDED PANEL IAW SRM.SDR SWIA201335572Printer · malfunctionedSMOKE & ELECTRICAL BURNING SMELL ORIGINATING FROM ACARS PRINTER. FLT 5160 REPLACED ACARS PRINTER IAW AMM, PN 497126-2 SN ON 44290988 SN OFF TP44290687.SDR SWIA201125978Charger · failedFLOOR LEVEL EMERGENCY EXIT LIGHT OUT AT 12D. (FLT 6581) REPLACED NR 4 EMERGENCY LIGHT BATTERY CHARGER.SDR SWIA201025357Wheel · bindingUNABLE TO OPEN MAIN CABIN DOOR. (FLT 6688) REPLACED SUPPORT WHEEL SYSTEM CABLE PER AMM.
Back to N795SK