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 SWIA202158038Intercostal · corrodedPAX DOOR FWD DD2 INTERCOSTAL IS CORRODED (C-CHECK RO 5/3/2021) REPLACED PAX DOOR FWD DD2 INTERCOSTAL REF CRJ900 SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV. N. LEAK CHECK GOOD. COMPLIED WITH 51-900-1002-SKY.SDR SWIA202158037Stringer · corrodedMAIN AVIONICS BAY STR 23R HAS SEVERAL AREAS OF CORROSION BETWEEN FS333.00 AND FS364.00 (C-CHECK RO 5/3/2021) REPLACED STRINGER 23R, FS333.00-379.00 PER SRM 51-42-06-001-001-A01 & DRAWING SH690-31350 REV M. SEE CONTINUATION CARD FOR DETAILS. CHECKS GOOSDR SWIA202158036Stringer · corrodedMAIN AVIONICS BAY STR 24R HAS SEVERAL AREAS OF CORROSION BETWEEN FS333.00 AND FS349.00 (C-CHECK RO 5/3/2021) REPLACED STRINGER 24R, FS333.00-385.00 PER CRJ900 SRM 51-42-06-001-001-A01, CRJ900 SRM 53-00-03-201-001-A02 & DRAWING SH690-31350 REV M. SEE COSDR SWIA202158119Seat Track · corrodedMULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK LBL27 BETWEEN FS 485.00 €“ FS 581.00 (C-CHECK RO 5/3/2021) INSTALLED NEW SEAT TRACK AT LBL27 BETWEEN FS485.00 TO FS581.00 REF CRJ-900 AMM 53-00-49-400-81-A07 / USED CALIBRATED TOOL TUC7825 CAL DUE DATE: 2SDR SWIA202158118Seat Track · corrodedMULTIPLE AREAS OF CORROSION ON FLOOR SEAT TRACK LBL9 BETWEEN FS 485.00 €“ FS 581.00 (C-CHECK RO 5/3/2021) INSTALLED NEW SEAT TRACK AT LBL9 BETWEEN FS485.00 TO FS581.00 REF CRJ-900 AMM 53-00-49-400-801-A07 / USED CALIBRATED TOOL TUC7825 CAL DUE DATE: 28SDR SWIA202158035Stringer · corrodedMAIN AVIONICS BAY STR 27 FROM FS333.00 TO FS352.00 HAS MULTIPLE SPOTS OF CORROSION (C-CHECK RO 5/3/2021) REPLACED STRINGER 27, FS333.00-352.00 PER CRJ900 SRM 51-42-06-001-001-A01 & DRAWING SH690-31350 REV M. SEE CONTINUATION CARD FOR DETAILS. CHECKS GSDR SWIA202158034Stringer · corrodedMAIN AVIONICS BAY STR 27 FROM FS308.00 TO FS333.00 HAS MULTIPLE SPOTS OF CORROSION (C-CHECK RO 5/3/2021) REPLACED STRINGER 27, FS308.00-333.00 PER SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 & DRAWING SH670-31630 REV K. SEE CONTINUATION CARD FORSDR SWIA202158033Intercostal · corrodedPAX DOOR AFT DD5 INTERCOSTAL IS CORRODED (C-CHECK RO 5/3/2021) REPLACED PAX DOOR AFT DD5 INTERCOSTAL AND CLEAT PER DRAWING 601R31702 REV & SRM 51-42-06-001-001-A01. SEE CONTINUATION CARD FOR DETAILS. CHECKS GOOD. COMPLIED WITH TASK CARD 51-900-1002-SDR SWIA202158032Intercostal · corrodedPAX DOOR AFT DD4 INTERCOSTAL IS CORRODED (C-CHECK RO 5/3/2021) REPLACED PAX DOOR AFT DD4 INTERCOSTAL AND CLEATE REF CRJ900 SRM 51-42-06-001-001-A01 AND BOMBARDIER DWG 601R31702 REV.N. SEE CONTINUATION CARD FOR DETAILS. CHECKS GOOD.SDR SWIA202158031Intercostal · corrodedPAX DOOR FWD DD4 INTERCOSTAL IS CORRODED (C-CHECK RO 5/3/2021) REPLACED PAX DOOR FWD DD4 INTERCOSTAL REF CRJ900 SRM 51-42-06-001-001-A01 & DRAWING 601R31702 REV N. SEE CONTINUATION CARD FOR DETAILS. CHECKS GOOD. COMPLIED WITH TASK CARD 51-900-1002-SKYSDR SWIA202158030Intercostal · corrodedPAX DOOR FWD DD5 INTERCOSTAL IS CORRODED (C-CHECK RO 5/3/2021) REPLACED PAX DOOR FWD DD5 INTERCOSTAL AND BRACKET PER SRM 51-42-06-001-001-A01 & DRAWING 601R31702 REV N. SEE CONTINUATION CARD FOR DETAIS. CHECKS GOOD. COMPLIED WITH TASK CARD 51-900-100SDR SWIA202158029Intercostal · corrodedPAX DOOR MID DD4 INTERCOSTAL IS CORRODED (C-CHECK RO 5/3/2021) REPLACED PAX DOOR MID DD4 INTERCOSTAL REF CRJ900 SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 & DRAWING 601R31702 REV N. SEE CONTINUATION CARD FOR DETAIL. CHECKS GOOD. COMPLIED WITHSDR SWIA202158028Intercostal · corrodedPAX DOOR MID DD3 INTERCOSTAL IS CORRODED (C-CHECK RO 5/3/2021) REPLACED PAX DOOR MID DD3 INTERCOSTAL REF CRJ900 SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV. N CRJ900 SRM 51-42-21-001-001-A01. CHECKS GOOD. COMPLIED WITH 51-900-1002-SKY.SDR SWIA202158027Intercostal · corrodedPAX DOOR MID DD2 INTERCOSTAL IS CORRODED (C-CHECK RO 5/3/2021) REPLACED PAX DOOR MID DD2 INTERCOSTAL REF CRJ900 SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 & DRAWING 601R31702 REV N. SEE CONTINUATION CARD FOR DETAILS. CHECKS GOOD. COMPLIED WITSDR SWIA202158026Intercostal · corrodedPAX DOOR MID DD1A INTERCOSTAL IS CORRODED (C-CHECK RO 5/3/2021) REPLACED PAX DOOR MID DD1A INTERCOSTAL REF CRJ900 SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 & DRAWING 601R31702 REV N. SEE CONTINUATION CARD FOR DETAILS. CHECKS GOOD. COMPLIED WSDR SWIA202158025Door Frame · corrodedPAX DOOR FRAME F/S 320.00 IS CORRODED (C-CHECK RO 5/3/2021) REPLACED PAX DOOR FRAME F/S 320.00 AND CLIP REF CRJ 900 SRM 51-42-06-001-001-A01 AND CRJ 900 SRM 51-42-21-001-001-A01 AND BOMBARDIER DWG 601R31702 REV. N. SEE CONTINUATION CARD FOR DETAIL. CHSDR SWIA202158024Former · corrodedPAX DOOR FORMER F/S 320.163 IS CORRODED (C-CHECK RO 5/3/2021) REPLACED PAX DOOR FORMER FS320.163 REF CRJ900 SRM 51-42-06-001-001-A01, AND CRJ900 SRM 51-42-21-001-001-A01, AND DWG 601R31702 REV. N. LEAK CHECK GOOD COMPLIED WITH 51-900-1002-SKY.SDR SWIA202158023Coaming · corroded* COROSSION FOUND AROUND THE LH UPPER CORNER OF THE INTERNAL SURROUND STRUCTURE OF THE AFT BAGGAGE-BAY DOOR CUT-OUT ( AREA MARKED). (C-CHECK RO 5/3/2021) REMOVED AND INSTALLED NEW AFT CARGO DOOR SURROUND UPPER COAMING REF CRJ 900 SRM 51-41-02-001-001-ASDR SWIA202158022Former · corrodedPAX DOOR AFT FORMER F/S 347.27 IS CORRODED (C-CHECK RO 5/3/2021) REPLACED PAX DOOR AFT FORMER AT FS347.27 PER DRAWING 601R31702 REV N & SRM 51-42-06-001-001-A01. SEE CONTINUATION CARD FOR DETAILS. CHECKS GOOD. COMPLIED WITH TASK CARD 51-900-1002-SKYSDR SWIA202158117Access Panel · corrodedPAX DOOR AFT WEB HAS CORROSION COMMON TO RECEPTACLES FOR ACCESS PANELS AND STEP ATTACH FLANGES AROUND NUTPLATES (C-CHECK RO 5/3/2021) REMOVED AND REPLACED CORRODED PAX DOOR AFT WEB PANEL REF. CRJ900 SRM 51-42-06-001-001-A01.SDR SWIA202158021Stringer · corrodedMAIN AVIONICS BAY STR 21R CORRODED BETWEEN FS364.00 AND FS379.00 (C-CHECK RO 5/3/2021) REPLACED STRINGER 21R, FS333.00-379.00 PER SRM 51-42-06-001-001-A01 & DRAWING SH690-31350 REV M. SEE CONTINUATION CARD FOR DETAILS, CHECKS GOOD. COMPLIED WITH TASK CSDR SWIA202158020Frame · corrodedMAIN AVIONICS BAY FS364.00 FRAME CORRODED BETWEEN STR 26R AND STR 25R (C-CHECK RO 5/3/2021) REPLACED FRAME AT FS364.00, STRINGER 24L-24R PER SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, SRM 53-21-23-201-008-A01 & DRAWING SH670-32050 REV J. SEE CSDR SWIA202158019Intercostal · corrodedMAIN AVIONICS BAY RH LATCH-PIN INTERCOSTAL FROM FS349.00 TO FS364.00 CORRODED (C-CHECK RO 5/3/2021) REPLACED MAIN AVIONICS BAY RH LATCH-PIN INTERCOSTAL FROM FS349.00 TO FS364.00 REF CRJ900 SRM 51-42-06-001-001-A01, CRJ900 SRM 51-42-21-001-001-A01, AND DSDR SWIA202158018Intercostal · corrodedMAIN AVIONICS BAY LH LATCH-PIN INTERCOSTAL FROM FS349.00 TO FS364.00 CORRODED (C-CHECK RO 5/3/2021) REPLACED MAIN AVIONICS BAY LH LATCH-PIN INTERCOSTAL FROM FS349.00 TO FS364.00 REF CRJ900 SRM 51-42-06-001-001-A01, CRJ900 SRM 51-42-21-001-001-A01, AND DSDR SWIA202158017Stringer · corrodedMAIN AVIONICS BAY STR 26L FROM FS333.00 TO FS364.00 CORRODED IN SEVERAL AREAS (C-CHECK RO 5/3/2021) REPLACED STRINGER 26L, FS333.00-364.00 PER CRJ900 SRM 51-42-06-001-001-A01 & DRAWING SH690-31350 REV M. SEE CONTINUATION CARD FOR DETAILS. CHECKS GOOD.SDR SWIA202158016Stringer · corrodedMAIN AVIONICS BAY STR 26R FROM FS280.00 TO FS333.00 CORRODED IN SEVERAL AREAS (C-CHECK RO 5/3/2021) REPLACED STRINGER 26R FROM FS280.00-333.00 REF CRJ900 SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 & DRAWING SH670-31630 REV K. SEE CONTINUATION CSDR SWIA202158015Stringer · corrodedMAIN AVIONICS BAY STR 26L FROM FS280.00 TO FS333.00 CORRODED IN SEVERAL AREAS (C-CHECK RO 5/3/2021) REPLACED STRINGER 26L, FS280.00-333.00 PER CRJ 900 SRM 51-42-06-001-001-A01, CRJ 900 SRM 51-42-21-001-001-A01 & DRAWING SH670-31630 REV K. SEE CONTINUATSDR SWIA202158014Stringer · corrodedMAIN AVIONICS BAY STR 25L FROM FS280.00 TO FS333.00 CORRODED IN SEVERAL AREAS (C-CHECK RO 5/3/2021) REPLACED STRINGER 25L, FS280.00-333 PER SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 & DRAWING SH670-31630 REV K. SEE CONTINUATION CARD FOR DETAILSSDR SWIA202158013Frame · corrodedMAIN AVIONICS BAY FS319.70 FRAME FROM STR 18L TO STR 21L CORRODED (C-CHECK RO 5/3/2021) REPLACED FRAME AT FS319.00, STRINGER 18L - 21L PER SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 & DRAWING SH670-31810 REV AE. SEE CONTINUATION CARD FOR DETAILSDR SWIA202158012Support · corrodedMAIN AVIONICS BAY STR 21L BACK-UP SILL FROM FS333.00 TO FS349.00 CORRODED (C-CHECK RO 5/3/2021) REPLACED MAIN AVIONICS BAY STR 21L BACK-UP SILL FROM FS333.00 TO FS349.00 REF DWG SH670-31810 REV. AE AND CRJ900 SRM 51-42-06-001-001-A01. COMPLIED WITH 51-9SDR SWIA202158011Support · corrodedMAIN AVIONICS BAY STR 21L BACK-UP SILL FROM FS310.00 TO FS333.00 CORRODED (C-CHECK RO 5/3/2021) REPLACED STRINGER 21L BACKUP SILL PER SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 & DRAWING SH670-31810 REV AE. SEE CONTINUATION CARD FOR DETAILS. CSDR SWIA202158010Skin · nicked*FS 1015-1045 BETWEEN STR 27- 24R SEVERAL NICKS AND SCRATCHES (C-CHECK RO 5/3/2021) REPAIRED EXTERNAL SKIN FS1015.00-1045.00, STRINGER 27-24R PER SRM 51-12-00-001-001-A01 & REO 690-53-61-993 REV --, DATED 2021-04-06. SEE CONTINUATION CARD FOR DETAILS. SDR SWIA202158009Stringer · corroded* STR.19R CORRODED IN MULTIPLE SPOTS BETWEEN F.S.565.00 AND F.S.581.00 (MARKED). (C-CHECK RO 5/3/2021) REPAIRED STR 19R BETWEEN FS565-581 WITH 2EA NEW SPLICES REF CRJ900 SRM 53-00-03-201-001-A02. CHECKS GOOD. COMPLIED WITH 51-900-1002-SKY.SDR SWIA202158008Stringer · corrodedFS 469/485 - STGR 19R - STRINGER JOINT CORRODED AS MARKED (C-CHECK RO 5/3/2021) REMOVED AND INSTALLED NEW STR 19R STRINGER JOINT BETWEEN FS469-485 REF CRJ 900 SRM 51-42-06-001-001-A01 AND DWG SH670-30006 REV A. COMPLIED WITH 51-900-1002-SKY.SDR SWIA202158007Intercostal · crackedNOSE HYDRAULICS COMPARTMENT - CEILING - SUSPECTED CRACK IN INTERCOSTAL APROX FS185 LBL21 - AS MARKED (C-CHECK RO 5/3/2021) REPLACED NOSE HYDRAULICS COMPARTMENT CEILING INTERCOSTAL APPROX. FS185 LBL 21 REF DWG CC670-33045 REV. E, AND CRJ900 SRM 51-42-06-SDR SWIA202158006Intercostal · corrodedFS 349/364 - STGR 20R INTERCOSTAL CORRODED AS MARKEDREMOVED AND REPLACED STR 20R INTERCOSTAL BETWEEN FS349.00 AND FS364.00 REF. DRWG SH670-31950 REV. Y, CRJ 900 SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01. COMPLIED WITH 51-900-1002-SKYSDR SWIA202158005Stringer · corrodedFS 364/379 - STGR 20R - STRINGER CORRODED AS MARKED (C-CHECK RO 5/3/2021) REPLACED STRINGER 20R AND INSTALL NEW STRINGER SPLICE FS386 20R PER SRM 53-00-03-201-001-A02, SRM 51-42-06-001-001-A01 & REO 690-53-21-1349 REV --, DATED 2021-04-06. SEE CONTINUASDR SWIA202158004Stringer · corrodedFS 319/333 - STGR 20L - STGR CORRODED UNDER CANNON PLUG BRACKET - AS MARKED (C-CHECK RO 5/3/2021) REPLACED STRINGER 20L, FS310.00-349.00 PER SRM 51-42-06-001-001-A01 & DRAWING SH670-31810 REV AE. SEE CONTINUATION CARD FOR DETAILS. CHECKS GOOD. COMPLIESDR SWIA202158116Floorbeam · corrodedA-BAY FLOOR SUPPORT ANGLE ON AFT SIDE OF FS280 CORRODED AS MARKED (C-CHECK RO 5/3/2021) REMOVED AND REPLACED CORRODED A BAY FLOOR SUPPORT ANGLE REF. CRJ900 SRM 51-42-06-001-001-A01, CRJ900 SRM 51-42-13-001-001-A01 AND CRJ900 SRM 51-42-21-001-001-A01.SDR SWIA202158115Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON RH SIDE SEAT TRACK BETWEEN FS 720.00 €“ 683.00 (C-CHECK RO 5/3/2021) REMOVED AND REPLACED RH SIDE SEAT TRACK FROM APPROX. FS 720.00 €“ FS683. REF: CRJ-900 AMM 53-00-49-000-801-A07 AND CRJ-900 AMM 53-00-49-400-801-A07. SDR SWIA202158114Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON RH SIDE SEAT TRACK BETWEEN FS 744.00 €“ 752.00 (C-CHECK RO 5/3/2021) INSTALLED NEW SEAT RAIL ON R/H WALL BETWEEN FS744.00- FS752.00 REF CRJ-900 AMM 53-00-49-400-801-A07 / USED CALIBRATED TOOL TUC5825 CAL DUE DATE: 31-MASDR SWIA202158113Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON RH SIDE SEAT TRACK BETWEEN FS 785.00 €“ 847.00+16 (C-CHECK RO 5/3/2021) REMOVED AND REPLACED R/H SIDE SEAT TRACK BETWEEN FS785.00 - 847-00+16 REF. CRJ-900 AMM 53-00-49-000-801-A07 AND AMM 53-00-49-400-801-A01. SEE CONTINSDR SWIA202158112Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON RH SIDE SEAT TRACK BETWEEN FS 881.00 €“ 847.00+16 (C-CHECK RO 5/3/2021) COMPLIED WITH REMOVAL OF CORROSION FROM RH SIDE SEAT RAILS AT APPROX. FS847.00+16 €“ FS881.00, CORROSION DETERMINED TO BE OUT OF LIMITS, SEAT RAILSSDR SWIA202158111Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON LH SIDE SEAT TRACK BETWEEN FS 913.00 €“ 847.00+16 (C-CHECK RO 5/3/2021) REPLACED LH SIDE SEAT TRACK BETWEEN FS913.00 TO FS847.00+16 REF CRJ900 AMM 53-00-49-400-801-A07.SDR SWIA202158110Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON LH SIDE SEAT TRACK BETWEEN FS 785.00 €“ 847.00+16 (C-CHECK RO 5/3/2021) CORROSION FOUND TO BE OUT OF LIMITS. REF: CRJ900 SRM 53-41-49-101-001-A01. REMOVED AND INSTALLED NEW LH SIDE SEAT TRACK BETWEEN FS 785.00 €“ SDR SWIA202158109Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON LH SIDE SEAT TRACK BETWEEN FS 744.00 €“ 752.00 (C-CHECK RO 5/3/2021) INSTALLED NEW SEAT RAIL ON L/H SIDE WALL BETWEEN FS744.00 TO FS752.00 REF CRJ-900 AMM 53-00-49-400-801-A07 / USED CALIBRATED TOOL 7825 CAL DUE DATE: 28SDR SWIA202158108Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON LH SIDE SEAT TRACK BETWEEN FS 683.00 €“ 720.00 (C-CHECK RO 5/3/2021) INSTALLED REPLACEMENT L/H SEAT TRACK BETWEEN FS 683.00 - FS 720.00 REF CRJ-900 AMM 53-00-49-400-801-A07SDR SWIA202158107Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON RH SIDE SEAT TRACK BETWEEN FS 469.00 €“ 364.00 (C-CHECK RO 5/3/2021) REPLACED RH SIDE SEAT TRACK BETWEEN FS364-469 REF CRJ900 AMM 53-00-49-400-801-A07.SDR SWIA202158106Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON RH SIDE SEAT TRACK BETWEEN FS 469.00 €“ 480.00 (C-CHECK RO 5/3/2021) CORROSION ON SEAT TRACK FOUND TO BE OUT OF LIMITS. REF CRJ900 SRM 53-21-49-101-001-A01. REMOVED AND INSTALLED NEW TRACK. REF: CRJ900 AMM 53-00-4SDR SWIA202158105Seat Track · corroded*MULTIPLE AREAS OF CORROSION ON RH SIDE SEAT TRACK BETWEEN FS 570.00 €“ 480.00 (C-CHECK RO 5/3/2021) REMOVED AND REPLACED DAMAGED SEAT RAIL SECTION FROM FS477 TO FS581. REF: CRJ-900 AMM 53-00-49-000-801-A07 AND CRJ-900 AMM 53-00-49-400-801-A07. SEE CON
Back to N803SK