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 SWIA202158104Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON RH SIDE SEAT TRACK BETWEEN FS 570.00 €“ 661.00+16 (C-CHECK RO 5/3/2021) REPLACED RH SIDE SEAT TRACK FROM FS570-661+16 REF CRJ900 AMM 53-00-49-400-801-A07.SDR SWIA202158103Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON RH SIDE SEAT TRACK BETWEEN FS 683.00 €“ 661.00+16 (C-CHECK RO 5/3/2021) REPLACED RH SIDE SEAT TRACK BETWEEN FS683-661.00+16 REF CRJ900 AMM 53-00-49-400-801-A07. SEE CONTINUE CARD FOR DETAILS.SDR SWIA202158102Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON LH SIDE SEAT TRACK BETWEEN FS 683.00 €“ 661.00+16 (C-CHECK RO 5/3/2021) INSTALLED REPLACEMENT L/H SEAT TRACK BETWEEN FS661+16 - FS683.00 REF CRJ900 AMM 53-00-49-400-801-A07SDR SWIA202158101Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON LH SIDE SEAT TRACK BETWEEN FS 570.00 €“ 661.00+16 (C-CHECK RO 5/3/2021) EVALUATED CORROSION ON LH SIDE SEAT TRACK BETWEEN 570.00 €“ FS 661.00+16 FOUND IT IS IN A NO DAMAGE ALLOWED AND IS OUT OF LIMITS REF CRJ900 SRM 53-SDR SWIA202158100Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON LH SIDE SEAT TRACK BETWEEN FS 485.00 €“ 570.00 (C-CHECK RO 5/3/2021) REPLACED LH SIDE SEAT TRACK FROM FS485-570 REF CRJ900 AMM 53-00-49-400-801-A07. SEE CONTINUE CARD FOR DETAILS.SDR SWIA202158099Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON LH SIDE SEAT TRACK BETWEEN FS 379.00 €“ 485.00 (C-CHECK RO 5/3/2021) REPLACE LEFT HAND SIDE SEAT TRACK BETWEEN FS379.00 TO FS485 REF CRJ900 AMM 53-00-49-400-801-A07.SDR SWIA202158098Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK LBL9 BETWEEN FS 661.00+32 €“ 581.00 (C-CHECK RO 5/3/2021) DUPLICATE SEE CAMP#22473633 FOR WORK PERFORMED.SDR SWIA202158097Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK LBL9 BETWEEN FS 661.00+32 €“ 581.00 (C-CHECK RO 5/3/2021) INSTALLED NEW SEAT TRACK ON LBL9 AT BETWEEN FS581.00 TO FS661.00+32 REF CRJ-900 AMM 53-00-49-400-801-A07 / USED CALIBRATED TORQUE TOOL TUC7825 CASDR SWIA202158096Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK LBL9 BETWEEN FS 661.00+32 €“ 693.00 (C-CHECK RO 5/3/2021) INSTALLED NEW SEAT TRACK ON LBL9 AT BETWEEN FS661.00+32 TO FS693.00 REF CRJ-900 AMM 53-00-49-400-801-A07 / USED CALIBRATED TORQUE TOOL TUC7825 CASDR SWIA202158095Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK RBL9 BETWEEN FS 581.00 - 485.00 (C-CHECK RO 5/3/2021) INSTALLED NEW SEAT TRACK AT RBL9 BETWEEN FS485.00 TO FS581.00 REF CRJ-900 AMM 53-00-49-400-801-A07 / USED CALIBRATED TOOL TUC7825 CAL DUE DATE: 28-FEBSDR SWIA202158094Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK RBL9 BETWEEN FS 661.00+32 €“ 581.00 (C-CHECK RO 5/3/2021) INSTALLED NEW FLOOR SEAT P/N SH690-33404-1 TRACK RBL9 BETWEEN FS 661.00+32-581.00 REF CRJ-900 AMM 53-00-49-400€”801-A07SDR SWIA202158093Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK RBL9 BETWEEN FS 661.00+32 €“ 693.00 (C-CHECK RO 5/3/2021) EVALUATED MULTIPLE AREAS AND FOUND DAMAGE IS BEYOND THE ALLOWABLE LIMITS REF CRJ 900 SRM 53-31-49-101-001-A02. REMOVED AND REPLACED WITH NEW SEATSDR SWIA202158092Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK LBL9 BETWEEN FS 485.00 - 364.00 (C-CHECK RO 5/3/2021) INSTALLED NEW SEAT TRACK ON LBL9 BETWEEN FS364.00- FS485.00 REF CRJ-900 AMM 53-00-49-400-801-A07 / USED CALIBRATED TOOL TUC7825 CAL DUE DATE: 28-FEB-2SDR SWIA202158091Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK RBL9 BETWEEN FS 485.00 €“ 349.00 (C-CHECK RO 5/3/2021) INSTALLED NEW SEAT TRACK AT RBL9 BETWEEN FS349.00 TO FS485.00 REF CRJ-900 AMM 53-00-49-400-801-A07 / USED CALIBRATED TOOL TUC7825 CAL DUE DATE: 28-FSDR SWIA202158090Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK LBL27 BETWEEN FS 364.00 €“ 501.00 (C-CHECK RO 5/3/2021) INSTALLED NEW FLOOR SEAT TRACK P/N SH690--32127-3 LBL27 BETWEEN FS364.00-501 REF CRJ-900 AMM 53-00-49-400€”801-A07SDR SWIA202158089Doubler · corroded*CORROSION ON RH PRESSURE FLOOR SILL DOUBLER ON FS 797.00, BETWEEN RBL36 €“ RBL45 (C-CHECK RO 5/3/2021) REMOVED CORROSION FROM RH PRESSURE FLOOR DOUBLER AT FS797.00 BETWEEN RBL36-RBL45 IAW CRJ900 SRM 51-21-06-001-001-A01. EVALUATED AND FOUND IT TO BE OSDR SWIA202158088Doubler · corroded*CORROSION ON LH PRESSURE FLOOR SILL DOUBLER ON FS 797.00, BETWEEN LBL36 €“ LBL45 (C-CHECK RO 5/3/2021) REMOVED CORROSION ON LH PRESSURE FLOOR SILL DOUBLER ON FS797.00 BETWEEN LBL36 AND LBL45 IAW CRJ900 SRM 51-21-06-001-001-A01. EVALUATED AND FOUND TO SDR SWIA202158087Doubler · corroded*CORROSION ON RH PRESSURE FLOOR SILL DOUBLER ON FS 752.50, BETWEEN RBL36 €“ RBL45 (C-CHECK RO 5/3/2021) REMOVED CORROSION FROM RH PRESSURE FLOOR DOUBLER AT FS752.50 BETWEEN RBL36-RBL45 IAW CRJ900 SRM 51-21-06-001-001-A01. EVALUATED AND FOUND IT TO BE OSDR SWIA202158086Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK RBL9 BETWEEN FS 693.00 €“ 847.00 (C-CHECK RO 5/3/2021) INSTALLED NEW FLOOR SEAT TRACK P/N SH690-37387-1 RBL9 BETWEEN FS 693.00-847.00 REF CRJ-900 AMM 53-00-49-400€”801-A07SDR SWIA202158085Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK LBL9 BETWEEN FS 693.00 €“ 847.00 (C-CHECK RO 5/3/2021) INSTALLED NEW FLOOR SEAT TRACK P/N SH670-35864-3 LBL9 BETWEEN FS 693.00-847.00 REF CRJ-900 AMM 53-00-49-400€”801-A07SDR SWIA202158003Floorbeam · corrodedFS 280 COCKPIT FLOOR PANEL SUPPORT ANGLE CORRODED AS MARKED (C-CHECK RO 5/3/2021) REMOVED AND REPLACED FS280 FLOOR PANEL SUPPORT ANGLE IN REF DWG CC670-33052, REV G, CRJ900 SRM 51-42-06-001-001-A01 AND CRJ900 SRM 51-42-21-001-001-A01. SEE CONTINUATION CSDR SWIA202158002Door Frame · crackedR/H TRU BAY DOOR LANDING CRACKED AT AFT LATCH AREA. (C-CHECK RO 5/3/2021) CRACK VERIFIED, REMOVED AND INSTALLED NEW RH TRU BAY DOOR LANDING REF CRJ 900 SRM 51-42-06-001-001-A01 AND DWG CC670-33040 REV G. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITSDR SWIA202158001Skin · crackedSUSPECTED CRACK FOUND AT R/H TRU BAY DOOR OPENING, AFT CORNER ON FUSELAGE SKIN. (C-CHECK RO 5/3/2021) CRACK WAS CONFIRMED, REMOVED AND INSTALLED NEW RH LOWER FWD NOSE SKIN AND RH DOOR LANDING DOUBLER REF CRJ 900 SRM 51-42-06-001-001-A01, 51-42-21-001-SDR SWIA202158000Pressure Deck · corroded*MULTIPLE AREAS OF CORROSION ON RH PRESSURE FLOOR SILL PANEL. AREAS MARKED. (C-CHECK RO 5/3/2021) REPAIRED RH PRESSURE FLOOR SILL PANEL PER CRJ900 SRM 51-21-06-001-001-A01 & REO 690-53-41-254 REV --, DATED 2021/04/01. SEE CONTINUATION CARD FOR DETAILS.SDR SWIA202157999Pressure Deck · corroded*MULTIPLE AREAS OF CORROSION ON LH PRESSURE FLOOR SILL PANEL. AREAS MARKED. (C-CHECK RO 5/3/2021) REPAIRED LH PRESSURE FLOOR SILL PANEL PER CRJ900 SRM 51-21-06-001-001-A01 & REO 690-53-41-252 REV--, DATED 2021-03-31. SEE CONTINUATION CARD FOR DETAILS. SDR SWIA202157998Protector · corrodedSERVICE DOOR- FWD OF APPROX. FS349.00 WEB FLOOR PROTECTOR HAS CORROSION (C-CHECK RO 5/3/2021) REPLACED SERVICE DOOR SILL WEB FLOOR PROTECTOR AT APPROX. FS349.00 PER SRM 51-42-06-001-001-A01 & DRAWING SH670-31950 REV Y. SEE CONTINUATION CARD FOR DETAILSSDR SWIA202157997Protector · corrodedSERVICE DOOR- FWD OF APPROX. FS340.60 WEB FLOOR PROTECTOR HAS CORROSION (C-CHECK RO 5/3/2021) REPLACED SERVICE DOOR SILL WEB FLOOR PROTECTOR AT APPROX. FS340.60 PER SRM 51-42-06-001-001-A01 & DRAWING SH670-31950 REV Y. SEE CONTINUATION CARD FOR DETAILSSDR SWIA202157996Protector · corrodedSERVICE DOOR- AFT OF APPROX. FS328.10 WEB FLOOR PROTECTOR HAS CORROSION (C-CHECK RO 5/3/2021) REPLACED SERVICE DOOR WEB FLOOR PROTECTOR AT APPROX. FS328.10 PER SRM 51-42-06-001-001-A01 & DRAWING SH670-31950 REV Y. SEE CONTINUATION CARD FOR DETAILS. COMPSDR SWIA202157995Protector · corrodedSERVICE DOOR- AFT OF APPROX. FS319.00 WEB FLOOR PROTECTOR HAS CORROSION (C-CHECK RO 5/3/2021) REPLACED WEB FLOOR PROTECTOR AT APPROX. FS319.00 PER SRM 51-42-06-001-001-A01 & DRAWING SH670-31950 REV Y. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITH TASDR SWIA202157994Strap · corroded* SERVICE DOOR LOWER FWD SUPPORT STRAP AT CORRODED AT F.S.319.7 (MAARKED). (C-CHECK RO 5/3/2021) REPLACED SERVICE DOOR LOWER FWD SUPPORT STRAP AT FS319.7 REF CRJ900 SRM 51-42-21-001-001-A01 & DRAWING SH670-31950 REV Y. SEE CONTINUATION CARD FOR DETAILSSDR SWIA202157993Floor Support · corroded* FLOOR SILL FWD OF SERVICE DOOR CORRODED BEWEEN F.S.310.00 AND F.S.295.00 (MARKED). (C-CHECK RO 5/3/2021) REPLACED RH FLOOR SILL FROM FS280 TO FS319.7 REF DWG SH670-32170 REV. V, CRJ900 SRM 51-42-06-001-001-A01, CRJ900 SRM 51-42-21-001-001-A01, AND CRJSDR SWIA202157992Floor Support · corroded* FLOOR SILL AFT OF PAX DOOR CORRODED BETWEEN F.S.349.00 TO F.S.364.00 (MARKED). (C-CHECK RO 5/3/2021) REPLACED LH FLOOR SILL, FS349.00-FS364.00 PER SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, SRM 51-42-13-001-001-A01, DRAWING SH690-32170 REV AD, ANSDR SWIA202157991Doubler · crackedFWD EQUIP COMPARTMENT - DECK AND DOUBLER CRACKED UNDER ADG RETRACTION PUMP - AS MARKED (C-CHECK RO 5/3/2021) REMOVED DAMAGED SECTION AND INSTALLED NEW REPAIR PARTS ON FWD EQUIPMENT COMPARTMENT UNDER ADG RETRACTION PUMP REF CRJ900 SRM 53-11-43-201-001-A0SDR SWIA202158084Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK ON LBL9 BETWEEN FS 830.40 €“ 849.00 (C-CHECK RO 5/3/2021) REMOVED AND INSTALLED NEW SEAT TRACK ON LBL9 BETWEEN FS830.40 TO FS849.00 REF CRJ-900 AMM 53-00-49-400-801-A07 / USED CALIBRATED TOOL TUC7825 CALSDR SWIA202158083Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK ON RBL9 BETWEEN FS 830.40 €“ 849.00 (C-CHECK RO 5/3/2021) REMOVED AND INSTALLED NEW SEAT TRACK ON RBL9 BETWEEN FS830.40 TO FS849.00 REF CRJ-900 AMM 53-00-49-400-801-A07 / USED CALIBRATED TOOL TUC7825 CALSDR SWIA202158082Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK ON LBL9 BETWEEN FS 849.00 - 985.00 (C-CHECK RO 5/3/2021) REMOVED AND INSTALLED NEW SEAT TRACK REF CRJ-900 SRM 53-00-49-400-801-A07 / USED CALIBRATED TOOL TUC 5656 CAL DUE DATE: 31-MAY-21 ORDERED NEW HARDSDR SWIA202158081Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK RBL9 BETWEEN FS 849.00 - 985.00 (C-CHECK RO 5/3/2021) REMOVED AND REPLACED SEAT TRACK AT RBL 9 FROM FS849.00 - 985.00 IAW CRJ900 AMM 53-00-49-400-801-A07.SDR SWIA202157990Floor Support · corrodedSERVICE DOOR- DOOR FLOOR SILL HAS CORROSION AT FOOT PRINT OF LOWER ANGLE(GREASE PEN FOR LOCATION) (C-CHECK RO 5/3/2021) COMPLIED WITH TEMPORARY REPAIR TO SERVICE DOOR LOWER SILL BETWEEN FS310.00 & FS349.00 PER REO 690-53-21-1351 REV --, DATED 2021-04-26SDR SWIA202157989Angle · corrodedSERVICE DOOR- EVIDENCE OF CORROSION ON TOP MOUNTING ANGLE (C-CHECK RO 5/3/2021) REPLACED TOP MOUNTING ANGLE AT SERVICE DOOR SILL PER SRM 51-42-06-001-001-A01 & DRAWING SH670-31950 REV Y. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITH TASK CARD 51-90SDR SWIA202157988Floor Support · corroded*MULTIPLE AREAS OF CORROSION ON LH FLOOR SILL BETWEEN FS 927.00 €“ 1000.00. AREAS MARKED. (C-CHECK RO 5/3/2021) REPLACED LH FLOOR SILL BETWEEN FS985.00 TO FS1000.00 REF. CRJ900 SRM 51-42-06-001-001-A01 AND DWG MM67-35085 REV L C/W 51-900-1002-SKY COMPLSDR SWIA202157987Fitting · corrodedSERVICE DOOR- EVIDENCE OF CORROSION ON CLEAT (DOOR LOWER FITTING AFT OF FS333.00) (C-CHECK RO 5/3/2021) REPLACED SERVICE DOOR SILL CLEAT AFT OF FS333.00 PER SRM 51-42-06-001-001-A01 & DRAWING SH670-31950 REV Y. SEE CONTINUATION CARD FOR DETAILS. COMPLISDR SWIA202157986Fitting · corrodedSERVICE DOOR- EVIDENCE OF CORROSION ON CLEAT (DOOR LOWER FITTING FWD OF FS333.00) (C-CHECK RO 5/3/2021) REPLACED SERVICE DOOR SILL CLEAT FWD OF FS333.00 PER SRM 51-42-06-001-001-A01 & DRAWING SH670-31950 REV Y. SEE CONTINUATION CARD FOR DETAILS. COMPLISDR SWIA202157985Fitting · corrodedSERVICE DOOR- EVIDENCE OF CORROSION ON CLEAT (DOOR LOWER FITTING AFT OF FS310.00) (C-CHECK RO 5/3/2021) (FS CORRECTION: AFT OF FS319.70, NOT FS310.00). FOUND CORROSION ON SVC DR CLEAT AFT OF FS319.70 TO BE OUT OF LIMITS. REMOVED AND INSTALLED NEW CLEAT SDR SWIA202157984Striker · corrodedSERVICE DOOR- LOWER SEAL STRIKER HAS EVIDENCE OF CORROSION (C-CHECK RO 5/3/2021) REPLACED SERVICE DOOR LOWER SEAL STRIKER PER SRM 51-42-06-001-001-A01 & DRAWING SH670-31950 REV Y. SEE CONTINUATION CARD FOR DETAILS, COMPLIED WITH TASK CARD 51-900-1002-SSDR SWIA202157983Skin · bentRH H. STAB LOWER SKIN BENT AT I/B TRAILING EDGE (C-CHECK RO 5/3/2021) REPAIRED RH LOWER H. STAB TRAILING EDGE SKIN REF REO 690-55-11-140 REV -- DATED 2021-04-16. SEE CONTINUATION CARD FOR DETAILS. COMPLIED WITH 51-900-1002-SKY.SDR SWIA202157982Angle · corrodedGALLEY SERVICE DOOR LOWER SILL, INBOARD ANGLE HAS EVIDENCE OF CORROSION. (C-CHECK RO 5/3/2021) REMOVED AND REPLACED GALLEY SERVICE DOOR LOWER SILL REF CRJ900 SRM 51-42-06-001-001-A01 AND DWG SH670-31950 REV Y / COMPLIED WITH 51-900-1002 SKY (CL600-2D24)SDR SWIA202157981Door Frame · corrodedMAIN AVIONICS COMPARTMENT DOOR SURROUND STRUCTURE LANDING FROM FS 364.00 TO FS 394.00 BETWEEN STRINGER 25L AND STRINGER 25R HAS EVIDENCE OF CORROSION. (C-CHECK RO 5/3/2021) REMOVED CORROSION FROM MAIN AVIONICS COMPARTMENT DOOR SURROUND STRUCTURE LANDINGSDR SWIA202157980Door Sill · corrodedAFT CARGO DOOR LOWER SILL IS CORRODED. (C-CHECK RO 5/3/2021) REPLACED AFT CARGO DOOR LOWER SILL REF DWG MM670-35065 REV. L CRJ900 SRM 51-42-06-001-001-A01 CRJ900 SRM 51-42-13-001-001-A01 CRJ900 SRM 51-42-21-001-001-A01. LEAK CHECK GOOD. COMPLIED WITH 51SDR SWIA202157979Hinge · gougedPAX DOOR HINGE ON THE DOOR SIDE HAS GOUGE FROM SAFETY PIN ON AFT LUG (C-CHECK RO 5/3/2021) FOUND GOUGE ON PAX DR HINGE TO BE BEYOND ALLOWABLE LIMITS, REMOVED AND INSTALLED NEW PAX DR HINGE REF CRJ 900 SRM 52-11-01-201-002-A01. LEAK CEHCK GOOD. COMPLIESDR SWIA202157978Door Frame · corroded*PAX DOOR LANDINGS FOR PANEL 832AB HAVE AREAS OF CORROSION (C-CHECK RO 5/3/2021) REMOVED AND REPLACED PAX DOOR UPPER SEAL RETAINER P/N601R318087-3, BRACKET P/N 601R31902-555, BRACKET P/N 601R31902-556, BRACKET P/N 601R31902-147 AND BRACKET P/N 601R31902
Back to N803SK