N738SK
Service difficulty reports · 160
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 = 'N738SK' 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 = 'N738SK' 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 SWI2023F00281Unknown · corrodedMAIN AVIONICS BAY STR 26L CORRODED BETWEEN FS280.00 AND FS319.70 (C-CHECK RO 8/31/2023) REMOVED AND INSTALLED NEW STR 26L FROM FS280.00 TO FS333.00 REF. DRWG SH670-31630 REV. K, CRJ 700 SRM 51-42-06-001-001-A01 AND CRJ 700 SRM 51-42-21-001-001-A01. PERSDR SWI2023F00280Unknown · corrodedMAIN AVIONICS BAY FS310.00 FRAME CORRODED BETWEEN STR 27 AND STR 26R (C-CHECK RO 8/31/2023) REMOVED AND INSTALLED FS310.00 FRAME SECTION FROM STR 23L TO STR 25R REF. CRJ 700 SRM 51-42-21-001-001-A01 AND CRJ 700 SRM 53-00-06-201-006-A01. INSTALLED FS310.SDR SWI2023F00279Unknown · crackedLH COCKPIT FLOOR BEAM CRACKED AT FS280.00 (C-CHECK RO 8/31/2023) REPAIRED CRACKED FLIGHT DECK FLOOR BEAM AT LBL12.0, FS 280 IAW CRJ700 SRM 53-11-43-201-003-A01, SEE CONTINUATION FOR WORK ACCOMPLISHEDSDR SWI2023F00278Unknown · corrodedMAIN AVIONICS BAY STR 21L BACK-UP SILL BETWEEN FS310.00 AND FS333.00 CORRODED (C-CHECK RO 8/31/2023) REMOVED AND REPLACED MAIN AVIONICS BAY STR 21L BACK-UP SILL BETWEEN FS310.00 AND FS333.00 REF. DRWG SH670-31810 REV. AE AND CRJ 700 SRM 51-42-06-001-001SDR SWI2023F00277Unknown · corrodedMAIN AVIONICS BAY TCAS ANTENNA DOUBLER CORRODED (C-CHECK RO 8/31/2023) REMOVED MAIN AVIONICS BAY TCAS ANTENNA DOUBLER REF. CRJ 700 SRM 51-42-06-001-001-A01 AND CRJ 700 SRM 51-42-21-001-001-A01. INSTALLED NEW MAIN AVIONICS BAY TCAS ANTENNA DOUBLER REF. CSDR SWI2023F00276Unknown · corrodedMAIN AVIONICS BAY FS295.00 FRAME CORRODED BETWEEN STR 26L AND STR 26R (C-CHECK RO 8/31/2023) REMOVED AND REPLACED FS295.00 FRAME SECTION FROM STR 25L TO STR 25R REF. CRJ 700 SRM 53-00-06-201-006-A01 AND CRJ 700 SRM 51-42-21-001-001-A01. COMPLIED WITH 51SDR SWI2023F00275Unknown · corrodedMAIN AVIONICS BAY STR 26L ATTACH ANGLE CORRODED AT ~FS364.00 (C-CHECK RO 8/31/2023) REMOVED AND REPLACED MAIN AVIONICS BAY STR 26L ATTACH ANGLE FROM FS349.00 TO FS364.00 REF. DRWG SH670-32050 REV. J AND CRJ 700 SRM 51-42-06-001-001-A01. COMPLIED WITH 51SDR SWI2023F00274Unknown · corrodedMAIN AVIONICS BAY STR 25R LONGERON CORRODED BETWEEN FS333.00 AND FS349.00 (C-CHECK RO 8/31/2023) REMOVED AND INSTALLED MAIN AVIONICS BAY STR 25R LONGERON FROM FS333.00 TO FS364.00 REF. DRWG SH670-32050 REV. J, CRJ 700 SRM 51-42-06-001-001-A01 AND CRJ 70SDR SWI2023F00273Unknown · corrodedMAIN AVIONICS BAY STR26R CORRODED BETWEEN FS333.00 AND FS364.00 (C-CHECK RO 8/31/2023) REMOVED AND INSTALLED MAIN AVIONICS BAY STR 26R FROM FS333.00 TO FS364.00 REF. DRWG SH690-31350 REV. M AND CRJ 700 SRM 51-42-06-001-001-A01.PERFORMED PRESSURE CHECK TSDR SWI2023F00272Unknown · unknownCOCKPIT FLOOR SUPPORT AT FS280.00 CORRODED (C-CHECK RO 8/31/2023) INSTALLED NEW COCKPIT FLOOR SUPPORT AT FS280. REF: CRJ-700 SRM 51-42-06-001-001-A01,CRJ-700 SRM 51-42-21-001-001-A01 AND DWG. CC670-34010 REV -K. SEE CONTINUE CARD FOR DETAILS OF WORK PERSDR SWI2023F00271Unknown · crackedRH COCKPIT FLOOR BEAM CRACKED AT FS280.00 (C-CHECK RO 8/31/2023) COMPLIED WITH RBL 12 COCKPIT FLOOR BEAM BETWEEN REPAIR FS 265 - FS 280 REF CRJ700 SRM 53-11-43-201-003-A01 TYPE IV REPAIR. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKYSDR SWI2023F00270Unknown · corrodedMAIN AVIONICS BAY FS333.00 FRAME CORRODED BETWEEN STR 25L AND STR 26R (C-CHECK RO 8/31/2023) REMOVED AND INSTALLED NEW FS333.00 FRAME FROM STR 21L TO STR 20R REF. DRWG SH670-32420 REV. E AND CRJ 700 SRM 51-42-06-001-001-A01 AND CRJ 700 SRM 53-00-06-201-SDR SWI2023F00269Unknown · corrodedMAIN AVIONICS BAY LH LATCH-PIN INTERCOSTAL CORRODED (C-CHECK RO 8/31/2023) REMOVED AND REPLACED MAIN AVIONICS BAY LH LATCH-PIN INTERCOSTAL REF. DRWG SH670-32050 REV. J AND CRJ 700 SRM 51-42-06-001-001-A01. COMPLIED WITH TASK CARD 51-900-1002-SKY. PRESSUSDR SWIA20230615Unknown · corrodedMAIN AVIONICS BAY FS349.00 FRAME CORRODED BETWEEN STR 26L AND STR 25R (C-CHECK RO 8/31/2023) REMOVED AND INSTALLED NEW FS349.00 FRAME FROM STR 23L TO STR 24R REF. DRWG SH690-31350 REV. M AND CRJ 700 SRM 51-42-06-001-001-A01. PERFORMED PRESSURE CHECK THSDR SWIA202309010614Unknown · gougedPAX DOOR PIANO HINGE FUSELAGE SIDE HAS GOUGE IN AFT LUG LAND THAT WAS PREVIOUSLY BLENDED IAW GREO 670-53-21-582 REV-F DATED 2017-08-02 (C-CHECK RO 8/31/2023) REMOVED AND REPLACED PAX DOOR HINGE ON FUSELAGE SIDE. REF. CRJ700 SRM 53-21-23-201-007-A01 AND SDR SWI2023F00268Unknown · gougedAFT CARGO DOOR SURROUND EXTERNAL EDGE SKIN GOUGES ALONG FORWARD AND AFT SIDES (MARKED) (C-CHECK RO 8/31/2023) : REMOVED DAMAGE ON AFT CARGO DOOR CUT-OUT (EXTERNAL SKIN FWD AND AFT) REF REO 670-53-61-2130 REV. -- DATED 2023-06-22. OPS CHECK GOOD. COMPLISDR SWIA20230610Unknown · unknownCREW ESCAPE HATCH BOTH HINGE ARMS ARE WORN IN HINGE RADIUS AREA (MARKED) (C-CHECK RO 8/31/2023) BLENDED -OUT WORN IN HINGE RADIUS AREA ON CREW ESCAPE HATCH BOTH HINGE ARMS REF CRJ700 SRM 51-12-00-001-001-A01. COMPLIED WITH TASK CARD 51-900-1002-SKY, ANDSDR SWIA20230609Unknown · gougedGALLEY SERVICE DOOR EXTERNAL EDGE SKIN GOUGES LOWER AFT CORNER (MARKED) (C-CHECK RO 8/31/2023) BLENDED OUT CHAFE ON GALLEY SERVICE DOOR EXTERNAL HANDLE, UPPER FWD SIDE. REF CRJ 700 SRM 51-12-00-001-001-A01. COMPLIED WITH REO 670-52-41-099 REV -- DATED SDR SWIA202265278Unknown · odorFA REPORTS BURNING SMELL COMING FROM EXIT ROW AREA. (FLIGHT 3187 - FILED CLOSED) CONFIRMED WITH CREW THAT THERE WAS NO VISIBLE SMOKE. NO BURNING SMELL EVIDENT AFTER PASSENGERS DISEMBARKED FROM AIRCRAFT. IAW CRJ SL 21-028 PERFOREMED INSPECTIONS AND CHECKS OSDR SWIA202156475Stringer · chafedR/H PACK WATER INJECTION LINE TO RAM AIR DUCT DEFUSER FOR HEAT EXCHANGER CHAFFING INTO FUSELAGE STRINGERS 7RH AND SKIN ABOVE 7RH (APPOXIMATELY), BETWEEN FS1144.00 AND FS1162.00. FILED CLOSED ACCOMPLISHED REPAIR TO RH SKIN AND STR 7R BETWEEN FS 1144.00SDR SWIA202156474Stringer · chafedL/H PACK WATER INJECTION LINE TO RAM AIR DUCT DEFUSER FOR HEAT EXCHANGER CHAFFING INTO FUSELAGE STRINGERS 6LH AND 7LH, BETWEEN FS1144.00 AND FS1162.00. FILED CLOSED COMPLIED WITH THE REPAIR TO STR6L AND STR7L BETWEEN FS1144.00-FS1162.00 IAW BOMBARDIER RSDR SWIA2020072751476Acm · seizedON DEPARTURE WITH ENGINE BLEEDS ON, FIVE MINUTES AFTER DEPARTURE SMOKE IN CABIN WITH VERY STRONG ODOR. ONLY STRONG ODOR IN FLIGHT DECK DECLARED, EMERGENCY RETURNED TO FIELD. ON TAXI R PACK AUTOFAIL CAUTION MESSAGE. RIGHT PACK AT 99 DEGREE. FLIGHT 3198 . TROUSDR SWIA201904195771Reservoir · failedAFTER TAKEOFF, HYD 2 HI TEMP CAUTION MESSAGE. RAN QRH. TEMPERATURE DECREASED BELOW THE 96 DEGREES. UPON LANDING, HYD 2 PRESSURE WOULD NOT GO ABOVE 1900 PSI AND REMAINED IN THE YELLOW WITH HYD 2B SET TO AUTO AND FLAPS EXTENDED. TRIED ON FOR 2B WITH SAME OUTCOSDR SWIA2018041044522Support · corrodedCORRODED BODY FAIRING 196AR SUPPORT STRUCTURE AT BS 909, FROM RT SIDE UNDER WL 72 TO THE LT SIDE LOWER CORNER. REPLACED THE SUPPORT IAW SRM.SDR SWIA2018041044521Bulkhead Web · corrodedBS 280 LOWER BULKHEAD WEB CORRODED. REPLACED THE LOWER BULKHEAD WEB IAW SRM.SDR SWIA2018041044520Frame · corrodedCORROSION FOUND ON LOWER FLANGE AND FRAME WEB BS 1000 BETWEEN STRINGERS 2L AND 27L. CUT AWAY THE DAMAGE AND INSTALLED A REPAIR IAW REO.SDR SWIA2018041044519Floorbeam · corrodedRIGHT FLOORBEAM IS CORRODED AT BS 280. ACCOMPLISHED A REPAIR ON THE FLOORBEAM IAW SRM.SDR SWIA201844518Bulkhead Web · corrodedBS 280 LOWER BULKHEAD WEB CORRODED. REMOVED AND REPLACED BULKHEAD WEB IAW SRM.SDR SWIA2018041044517Intercostal · corrodedPAX DOOR INTERCOSTAL, HAS CORROSION. REMOVED AND REPLACED THE INTERCOSTAL IAW SRM.SDR SWIA2018041044516Door Sill · corrodedGALLEY SERVICE DOOR SILL SURROUND STRUCTURE BS 349 LOWER SILL HAS CORROSION. BLENDED THE CORROSION THE DOOR SILL IAW SRM.SDR SWIA2018041044515Intercostal · corrodedGALLEY SERVICE DOOR SURROUND STRUCTURE BS 319, STRINGER 20R CORRODED. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM.SDR SWIA2018041044514Floorbeam · corrodedBS 280 BEAMBEAM CORRODED AT LBL 8 AND RBL 8. REMOVED AND REPLACED FLOORBEAM IAW SRM.SDR SWIA2018041044513Floorbeam · corrodedBS 280 FLOORBEAM ANGLE CORRODED. REPLACED THE FLOORBEAM ANGLE IAW SRM.SDR SWIA2018041044512Floorbeam · corrodedBS 280 FLOORBEAM ANGLE CORRODED. REMOVED AND REPLACED FLOORBEAM ANGLE IAW SRM.SDR SWIA2018041044511Rib · chafedRIGHT AILERON INBD RIB CHAFED. REMOVED AND REPLACED THE RIB IAW SRM.SDR SWIA2018041044510Skin · gougedBS 977, STRINGER 27 OUTER SKIN HAS A GOUGE. REPAIRED IAW SRM AND REO.SDR SWIA2018041044509Support Bracket · corrodedLEFT WHEEL WELL SUPPORT BRACKET HAS CORROSION. INSTALLED A NEW LT WHEEL WELL SUPPORT BRACKET IAW SRM.SDR SWIA2018440410508Intercostal · corrodedPAX DOOR INTERCOSTAL DD4, CORRODED. REPLACED THE INTERCOSTAL IAW SRM.SDR SWIA2018041044507Intercostal · corrodedPAX DOOR INTERCOSTAL DD3, IS CORRODED. REPLACED THE INTERCOSTAL IAW SRM.SDR SWIA201642009Frame · corrodedCORROSION AROUND GROUND STUD ON FRAME BS 295 JUST ABOVE STRINGER 19L. R & R THE FRAME SECTOR IAW SRM. PRESSURE CHECKED GOOD.SDR SWIA201642022Fitting · corrodedFORWARD AND AFT PAX DOOR CLOSING FITTINGS AT BS 314 - 342 ARE CORRODED IN MULTIPLE AREAS. R & R FWD AND AFT PAX DOOR CLOSING FITTINGS AT FS314 AND FS342, PN: SH670-32475-3 AND SH670-31840-3 IAW SRM.SDR SWIA201642021Intercostal · corrodedPAX DOOR INTERCOSTAL, LOWER DOOR POSITION, CORROSION. REMOVED DAMAGED AND INSTALLED NEW INTERCOSTAL DD6 PN 601R378057-1, IAW SRM. CHECK GOOD IAW AMM.SDR SWIA201642011Frame · corrodedLOWER FRAME SECTOR AT BS 319 REQUIRES SPLICE REPAIR DUE TO OUT OF LIMITS CORROSION. PERFORMED SPLICE REPAIR TO LOWER FRAME SECTOR AT FS 319 IAW REO. PERFORMED PRESSURIZATION AND LEAK CHECK OF REPAIR AREA, NO LEAKS NOTED.SDR SWIA201642010Frame · corrodedLOWER FRAME SECTOR AT FS 310 REQUIRES SPLICE REPAIR DUE TO OUT OF LIMITS CORROSION. PERFORMED SPLICE REPAIR TO LOWER FRAME SECTOR AT FS 310 IAW REO. PERFORMED PRESSURIZATION AND LEAK CHECK OF REPAIR AREA, NO LEAKS NOTED.SDR SWIA201642020Floor Support · corrodedLEFT FLOOR SUPPORT BS 295-310 SILL HAS CORROSION. R & R THE LT FLOOR SUPPORT IAW SRM. PRESSURE CK GOOD.SDR SWIA201642019Stringer · corrodedSTRINGER 26R SPLICE HAS CORROSION AT BS 333. R & R THE STRINGER SPLICE IAW SRM. PERFORMED PRESSURE CHECKED IAW AMM. CHECKED GOOD.SDR SWIA201642018Stringer · corrodedSTRINGER 20L CORRODED BETWEEN BS 280 AND 295. REPAIRED THE STRINGER IAW REO. PRESSURE CHECKED GOOD.SDR SWIA201642017Floorbeam · corrodedBS 280 FLOORBEAM TOP HAS CORROSION 9 LBL TO 9 RBL. R & R IAW SRM.SDR SWIA201642016Stringer · corrodedSTRINGER 26R HAS CORROSION BETWEEN FS 319 AND FS 333. REMOVED DAMAGED AND INSTALLED NEW STR 26R FROM FS 280 TO FS 330 IAW SRM.SDR SWIA201642015Intercostal · corrodedLEFT INTERCOSTAL BETWEEN FS 349 AND FS 364, LBL2 CORRODED. REMOVED DAMAGED AND INSTALLED NEW LT INTERCOSTAL BETWEEN FS 349 AND FS 364, LBL2 IAW SRM.
Back to N738SK