N715SK
Service difficulty reports · 144
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 = 'N715SK' 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 = 'N715SK' 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 SWIA201229177Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5574) RELAMPED EMERGENCY LIGHT.SDR SWIA201129067Light · inoperativeTHE 4TH OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5400) RELAMPED EMERGENCY LIGHT.SDR SWIA201128342Light · inoperativeOVERHEAD EMERGENCY LIGHTS ARE OUT ABOVE ROWS 9 AND 17. (FLT 5473) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127936Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS INOPERATIVE. (FLT 5494) RELAMPED EMERGENCY LIGHT.SDR SWIA201127787Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT INOPERATIVE. (FLT 6444) RELAMPED EMERGENCY LIGHT.SDR SWIA201127564Light · inoperativeLAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5539) RELAMPED EMERGENCY LIGHT.SDR SWIA201127553Light · inoperativeNR 4 CEILING EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201127331Light · inoperativeTWO AFT CEILING EMERGENCY LIGHTS ARE OUT. (FLT 2029) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127149Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 1159) RELAMPED EMERGENCY LIGHT.SDR SWIA201127148Cam Roller · out of adjustF/A COULD NOT OPEN THE MCD. (FLT 1174) ADJUSTED PAX DOOR UPPER AFT CAM ROLLER ASSEMBLY.SDR SWIA201127078Light · inoperativeTWO AFT CEILING EMERGENCY EXIT LIGHTS ARE OUT. (FLT 1108) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127015Anchor Fitting · out of adjustMCD IS DIFFICULT TO OPEN. (FLT 1100) ADJUSTED PAX DOOR AFT ANCHOR FITTING.SDR SWIA201126955Light · inoperativeTHE 2ND FROM AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6536) RELAMPED EMERGENCY LIGHT.SDR SWIA201126937Light · inoperativeRIGHT OVERWING EMERGENCY LIGHT EXIT AT ROW 12 IS OUT. (FLT 6233) RELAMPED EMERGENCY LIGHT.SDR SWIA201126542Floorbeam · crackedFS 280 FLOORBEAM IS CORRODED AND CRACKED. (C-CHECK) REPLACED PER SRM.SDR SWIA201128507Crossbeam · corrodedFS 280 CROSSBEAM HAS CORROSION AROUND SCREW HOLES IN SEVERAL LOCATIONS AND IS CRACKED AT RBL 12.5 AT FASTENER HOLE. (C-CHECK) REPAIRED FS 280 FLOORBEAM PER SRM.SDR SWIA201126411Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6796) RELAMPED EMERGENCY LIGHT.SDR SWIA201126279Light · brokenEMERGENCY LIGHT AT SERVICE DOOR IS BROKEN. (SERVICE) REPLACED LIGHT ASSEMBLY AT SERVICE DOOR.SDR SWIA201125873Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6535) RELAMPED EMERGENCY LIGHT.SDR SWIA201125618Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS NOT WORKING. (FLT 6272) RELAMPED EMERGENCY LIGHT.SDR SWIA201025380Light · inoperativeLAST CEILING EMERGENCY LIGHT IS OUT. (FLT 6573) RELAMPED EMERGENCY LIGHT.SDR SWIA201025225Light · inoperativeTHE 2ND TO LAST CEILING EMERGENCY LIGHT INOPERATIVE. (FLT 6828) RELAMPED EMERGENCY CEILING LIGHT.SDR SWIA201025165Acm · malfunctionedRIGHT PACK PRODUCED SMOKE IN CABIN AFTER ENGINE START ON NR 2 ENGINE. (FLT 6770) REPLACED RT ACM.SDR SWIA201024987Lamp · burned outEMERGENCY LIGHT ABOVE ROW 17 INOPERATIVE. (FLT 6465) RELAMPED.SDR SWIA200922431Light · inoperativeEMERGENCY CEILING LIGHT INOP. (FLT 6532) RELAMPED EMERGENCY LIGHT.SDR SWIA200921687Lamp · burned outFLT 6079 - NR 5 EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200921173Tire · failedFLT 6476 - LEFT INBOARD FLAP DAMAGED DUE TO NR 2 BLOWN TIRE UPON LANDING. REPLACED LEFT INBOARD FLAP.SDR SWIA200820440Bracket · corrodedC-CHECK, RIGHT MLG RETRACT ACTUATOR BRACKET ASSEMBLY PIN CORRODED. REPLACED BRACKET AND PIN.SDR SWIA200820439Bracket · corrodedC-CHECK, LEFT MLG RETRACT ACTUATOR BRACKET ASSEMBLY CORRODED. REPLACED.SDR SWIA200819724Structure · damagedDAMAGE ON AFT RIGHT FUSELAGE BETWEEN FS 1031 AND 1051.3 BETWEEN STRINGERS 19R AND 20R.INSTALLED PERMANENT REPAIR PER REO 670-53-61-372.SDR SWIA200819066Windshield · crackedUPON INITIAL DESCENT, THE RIGHT WINDSHIELD CRACKED, FLIGHT NR 5927. REPLACED THE WINDSHIELD PER CRJ MM 56-11-01, PN: NP-139321-6, SN OFF: 0415CH6544.
SDR SWIA200718886Skin · dentedFOUND DENT ON FUSELAGE ABOUT 10 FEET AFT OF GALLEY SERVICE DOOR, FLIGHT NR 6599. REPAIRED RIGHT SIDE FUSELAGE SKIN PER REO 670-53-00-0135.
SDR SWIA200718519Web · corrodedRIGHT SIDE OF STA 280 WEB IS CORRODED, DISCOVERED AT C-CHECK. REPLACED RIGHT WEB PER REO 670-53-11-05-2.SDR SWIA200718518Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLES AND SPLICES PER REO:670-52-11-072.SDR SWIA200718517Web · crackedPAX DOOR AFT WEB IS CRACKED AT UPPER STEP, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLES, DOUBLERS, AND SHIMS PER REO52-11-104.SDR SWIA200718516Floorbeam · crackedCOCKPIT FLOOR SUPPORT ANGLE IS CRACKED AT LBL9. (DISCOVERED AT C-CHECK)INSTALLED NEW COCKPIT FLOOR SUPPORT ANGLES IAW CRJ7/9 SRM 51-42-06-001-001-A01.SDR SWIA200718515Floorbeam · crackedFS 280 FLOORBEAM IS CRACKED AT LBL9, DISCOVERED AT C-CHECK. NEW BEAM INSTALLED PER REO 670-53-11-047.SDR SWIA200718514Support Beam · crackedFS 280 SUPPORT BEAM IS CRACKED AT LBL9, DISCOVERED AT C-CHECK. INSTALLED SPLICE DOUBLERS PER REO 670-53-11-047 REV D.SDR SWIA200616473Windshield · crackedCAPTAIN'S OUTER PANE OF WINDOW SHATTERED AT FL 350. REPLACED CAPTAIN'S WINDSHIELD PER MM 56-11-01. PN NP139321-13 SN OFF 04156H6477SDR SWIA200616374Lamp · burned outCEILING LEVEL EMERGENCY FLOOD LIGHT (2ND FROM REAR) INOP. RELAMPED CEILING LEVEL EMERGENCY FLOOD LIGHT 2ND FROM REAR AS REQUIRED. OPERATIONAL CHECK GOOD.SDR SWIA200516027Wire · damagedFLAP HALFSPEED MESSAGE. SPLICED AND REPAIRED WIRES AT NR 2 BPSU CONNECTOR P1 IAW 20-44-09. REPLACED SFECU IAW CRJ MM 27-51-05. OPERATIONAL CHECK GOOD.SDR SWIA200515981Sensor · malfunctionedFLAPS HALFSPEED MSG. REPLACED RT FLAP BPSU. OPERATIONAL CHECK GOOD IAW 27-52-03.SDR SWIA200514814Control Unit · malfunctionedSSCU 1 FAULT STATUS MESSAGE. INSTALLED A SERVICEABLE SSCU IAW CRJ 700 MM 27-61-05. OPERATIONAL CHECK GOOD.SDR SWIA200514630Control Unit · malfunctionedSTAB/SPLR FAULT STATUS MSG ILLUMINATED. REPLACED NR 1 SSCU AS REQUIRED PER AMM 27-61-05. OPERATIONAL CHECK GOOD.
Back to N715SK