N803SK
Service difficulty reports · 276
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 = 'N803SK' 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 = 'N803SK' 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 SWIA202157977Hinge · gouged*PAX DOOR HINGE ON FUSELAGE SIDE HAS GOUGE ON AFT SECTION FROM SAFETY PIN (C-CHECK RO 5/3/2021) REPAIRED PAX DOOR HINGE FUSELAGE SIDE IAW CRJ 900 SRM 53-21-23-201-010-A01 REPAIR TYPE IV STEPS 1, 2, 3, 4. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITHSDR SWIA202158080Cargo Track · crackedFWD CARGO BAY: FWD/INBOARD SIDE TRACK CRACKED (VENDOR PN 500157 OR MHI PN BA690-30002-19) (C-CHECK RO 5/3/2021) ORDERED/RECEIVED NEW FWD CARGO FWD/INBOARD SIDE TRACK PN 500157. SEE MX TRANS # 22406548 FOR INSTALLATION.SDR SWIA202157976Skin · dented*JUST AFT OF FS 265 RH SIDE ABOVE STR 23R PROTRUDING DENT (C-CHECK RO 5/3/2021) REPAIRED DENT IN SKIN JUST AFT OF FS365 ABOVE STR 23R REF REO 690-53-11-1315 REV -- DATED 2021-04-14. SEE CONTINUATION CARD FOR DETAILS. PRESS LEAK CK GOOD. COMPLIED WITH SDR SWIA202157975Skin · chafedRH AILERON LOWER LEADING EDGE AT WS324.46 TO WS330.68 IS CHAFED (C-CHECK RO 5/3/2021) REPLACED RH AILERON LOWER LEADING EDGE SKIN AT WS324.46 TO WS330.60 REF DWG CC670-13000 REV. D / CRJ900 SRM 51-42-21-001-001-A01, AND CRJ900 SRM 51-42-06-001-001-A01. SDR SWIA2019102846611Unknown · malfunctionedGEAR DISAGREE. FOLLOWED THE QRH. GEAR STAYED DOWN. FLT # 4074 CLOSED. REMOVED NOSE LANDING GEAR PIN IAW AMM. PERFORMED OPERATIONAL TEST OF THE LANDING GEAR PSS IAW AMM.. PSS SYSTEM SHOWS IN RIG TEST GOOD. PERFORMED OPERATIONAL TEST OF THE LANDING-GEAR EXSDR SWIA2017072543574Bulkhead Web · corrodedFOUND THE LT BS 280 LOWER BULKHEAD CORRODED. REMOVED AND REPLACED THE LOWER BULKHEAD WEB IAW SRM AND REO.SDR SWIA2017072543568Floorbeam · corrodedBS 280 FLOORBEAM HAS CORROSION ON BOTH THE LT AND RT SIDES, AROUND THE CORROSION CAPS NEAR LBL 9 AND RBL 9. REMOVED AND INSTALLED A NEW BS 280 LT AND RT FLOORBEAM ANGLES IAW SRM.SDR SWIA2017072543573Skin · chafedLEFT AFT CORE COWL IS CHAFED ON THE OUTBOARD EDGE WHERE IT CONTACTS THE FORWARD UPPER AND LOWER CORE COWLS. REPAIRED THE DAMAGED AREA IAW SRM.SDR SWIA2017072543572Hinge · gougedPAX DOOR HINGE ON FUSELAGE SIDE IS GOUGED BY THE HINGE PIN. REMOVED AND INSTALLED PAX DOOR HINGE IAW SRM. PERFORMED PRESSURE/LEAK CHECK OF REPAIRED AREA IAW AMM. NO LEAKS DETECTED.SDR SWIA2017072543571Web · corrodedAFT WEB ON PAX DOOR HAD CORRODED AREAS. REPAIRED THE PAX DOOR AFT WEB IAW SRM.SDR SWIA2017072543570Web · corrodedFWD WEB ON PAX DOOR CORRODED. REPAIRED THE AREAS IAW SRM.SDR SWIA2017072543569Skin · dentedSMALL ROUND DENT FOUND ON THE SKIN AT STRINGER 23R, BS 265. THE DENT WAS REPAIRED IAW REO. OPS CHECKED GOOD IAW AMM.SDR SWIA201437619Sign · unknownFLOOR LEVEL EMERGENCY EXIT SIGN BY MAIN CABIN DOOR. REPLACED FLOOR LEVEL EMERGENCY LIGHT SIGN BY MAIN CABIN DOOR.SDR SWIA201437068Cover · crackedEMERGENCY EXIT LENS COVER ON RT SIDE IS CRACKED, REPLACED COVER.SDR SWIA201436147Light · inoperativeEMERGENCY OVERHEAD LIGHT AT ROW 14 IS BURNED OUT. FLT 4467 RELAMPED.SDR SWIA201335171Frame · corrodedCORROSION AT FS 284.00 & ON LOWER FLANGE OF FRAME AT FS 295.00, RT SIDE OF STRINGER 27 FRAME CUT OUT. C-CHECK REMOVED CORROSION ON LOWER FLANGE OF FRAME AT FS 295.00 RT SIDE OF STRINGER 27 FRAME CUT OUT IAW SRM.SDR SWIA201335172Stringer · corrodedREMOVING CORROSION AT CIRCUMFERENTIAL JOINT AFT OF FS 280.00 & ON STRINGER AT FS 284, BL 0. C-CHECK REPLACED STRINGER 27 AT FS 284, BL 0, PN SH670-31642-1 IAW SRM.SDR SWIA201335173Angle · crackedLT OTBD "L" ANGLE CRACKED AT FS 280 LBL 9.0. C-CHECK FABRICATED, LOCATED & DRILLED NEW LT OTBD "L" ANGLE FROM S6144-17 PO T-21000 IAW SRM.SDR SWIA201335175Skin · chafedBELLY CHAFE ON BOTTOM OF FUSELAGE UNDER PANEL 196AR. C-CHECK BLENDED OUT DAMAGE IAW REO.SDR SWIA201335174Pan · crackedINTERNAL FWD EQUIPMENT COMPARTMENT FLOOR PAN HAS CRACK JUST FWD OF FS 202.75 RT SIDE, NEXT TO ADG HAND PUMP. C-CHECK REPAIRED FLOOR PAN IAW REO.SDR SWIA201335181Seat Track · corrodedRT SIDE SEAT RAIL HAS CORROSION AT FS 699.40 - 720.00. C-CHECK BLENDED RT SIDE SEAT RAIL CORROSION AT FS 699.40 - 720.00 IAW REO.SDR SWIA201335180Seat Track · corrodedRT SIDE SEAT RAIL HAS CORROSION AT FS 744.15 - 761.85. C-CHECK BLENDED RT SIDE SEAT RAIL CORROSION AT FS 744.15 - 761.85 IAW REO.SDR SWIA201335179Seat Track · corrodedRT SIDE SEAT RAIL HAS CORRODED LUGS & FASTENERS AT FS 785.15 - 847.00+12. C-CHECK BLENDED RT SIDE SEAT RAIL CORROSION AT FS 785.15 - 847.00+12 IAW REO.SDR SWIA201335178Seat Track · corrodedLT SIDE SEAT RAIL HAS CORROSION AT FS 699.40 - 722.00. C-CHECK BLENDED LT SIDE SEAT RAIL CORROSION AT FS 699.40 - 722.00. IAW REO.SDR SWIA201335177Seat Track · corrodedLT SIDE SEAT RAIL HAS CORROSION AT FS 744.15 - 761.85. C-CHECK BLENDED LT SIDE SEAT RAIL CORROSION AT FS 744.15 - 761.85 IAW REO.SDR SWIA201335176Seat Track · corrodedLT SIDE SEAT RAIL HAS CORROSION AT 798.20. C-CHECK BLENDED LT SIDE SEAT RAIL CORROSION AT FS 798.20, IAW REO.SDR SWIA201335182Sill · corrodedAFT BAGGAGE BAY DOOR SILL HAS NUMEROUS AREAS OF CORROSION. C-CHECK REPAIRED DAMAGE TO AFT BAGGAGE CARGO BAY DOOR LOWER SILL, FS 1000.00 - FS 1047.00 IAW REO.SDR SWIA201333961Lamp · burned outFLT 4459, NR 6 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. REPLACED LAMPS.SDR SWIA201333962Lamp · burned outFLT 4605, EMERGENCY OVERHEAD LIGHT ROW 15 IS BURNED OUT. REPLACED LAMPS.SDR SWIA201333165Acm · failedSMELL AND SMOKE IN CABIN DURING TAXI, RIGHT PACK AUTO FAIL CAUTION CAME ON. (FLT 4465) REPLACED RT ACM IAW AMM, OPS CHECK GOOD. P/N GG670-95009-5 S/N ON 00548 S/N OFF 00635SDR SWIA201333010Light · inoperativeSECOND AFT EMERGENCY OVERHEAD LIGHT IS BURNED OUT. (FLT 4800) RELAMPED EMERGENCY LIGHT.SDR SWIA201332855Light · inoperativeOVERHEAD EMERGENCY LIGHT ROW 1 BURNED OUT. (FLT 4509) RELAMPED EMERGENCY LIGHT.SDR SWIA201332815Door · lack of lubeMCD WAS DIFFICULT TO OPEN AND SEEMED TO TAKE MORE THAN NORMAL FORCE. (FLT 4472) LUBED MCD, OPS CHECKS MCD FROM INSIDE AND OUT SEVERAL TIMES WITH NO DEFECTS NOTED.SDR SWIA201232423Light · inoperativeNR 2 EMERGENCY OVERHEAD LIGHT DOES NOT ILLUMINATE. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201232108Light · inoperativeNR 3 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. (FLT 4572) RELAMPED EMERGENCY LIGHT.SDR SWIA201232052Light · inoperativeNR 1 EMERGENCY OVERHEAD LIGHT OUT. (FLT 4638) RELAMPED EMERGENCY LIGHT.SDR SWIA201231977Light · inoperativeFORWARD AND AFT OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 4647) RELAMPED EMERGENCY LIGHTS.SDR SWIA201231895Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4856) RELAMPED EMERGENCY LIGHT.SDR SWIA201231636Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 17 IS OUT. (FLT 4662) RELAMPED EMERGENCY LIGHT.SDR SWIA201231490Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4814) RELAMPED EMERGENCY LIGHT.SDR SWIA201231453Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4497) RELAMPED EMERGENCY LIGHT.SDR SWIA201231364Light · inoperativeFORWARD OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4810) RELAMPED EMERGENCY LIGHT.SDR SWIA201231175Tire · burstRIGHT OUTBOARD MAIN NR 4 TIRE BURST. (FLT 4666) REPLACED RIGHT OUTBOARD MAIN NR 4 MLG TIRE. P/N: 90001200-1 S/N OFF: FEB07-0960SDR SWIA201231026Light · inoperativeROW 17 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4834) RELAMPED EMERGENCY LIGHT.SDR SWIA201230732Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4845) RELAMPED EMERGENCY LIGHT.SDR SWIA201230679Light · inoperativeOVERHEAD EMERGENCY LIGHTS ARE OUT AT ROWS 17 AND 20. (FLT 4606) RELAMPED EMERGENCY LIGHTS.SDR SWIA201230616Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 7 IS OUT. (FLT 4851) RELAMPED EMERGENCY LIGHT.SDR SWIA201230416Door · damagedAC EXTERNAL POWER DOOR DAMAGED AND SKIN ABOVE DOOR IS BENT. (FLT 4799) REPAIRED A/C EXTERNAL POWER DOOR AND SKIN ABOVE DOOR IAW REO.SDR SWIA201229686Floor Support · crackedC-CHECK, RIGHT COCKPIT FLOOR SUPPORT IS CRACKED. REPAIRED RIGHT COCKPIT FLOOR SUPPORT.SDR SWIA201229577Beam · crackedLEFT AND RIGHT BEAM AT FS 274.00 IS CRACKED. (C-CHECK) REPAIR CRACK AT FS 274.00 FOR LEFT AND RIGHT BEAM.
Back to N803SK