N755SK
Service difficulty reports · 171
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 = 'N755SK' 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 = 'N755SK' 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 SWIA201540834Panel · damagedFOUND 2 ELONGATED SCREW HOLES ON MID STEP PANEL ON PAX DOOR. C-CHECK, CORROSION WAS REMOVED AND ELONGATED SCREW HOLES WERE REPAIRED IAW STS EA.SDR SWIA201540832Panel · damagedFOUND ELONGATED SCREW HOLE ON TOP STAIR PANEL. C-CHECK, CORROSION REMOVED AND ELOGATED SCREW HOLE WAS REPAIRED IAW STS EA.SDR SWIA201540827Hinge · gougedPAX DOOR PIANO HINGE ON FUSELAGE SIDE IS GOUGED ON MOST AFT LUG. C-CHECK, REPAIRED GOUGE ON ON FUSELAGE SIDE OF PAX DOOR PIANO HINGE AT AFT MOST LUG, IAW REO.SDR SWIA201540826Arm · chafedFWD BAG BAY DOOR, FWD INBD COUNTED BALANCE ARM CHAFED. C-CHECK, REPAIRED CHAFE ON FWD BAG BAY DOOR, FWD, INBD COUNTER BALANCE ARM, IAW STS EA.SDR SWIA201540831Hinge · chafedLT WING OTBD FLAP HAS 2 CHAFING MARKS ON LOWER L/E AT CENTER HINGE. C-CHECK, REPAIRED, 2 EA, CHAFED AREAS ON LT WING OTBD FLAP LWR L/E AT THE CENTER HINGE IAW STS EA.SDR SWIA201540825Lead · damagedLT ENGINE IDG POWERLEAD OUTSIDE COVERING FOR ALL 4 LEADS HAVE HOLES IN MATERIAL. C-CHECK, REPAIRED OUTER INSULATION JACKET FOR THE IDG CABLES ON THE LT ENGINE IAW REO.SDR SWIA201540824Door · dentedSEVERAL DENTS ON LT ENGINE LOWER FAN COWL DOOR. C-CHECK, ADDRESSED SEVERAL DENTS ON LT ENGINE LWR FAN COWL DOOR IAW REO.SDR SWIA201540830Skin · dentedDENT AT LT FUSELAGE SKIN PANEL FWD OF FS 394.0 AND WITHIN 0.047" CHEM-MILL POCKET AREA BETWEEN STR 20L AND STR 21L. C-CHECK, RO: 03/09/2015, REPAIRED DENT AT LT FUSELAGE SKIN PANEL FWD OF FS 394.0 AND BETWEEN STR 20L AND 21L IAW STS EA.SDR SWIA201438382Bulb · inoperativeONE BULB INOPERATIVE ON EMERGENCY EXIT ROW SIGN. REPLACED THE BULB.SDR SWIA201438262Tape · looseFLOOR REFLECTIVE PANEL CAME OFF AT LT OVERWING EXIT. RE-SECURED FLOOR REFLECTIVE PANEL BY LT OVERWING EXIT WITH TWO-SIDED CARPET TAPE.SDR SWIA201437929Battery Pack · inoperativeCAPTAIN`S FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT BATTERY.SDR SWIA201435970Light · inoperativeNR 4 EMERGENCY POD LIGHT OUT. FLT 6515 RELAMPED.SDR SWIA201334799Strap · corroded7 STRAP ON FS 280.0 CROSSBEAM LBL11.0 TO RBL11.0 IS CORRODED. C-CHECK 7 STRAP CORROSION REPAIRED IAW REO.SDR SWIA201334798Strap · corrodedSTRAP PN 670-53-11-579-7 ON THE FS 280 CROSSBEAM LBL 11.0 TO RBL 11.0 IS CORRODED. C-CHECK FABRICATED NEW STRAP PN 670-53-11-579-7 IAW REO.SDR SWIA201334800Angle · crackedOTBD L ANGLE AT LBL9 FS 280 IS CRACKED. C-CHECK FABRICATED OTBD & INBD L ANGLES 3 - 6 IAW REO.SDR SWIA201334803Skin · chafedCHAFFING ON FS BELLY AT FS 970, MARKED. C-CHECK COMPLIED WITH REO.SDR SWIA201334802Stringer · crackedSTRINGER 3L IS CRACKED AT FASTENER HOLES AT FS 280. C-CHECK REPAIRED PAX DOOR LINTEL STRINGER 3L AT FS 280 & FS 295 IAW REO.SDR SWIA201334801Frame · crackedCABIN RIB AT FS 333 AT TOP OF CABIN AT STRINGER 2R CRACKED, MARKED. C-CHECK REPLACED FRAME PN SH670-32036-5 RT STRINGER O TO RT STRINGER 9 IAW SRM.SDR SWIA201334805Sill · corrodedAFT CARGO DOOR SILL HAS CORROSION. C-CHECK REPLACED AFT CARGO DOOR SILL IAW AMM.SDR SWIA201334804Lever · chafedPAX DOOR FWD PULL IN LEVER CHAFED. C-CHECK BLENDED DAMAGED AREA ON PAX DOOR FWD PULL IN LEVER IAW REO.SDR SWIA201334806Skin · chafedCHAFE ON BELLY SKIN AT APPROXIMATELY FS 977, STRINGER 27. C-CHECK COMPLIED WITH REO.SDR SWIA201334557Light · inoperativeOVERHEAD EMERGENCY EXIT LIGHT BURNED OUT. FLT 6265 RELAMPED.SDR SWIA201333233Windshield · crackedLEFT SIDE WINDSHIELD CRACKED. (FLT 6217) REPLACED LEFT WINDSHIELD IAW AMM. P/N NP-139321-5 S/N ON-11348H1097 P/N OFF-601R33033-21 S/N OFF 05039H9286SDR SWIA201332761Door · unlatchedRIGHT EMERGENCY DOOR CAME UNLATCHED ON LANDING. (FLT 5184) INSPECTED RIGHT OVERWING EMERGENCY DOOR IAW AMM.SDR SWIA201232459Light · inoperativeAFT EMERGENCY OVERHEAD LIGHT BURNED OUT. (FLT 6520) RELAMPED EMERGENCY LIGHT.SDR SWIA201232130Cable · failedPASSENGER DOOR VERY DIFFICULT TO OPEN AND CLOSE FROM INTERIOR. (FLT 6508) REPLACED THE ICE BREAK CABLE IAW AMM.SDR SWIA201231973Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6291) RELAMPED EMERGENCY LIGHT.SDR SWIA201231952Motor · failedPASSENGER DOOR CLOSES UNCOMMANDED. (FLT 6742) REPLACED PASSENGER DOOR POWER ASSIST MOTOR ASSEMBLY AND RELAY 1C138 IN REFERENCE TO CRJ 700 AMM. P/N: 2RJ206B S/N OFF: A0434.SDR SWIA201231113Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5617) RELAMPED EMERGENCY LIGHT.SDR SWIA201230801Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6248) RELAMPED EMERGENCY LIGHT.SDR SWIA201230485Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230267Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6348) RELAMPED EMERGENCY LIGHT.SDR SWIA201229800Light · inoperativeLEFT WING EMERGENCY EXIT LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229626Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6372) RELAMPED EMERGENCY LIGHT.SDR SWIA201229326Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6363) RELAMPED EMERGENCY LIGHT.SDR SWIA201229200Light · inoperativeNR 1 CEILING EMERGENCY LIGHT IS OUT. (FLT 6407) RELAMPED EMERGENCY LIGHT.SDR SWIA201128921Splice · damagedROW 12 CEILING EMERGENCY EXIT SIGN NOT ILLUMINATING. (FLT 5428) REPAIRED SPLICE FOR CEILING EMERGENCY EXIT SIGN ABOVE ROW 12.SDR SWIA201128905Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5185) RELAMPED EMERGENCY LIGHT.SDR SWIA201127979Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT NOT WORKING. (FLT 6224) RELAMPED EMERGENCY LIGHT.SDR SWIA201127398Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5399) RELAMPED EMERGENCY LIGHT.SDR SWIA201126695Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 14 IS OUT. (FLT 6374) RELAMPED EMERGENCY LIGHT.SDR SWIA201126634Intercostal · gougedSTRINGER 9L INTERCOSTAL BETWEEN FS 1144 - FS 1162 HAS A GOUGE JUST INBOARD OF THE FORWARD CUTOUT. (SERVICE) REPAIRED THE ACM SUPPORT INTERCOSTAL AT STR 9L FS 1144.00 - FS 1154.48 PER REO.SDR SWIA201125396Ballast · smokeSMOKE IN THE CABIN WHILE CLIMBING. (FLT 6448) REPLACED CEILING LIGHT BALLAST AT 12 A/B.SDR SWIA201025315Light · inoperativeSECOND FROM LAST OVERHEAD EMERGENCY LIGHT OUT. (FLT 6948) RELAMPED EMERGENCY LIGHT.SDR SWIA201024957Floorbeam · corrodedFS 280 FLOORBEAM IS CRACKED AND EXFOLIATED. (C-CHECK) REPAIRED PER SRM.SDR SWIA201024693Light · inoperativeOVERHEAD EMERGENCY LIGHT INOP. (FLT 6907) RELAMPED EMERGENCY LIGHT.SDR SWIA201024539Control Panel · defectiveRUDDER RUN AWAY TO RIGHT INFLIGHT, UNCOMMANDED. (FLT 591) REPLACED AILERON/RUDDER TRIM CONTROL PANEL.SDR SWIA201023916Light · inoperativeEMERGENCY CEILING LIGHT IN FIRST CLASS INOP. (FLT 6566) RELAMPED CEILING LIGHT.SDR SWIA201023645Light · inoperativeNR 5 EMERGENCY OVERHEAD LIGHT INOP. (FLT 5961) RELAMPED EMERGENCY LIGHT.SDR SWIA201023589Light · inoperativeEMERGENCY FLOOD LIGHT NR 5 ON THE OVERHEAD CEILING INOP. (FLT 6590) RELAMPED EMERGENCY LIGHT.
Back to N755SK