N604SK
Service difficulty reports · 174
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 = 'N604SK' 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 = 'N604SK' 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 SWIA201541088Seat Track · corrodedRT CABIN SIDE SEAT TRACK, BS 861 TO 969 HAS CORROSION, C-CHECK, RO 4/21/15, RT CABIN SIDE SEAT TRACK FROM FS861.00-FS969.00 IS OUT OF LIMITS DUE TO CORROSION IN A NO DAMAGE ALLOWABLE AREA. REF: REO. R & R ON CAMP 12064258.SDR SWIA201541087Seat Track · corrodedRT CABIN SIDE SEAT TRACK FS 713 TO 763 HAS CORROSION, C-CHECK RO 4/21/15. REMOVED DAMAGE ON RT CABIN SIDE SEAT TRACK AT FS713.00 - FS 763.00. LARGEST MATERIAL LOSS FOUND TO BE AT LOCATION "Z". MAX ALLOWABLE GAP: 0.460". ORIGINAL GAP: 0.420". REMAINING GAP: 0SDR SWIA201541080Seat Track · corrodedLT CABIN SIDE SEAT TRACK FS 713 TO 763 HAS CORROSION, C-CHECK, RO 4/21/15, REMOVED DAMAGE ON LT CABIN SIDE SEAT TRACK AT FS713.00 - FS 763.00. LARGEST MATERIAL LOSS FOUND TO BE AT LOCATION "Z". MAX ALLOWABLE GAP: 0.460". ORIGINAL GAP: 0.420". REMAINING GAP: 0SDR SWIA201541079Seat Track · corrodedLT CABIN SIDE SEAT TRACK FS 785 TO 861 HAS CORROSION, C-CHECK, RO 4/21/15, REMOVED DAMAGE ON LT CABIN SIDE SEAT TRACK FROM FS 785.00-FS 861.00. LARGEST MATERIAL LOSS FOUND AT LOCATION "Z". MAX ALLOWABLE GAP: 0.460". ORIGINAL GAP: 0.420". REMAINING GAP: 0.479"SDR SWIA201541078Seat Track · corrodedLT CABIN SIDE SEAT TRACK FS 861 TO 969 HAS CORROSION, C-CHECK, RO 4/21/15, LT CABIN SIDE SEAT TRACK FROM FS861.00-FS969.00 IS OUT OF LIMITS DUE TO CORROSION IN A NO DAMAGE ALLOWABLE AREA. REF: REO. R & R SEAT TRACK.SDR SWIA201541075Frame · corrodedFRAME CORRODED AT FS 310.00 FROM STR 26 L TO 26 R FWD SIDE (C-CHECK RO 4/21/15)REMOVED CORROSION ON FWD SIDE OF FRAME AT FS 310.00 BETWEEN STRG 26L AND STRG 26R. REF CRJ 700 SRM. RECEIVED AND COMPLIED WITH STS EA 30-2015-161.SDR SWIA201541072Intercostal · corrodedCORROSION ON INTERCOSTAL BETWEEN FS 349.00 AND 364.00 AND BETWEEN STR 27 AND 26R, C-CHECK, RO 4/21/15, COMPLIED WITH REPAIR TO THE INTERCOSTAL BETWEEN FS 349.00 AND 364.00 AND BETWEEN STR 27R AND 26R REF STS EA.SDR SWIA201541092Door Sill · gougedAFT BAGGAGE BAY DOOR CUT-OUT SILL HAS GOUGES AT APPROXIMATELY FS 1006.00. C-CHECK RO 4/21/15, BLENDED OUT GOUGES AT AFT BAGGAGE BAY DOOR SURROUND LOWER SILL, FOUND WITHIN LIMITS OF AND COMPLIED WITH REO.SDR SWIA201541086Hinge · gougedPAX DOOR AIRFRAME SIDE PIANO HINGE GOUGED AFT END, DUE TO HINGE PIN ROLL PIN, C-CHECK, RO 4/21/15, PERFORMED BLEND OUT ON PAX DOOR AIRFRAME SIDE PIANO HINGE AT AFT END AT THE LOCATION OF THE HINGE PIN ROLL PIN, REF: REO, BLEND OUT WAS FOUND TO BE OUT OF LIMITSDR SWIA201541071Skin · gougedAFT BAGGAGE BAY DOOR, EXTERIOR, HAS GOUGE ON HANDLE CUTOUT ON THE FORWARD LOWER AREA OF CUTOUT. C-CHECK, RO 4/21/15, BLENDED OUT GOUGE ON AFT BAGGAGE BAY DOOR EXTERIOR HANDLE HOUSING INNER CORNER AND FOUND WITHIN ALLOWABLE LIMITS OF REO.SDR SWIA201541093Door Frame · corrodedPASSENGER DOOR FWD FORMER, FS 311.75, HAS CORROSION AROUND UPPER TENSION TIE FITTING ON DOOR. C-CHECK RO 4/21/15, REMOVED COROSION FROM FWD FORMER AT FS 311.75 AT UPPER TENSION TIE LOCATION REF SRM. REPAIR FOUND TO BE WITHIN LIMITS. REF, STS EA.SDR SWIA201541085Lever · chafedPASSENGER DOOR FWD PULL-IN LEVER CHAFED. C-CHECK, RO 4/21/15, REMOVED AND INSTALLED NEW PASSENGER DOOR FWD PULL-IN LEVER, PN 601R318968-4, REF, AMM & REO.SDR SWIA201541084Structure · dentedPASSENGER DOOR FWD CORNER CAP DENTED NAD HAS DAMAGED BLIND FASTENER. DENT IS OUT OF LIMITS BECAUSE IT IS GREATER THAN THE ALLOWABLE DEPTH OF 0.050" OF REO PERFORMED NDT AFTER REWORK AND NO DEFECTS NOTED, RESTORED SURFACE FINISH. REF SRM.SDR SWIA201541083Structure · dentedPASSENGER DOOR AFT CORNER CAP DENTED AND HAS DAMAGED BLIND FASTENER. DENT IS OUT OF LIMITS BECAUSE IT IS GREATER THAN THE ALLOWABLE DEPTH OF 0.050" OF REO. PERFORMED NDT AFTER REWORK AND NO DEFECTS NOTED, SEE ATTACHED CONTINUATION CARD FOR DETAILS. INSTALSDR SWIA201541082Skin · chafedLOWER FUSELAGE EXTERIOR SKIN CHAFED AT FS 973.00, STR. 27.0. C-CHECK, RO 4/21/15, REMOVED CHAFING ON LOWER FUSELAGE EXTERIOR SKIN AT FS 973.00, STR. 27.0 AND FOUND WITHIN LIMITS REF REOSDR SWIA201541081Skin · chafedLOWER FUSELAGE EXTERIOR SKIN CHAFED 2 PLACES AT FS 981.00 NEAR STR 27. C-CHECK, REMOVED 2 AREAS OF CHAFING ON LOWER FUSELAGE EXTERIOR SKIN AT FS 981.00, STR 27 AND FOUND WITHIN LIMITS REF REO.SDR SWIA201541077Arm · chafedFWD CARGO DOOR FWD COUNTER BALANCE ARM CHAFED 2 PLACES ON FWD SIDE. C-CHECK RO 4/21/15, COMPLIED WITH PERMANENT REPAIR IAW STS EA.SDR SWIA201541076Arm · chafedFWD CARGO DOOR AFT COUNTER BALANCE ARM CHAFED 2 PLACES ON AFT SIDE. C-CHECK, RO 4/21/15, COMPLIED WITH PERMANENT REPAIR STS EA.SDR SWIA201541073Floorbeam · crackedFS 280 CROSSBEAM CRACKED AND CORRODED. R & R REF REO, PERFORMED NDT OF THE FS 280 BEAM WEB AND FLANGES LBL 11.128 - RBL 11.128, REF REO, NO DEFECTS NOTED, SEE ATTACHED NDT REPORT. COMPLIED WITH PERMANENT REPAIR BY INCORPORATION OF SB .SDR SWIA201439424Battery Pack · dischargedEMERGENCY LIGHTS WERE LEFT IN THE ARMED POSITION WITH NO POWER ON THE ACFT. BATTERY DISCHARGED. LET ACFT REMAIN ON GROUND POWER TO CHARGE BATTERIES. OPS CHECK EDGOOD OF EMERGENCY LIGHTS IAW AMM.SDR SWIA201438898Door · bindingUNABLE TO OPEN MAIN CABIN DOOR FROM INSIDE. OPENED DOOR AFTER CYCLING OUTER HANDLE SEVERAL TIMES. OPS NORMAL IAW AMM.SDR SWIA201438864Battery Pack · inoperativeAFT F/A FLASHLIGHT INOPERATIVE. REPLACED THE AFT FLASHLIGHT BATTERY.SDR SWIA2014061838216Light · inoperativeNR 6 EMERGENCY CEILING FLOOD LIGHT INOPERATIVE. R & R AFT EMERGENCY CEILING FLOOD LIGHT IAW AMM.SDR SWIA201437711Lamp · burned outEMERGENCY LIGHT IN CEILING AT ROW 15 IS BURNED OUT, REPLACED THE LAMPS.SDR SWIA201437000A/C Pack · contaminatedSMELLED DIESEL FUMES IN CABIN. ODOR WORSENED WITH WARMER PACK OUTPUT. FOUND TYPE 2 DE-ICE FLUID IN AC PACK. RAN PACK FULL HOT/COLD UNTIL IT CLEARED.SDR SWIA201334143Light · inoperativeEMERGENCY OVERHEAD LIGHT AT ROW 9 IS BURNED OUT. FLT#4502 RELAMPED.SDR SWIA201334144Printed Ckt Board · failedEMERGENCY LIGHTS CYCLE ON & OFF. FLT#4668 REPLACED THE PCB5 IN JB11. PN E52005-705ASDR SWIA201333778Skin · corrodedMAIN CABIN DOOR HAS SEVERAL SPOTS OF CORROSION UNDER PANEL 832 AB. C-CHECK COMPLIED WITH PERMANENT REPAIR TO MAIN CABIN DOOR INNER SKIN IAW STS EA.SDR SWIA201333785Seat Track · corrodedRT SIDE SEAT RAIL AT FS 708 IS CORRODED. C-CHECK REMOVED CORROSION ON RT SIDE SEAT RAIL AT FS708.00 IAW REO.SDR SWIA201333784Seat Track · corrodedRT SIDE SEAT RAIL AT FS 724-FS 752 IS CORRODED. C-CHECK REMOVED CORROSION ON RT SIDE SEAT RAIL AT FS724.00 FS752.00 IAW REO.SDR SWIA201333783Seat Track · corrodedRT SIDE SEAT RAIL AT FS 785 & FS797 IS CORRODED. C-CHECK REMOVED CORROSION ON RT SIDE SEAT RAIL AT FS785.00 & FS797.00 IAW REO.SDR SWIA201333782Seat Track · corrodedLT SIDE SEAT RAIL AT FS 708 IS CORRODED. C-CHECK REMOVED CORROSION ON LT SIDE SEAT RAIL AT FS708.00 IAW REO.SDR SWIA201333781Seat Track · corrodedLT SIDE SEAT RAIL AT FS 730 IS CORRODED. C-CHECK REMOVED CORROSION ON LT SIDE SEAT RAIL AT FS730.00 IAW REO.SDR SWIA201333780Seat Track · corrodedLT SIDE SEAT RAIL AT FS 785 & FS797 IS CORRODED. C-CHECK REMOVED CORROSION ON LT SIDE SEAT RAIL AT FS785.00 & FS797.00 IAW REO.SDR SWIA201333779Seat Track · corrodedLT SIDE SEAT RAIL AT FS 830 IS CORRODED. C-CHECK REMOVED CORROSION ON LT SIDE SEAT RAIL AT FS830.00 IAW REO.SDR SWIA201333786Doubler · corrodedSTATION 280-282 CIRCUMFERENTIAL JOINT DOUBLER HAS CORROSION IN SEVERAL AREAS FROM STRINGER 23RT-23LT. C-CHECK REPAIRED IAW STS EA.SDR SWIA201333787Crossbeam · corrodedFS 280 CROSSBEAM CRACKED & CORRODED. C-CHECK REPLACED FS 280 CROSSBEAM IAW REO.SDR SWIA201332611Shoulder Belt · failedF/O'S LEFT SHOULDER HARNESS WILL NOT UNLOCK AND THE RIGHT SHOULDER HARNESS WILL NOT LOCK. (FLT 4740) REPLACED F/O'S SHOULDER HARNESS QUICK CHANGE ASSEMBLY AND BUCKLE PAD. P/N 1: 504952-1 / P/N 2: 5001-1-021-2396SWSDR SWIA201332572Seal · dirtyMAIN CABIN DOOR CONTINUES TO BE TOO DIFFICULT FOR FORWARD F/A TO OPEN. (FLT 4442) CLEANED AND LUBED THE DOOR PINS AND SEAL. INSPECTED THE LINKAGE FOR PROPER MOVEMENT. CYCLED THE DOOR SEVERAL TIMES AND FOUND NO ISSUES WITH THE DOOR AFTER CLEANING. OPS GOODSDR SWIA201232457Inertia Reel · defectiveF/O'S LEFT SHOULDER BELT PART OF HARNESS BINDING. (FLT 4469) REMOVED AND REPLACED CO-PILOT INERTIA REEL ON THE SHOULDER HARNESS.SDR SWIA201232345Bracket · damagedPASSENGER DOOR DAMAGED BY TO THE GROUND AND RIPPING OFF THE SUPPORT WHEEL. (SERVICE) REPLACED PASSENGER DOOR SUPPORT WHEEL BRACKET AND REPAIRED SKIN IN UNDERLYING STRUCTURE IAW SRM 52-11-01.SDR SWIA201232218Light · inoperativeFIFTH EMERGENCY OVERHEAD LIGHT BURNED OUT. (FLT 4792) RELAMPED EMERGENCY LIGHT.SDR SWIA201231821Light · inoperative2ND TO LAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4527) RELAMPED EMERGENCY LIGHT.SDR SWIA201231280Battery Pack · dischargedEXIT LIGHTS AT ROW 5-9 ARE OUT. (SERVICE) REPLACED NR 2 BATTERY PACK. P/N AD-2013-1A, S/N OFF 65906.SDR SWIA201231054Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4753) RELAMPED EMERGENCY LIGHT.SDR SWIA201230675Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230630Light · inoperativeLAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4484) RELAMPED EMERGENCY LIGHT.SDR SWIA201230568Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4442) RELAMPED EMERGENCY LIGHT.SDR SWIA201230302Lamp · burned outFLT 4708, OVERHEAD EMERGENCY LIGHT AT ROW 17 IS OUT. RELAMPED EMERGENCY LIGHT.SDR SWIA201230154Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4618) RELAMPED EMERGENCY LIGHT.
Back to N604SK