N744SK
Service difficulty reports · 209
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 = 'N744SK' 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 = 'N744SK' 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 SWIA201439688Axle · damagedNR 4 MLG PISTON AXLE ROOT RADIUS HAS DAMAGE TO THE PROTECTIVE COATING. REPAIRED NR 4 MLG PISTON/AXLE ROOT RADIUS IAW REO.SDR SWIA201439687Axle · damagedNR 3 MLG PISTON AXLE ROOT RADIUS HAS DAMAGE TO THE PROTECTIVE COATING. REPAIRED NR 3 MLG PISTON/AXLE ASSEMBLY ROOT RADIUS IAW REO.SDR SWIA201439686Axle · damagedNR 2 MLG PISTON AXLE ROOT RADIUS HAS DAMAGE TO THE PROTECTIVE COATING. REPAIRED NR 2 MLG PISTON/AXLE ASSEMBLY ROOT RADIUS IAW REO.SDR SWIA201439685Axle · damagedNR 1 MLG PISTON AXLE ROOT RADIUS HAS DAMAGE TO THE PROTECTIVE COATING. REPAIRED NR 1 MLG PISTON/AXLE ASSEMBLY ROOT RADIUS IAWREO.SDR SWIA201439684Screw · missingLEFT ENGINE LOWER INBD TRANSLATING COWL SLIDER SCREW MISSING. R & R LT TRANSCOWL LOWER INBD SLIDER AND HARDWARE IAW REO. FUNCTIONAL TEST OF THE THRUST REVERSER GOOD IAW AMM.SDR SWIA201439683Door Frame · gougedPAX ENTRY DOOR LINTEL, TOP SIDE AFT, GOUGED. REPAIRED DOOR CUTOUT AT BS 349 IAW EA. OPS TESTED GOOD IAW AMM.SDR SWIA201439682Floor Panel · crackedCABIN FLOOR PANEL 272KRF HAS A CRACKED VENT BOX, REPAIRED FLOOR PANEL IAW EA.SDR SWIA201439681Floor Panel · crackedCRACK IN RT BS 193, TRU BAY FLOOR, OTBD EDGE. REPAIRED FLOOR IAW EA.SDR SWIA201439680Floor Panel · crackedCRACK IN LT BS 193 TRU BAY FLOOR, OTBD EDGE, C-CHECK, REPAIRED FLOOR IAW REO.SDR SWIA201439679Fairing · damagedLIGHTNING STRIKE DAMAGE TO VERTICAL STABILIZER BULLET FAIRING AND AFT FAIRING ASSY. REPAIRED IAW EA.SDR SWIA201439678Floorbeam · crackedLEFT BS 280 FLOORBEAM CRACKED. REPAIRED IAW REO.SDR SWIA201439677Floorbeam · crackedRT BS 280 FLOORBEAM CRACKED. REPAIRED IAW REO.SDR SWIA201439676Structure · damagedFOUND LEFT MLG DOOR SEAL HOLES ELONGATED. C-CHECK, REPAIRED IAW EA.SDR SWIA201439030Battery Pack · inoperativeFORWARD F/A FLASHLIGHT BATTERY INOPERATIVE. REPLACED BATTERY PACK IAW AMM. OPS CHECKED GOOD.SDR SWIA201439015Battery Pack · inoperativeF/A FWD FLASHLIGHT DOESN'T BLINK. REPLACED FWD F/A FLASHLIGHT BATTERY. OPS CHECKED PASSED. SECURED FLASHLIGHT IN BRACKET.SDR SWIA201334913Light · inoperativeEMERGENCY LIGHT RT OVERWING EXIT IS BURNED OUT. FLT#6272 RELAMPED.SDR SWIA201334082Skin · gougedFS SKIN GOUGED BETWEEN FS977 & FS985 @ STRINGER 27. C-CHECK REPAIRED SKIN GOUGE BETWEEN FS977 & FS985 @ STRINGER 27 IAW REO.SDR SWIA201334067Fitting · crackedPAX DOOR LINTEL IS CRACKED AT STRINGER 3L, FS 280 - FS 295. C-CHECK REPAIRED PAX DOOR LINTEL AT STRINGER 3L, FS 280 - FS 295 IAW REO.SDR SWIA201333698Light · missingMISSING FLOOR LEVEL EMERGENCY LIGHT COVER IN FWD GALLEY. REPLACED FLOOR LEVEL EMERGENCY LIGHT COVER IN GALLEY IAW AMM.SDR SWIA201333697Lamp · burned outAFT FACING OVERHEAD EMERGENCY LIGHTS ARE BURNED OUT. REPLACED LAMP.SDR SWIA201333303Landing Gear · obstructedRECEIVED GEAR DISAGREE WARNING MESSAGE. (FLT 6423) FOUND ICE ACCUMULATION ON NOSE GEAR, REMOVED ICE AS REQUIRED, JACKED AIRCRAFT CYCLED GEAR MULTIPLE TIMES, NO DISCREPANCIES NOTED. ALL 3 LANDING GEAR OPS CHECK GOOD.SDR SWIA201333186Light · inoperativeOVERHEAD EMERGENCY LIGHT AFT OF EXIT ROW BURNED OUT. (FLT 5507) RELAMPED EMERGENCY LIGHT.SDR SWIA201333085Smoke Warning · false activationSMOKE AFT LAV WARNING MESSAGE EN ROUTE. SELF-EXTINGUISHED AFTER 5-10 SECONDS. NO VISUAL OR OLFACTORY EVIDENCE OF SMOKE. THERE WAS A LOUD BEEP FOR APPROXIMATELY 1 SECOND AT THE SAME TIME AS WARNING MESSAGE. (FLT 6427) PASSENGER IN LAV AT TIME OF WARNING. SDR SWIA201232240Light · inoperativeEMERGENCY FLOOR LIGHTING STRIP BROKEN AT RIGHT EMERGENCY EXIT. (FLT 6292) RELAMPED EMERGENCY LIGHTING.SDR SWIA201231186Light · inoperativeEMERGENCY EXIT ROW CALL INDICATOR LIGHTS ARE INOPERATIVE. (FLT 5195) RELAMPED EMERGENCY LIGHTS.SDR SWIA201230849Light · inoperativeTWO FLOOR EMERGENCY EXIT LIGHTS AT 12D ARE OUT. (FLT 5476) RELAMPED EMERGENCY LIGHTS.SDR SWIA201230434Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5191) RELAMPED EMERGENCY LIGHT.SDR SWIA201230112Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6315) RELAMPED EMERGENCY LIGHT.SDR SWIA201229510Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5495) RELAMPED EMERGENCY LIGHT.SDR SWIA201229458Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229103Skin · damagedRIGHT AILERON LEADING EDGE UPPER SKIN GOUGED. (C-CHECK) REPLACED RIGHT AILERON LEADING EDGE UPPER SKIN PER SRM.SDR SWIA201129056Floorbeam · crackedLEFT AND RIGHT FS 280 FLOORBEAM CRACKED. (C-CHECK) REPLACE PER REO.SDR SWIA201131411Door · dentedFORWARD CARGO DOOR BETWEEN FS 533 AND 549 STRINGER 15 AND 16L IS DENTED. (C-CHECK) REPAIRED IN REFERENCE TO CRJ700 SRM.SDR SWIA201131410Intercostal · corrodedCORROSION ON INTERCOSTAL AT FS 349 TO FS 364 BETWEEN STRINGER'S 26R AND STR 27. (C-CHECK) REPAIRED PER CRJ700 SRM.SDR SWIA201131409Web · crackedCRACK ON PAX DOOR LOWER AFT SECTION OF STAIR WEB. (C-CHECK) REPAIRED PER REO.SDR SWIA201131408Web · crackedCRACK ON PAX DOOR LOWER FORWARD SECTION OF STAIR WEB. (C-CHECK) REPAIRED PER REO.SDR SWIA201126087Light · inoperativeFLOOR LEVEL ENTRANCE EMERGENCY LIGHT IS OUT. (FLT 6782) RELAMPED EMERGENCY LIGHT.SDR SWIA201125937Mount · corrodedRIGHT ENGINE AFT THRUST MOUNT HAS CORROSION ON THE BALL END. (ENGINE CHANGE) REPLACED RT ENGINE AFT THRUST MOUNT ASSEMBLY.SDR SWIA201025014Light · inoperativeTWO EMERGENCY LIGHT BULBS OUT ON GALLEY DOOR. (FLT 6858) RELAMPED EMERGENCY LIGHT BULBS.SDR SWIA201024771Light · inoperativeRIGHT SIDE FLOOR LEVEL EMERGENCY EXIT SIGN HAS ONE BULB BURNED OUT. (FLT 6212) RELAMPED EMERGENCY LIGHT.SDR SWIA201024586Unknown · odorSMOKE WARNING WITH OIL SMELL FROM RIGHT PACK. (FLT 1053) OPERATED PACKS AT ALL SETTING WITH DIFFERENT BLEED SOURCES AND UNABLE TO DUPLICATE.SDR SWIA190024412Web · crackedPASSENGER DOOR AFT WEB CRACKED. (C CHECK) REPAIRED PER REO.SDR SWIA201024368Beam · crackedFS 280 BEAM CRACKED. (C CHECK) REPAIRED PER REO.SDR SWIA201024192Light · inoperativeMOST AFT EMERGENCY CEILING LIGHT INOP. (FLT 5995) RELAMPED EMERGENCY LIGHT.SDR SWIA200921000Connector · looseFLT 6495 - SERVICE DOOR EMERGENCY LIGHT INOP. RESEATED CONNECTOR.SDR SWIA200819331Windshield · crackedFLT 6229 - CAPTAINS WINDSHIELD SHATTERED DURING FLIGHT. REPLACED CAPTAIN'S WINDSHIELD WITH SERVICEABLE UNIT IAW MM 56-11-01, P/N OFF: 601R33033-17, S/N OFF: 04206H1831.
SDR SWIA200819092Relay · malfunctionedFLT 6510 - EMERGENCY LIGHTS CYCLE ON AND OFF DURING FLIGHT. REPLACED RELAY K135 IN JB-11 ON PCB-5. OPS CHECK GOOD.SDR SWIA200718832Wire · brokenFLT 6438 - RECEIVED A PROX SYSTEM FAULT 2 STATUS MESSAGE AT THE GATE. REPAIRED BROKEN WIRE ON FORWARD CARGO DOOR HARNESS. OPS CHECKS GOOD.SDR SWIA200719167Web · crackedRIGHT LOWER WEB AT FS 280 IS CORRODED, FOUND AT C-CHECK. REPLACED RIGHT LOWER WEB AT FS 280 PER CRJ700 SRM 53-11-10-201-003-A01.SDR SWIA200719166Floorbeam · crackedFS 280 COCKPIT FLOORBEAM IS CRACKED AT RBL9 AND LBL9, FOUND AT C-CHECK. REPLACED COCKPIT FLOORBEAM PER CRJ700 SRM 51-42-06.
Back to N744SK