N746SK
Service difficulty reports · 226
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 = 'N746SK' 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 = 'N746SK' 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 SWIA201334200Light · inoperativeEMERGENCY LIGHTS BURNED OUT. FLT#5538 RELAMPED.SDR SWIA201333849Seat Track · corrodedLT FLOOR SEAT TRACK AT FS 683.0 - 836.0 REQUIRES REPLACEMENT. C-CHECK REPLACE LT FLOOR SEAT TRACK AT FS 683.0 - 836.0 IAW AMM.SDR SWIA201333848Seat Track · corrodedRT FLOOR SEAT TRACK AT FS 683.0 - 836.0 REQUIRES REPLACEMENT. C-CHECK REPLACED RT FLOOR SEAT TRACK AT FS 683.0 - 836.0 IAW AMM.SDR SWIA201333847Seat Track · corrodedRT FLOOR SEAT TRACK AT FS 581.0 - 683.0 REQUIRES REPLACEMENT. C-CHECK REPLACED RT FLOOR SEAT TRACK AT FS 581.0 - 683.0 IAW AMM.SDR SWIA201333846Seat Track · corrodedRT FLOOR SEAT TRACK AT FS 350.0 - 485.0 REQUIRES REPLACEMENT. C-CHECK REPLACED RT FLOOR SEAT TRACK AT FS 350.0 - 485.0 IAW AMM.SDR SWIA201333863Seat Track · corrodedRT SIDE SEAT TRACK AT FS 379.0 - 477.4 REQUIRES REPLACEMENT. C-CHECK REPLACED RT SIDE SEAT TRACK AT FS 379.0 - 477.4 IAW AMM.SDR SWIA201333862Seat Track · corrodedRT SIDE SEAT TRACK AT FS 477.4 - 573.0 REQUIRES REPLACEMENT. C-CHECK REPLACED RT SIDE SEAT TRACK AT FS 477.4 - 573.0 IAW AMM.SDR SWIA201333861Seat Track · corrodedRT SIDE OF SEAT TRACK AT FS 573.0 - 699.4 REQUIRES REPLACEMENT. C-CHECK REPLACED RT SIDE SEAT TRACK AT FS 573.0 - 699 IAW AMM.SDR SWIA201333860Seat Track · corrodedRT SIDE SEAT TRACK AT FS 669.4 - 713.0 REQUIRES REPLACEMENT. C-CHECK REPLACED RT SIDE SEAT TRACK AT FS669.4 - 713.0 IAW AMM.SDR SWIA201333859Seat Track · corrodedRT SIDE SEAT TRACK AT FS 713.0 - 761.85 REQUIRES REPLACMENT. C-CHECK REPLACED RT SIDE SEAT TRACK AT FS 713.0 - 761.85 IAW AMM.SDR SWIA201333858Seat Track · corrodedRT SIDE SEAT TRACK AT FS 785.15 - 861.0 REQUIRES REPLACEMENT. C-CHECK REPLACED RT SIDE SEAT TRACK AT FS 785.15 - 861.0 IAW AMM.SDR SWIA201333857Seat Track · corrodedLT SIDE SEAT TRACK AT FS 785.15 - 861.0 REQUIRES REPLACEMENT. C-CHECK REPLACED LT SIDE SEAT TRACK AT FS 785.15 - 861.0 IAW AMM.SDR SWIA201333856Seat Track · corrodedLT SIDE SEAT TRACK AT FS 669.4 - 713.0 REQUIRES REPLACEMENT. C-CHECK REPLACED LT SIDE SEAT TRACK AT FS 669.4 - 713.0 IAW AMM.SDR SWIA201333855Seat Track · corrodedLT SIDE SEAT TRACK AT FS 573.0 - 669.4 REQUIRES REPLACEMENT. C-CHECK REPLACED LT SIDE SEAT TRACK AT FS 573.0 - 669.4 IAW AMM.SDR SWIA201333854Seat Track · corrodedLT SIDE SEAT TRACK AT FS477.4 - 573.0 REQUIRES REPLACEMENT. C-CHECK REPLACED LT SIDE SEAT TRACK AT FS 477.4 - 573.0 IAW AMM.SDR SWIA201333853Seat Track · corrodedLT SIDE SEAT TRACK AT FS 379.0 - 477.4 REQUIRES REPLACEMENT. C-CHECK REPLACED LT SIDE SEAT TRACK AT FS 379.0 - 477.4 IAW AMM.SDR SWIA201333852Seat Track · corrodedLT FLOOR SEAT TRACK AT FS 374.0 - 485.0 REQUIRES REPLACEMENT. C-CHECK REPLACED LT FLOOR SEAT TRACK FS 374.0 - 485.0 IAW AMM.SDR SWIA201333851Seat Track · corrodedLT FLOOR SEAT TRACK AT FS 485.0 - 581.0 REQUIRES REPLACEMENT. C-CHECK REPLACED LT FLOOR SEAT TRACK AT FS 485.0 TO 581.0 IAW AMM.SDR SWIA201333850Seat Track · corrodedLT FLOOR SEAT TRACK AT FS 581.0 - 683.0 REQUIRES REPLACEMENT. C-CHECK REPLACED LT FLOOR SEAT TRACK AT FS 581.0 - 683.0 IAW AMM.SDR SWIA201333864Skin · chafedDURING C-CHECK, CHAFE ON LOWER SKIN AT FS 980. REPAIRED CHAFE ON LOWER SKIN AT FS 980 IAW REO.SDR SWIA201333865Lever · chafedC-CHECK, PAX DOOR FWD, PULL IN LEVER CHAFED. BLENDED DAMAGE ON PAX DOOR IAW REO.SDR SWIA201333867Floorbeam · corrodedFS 280 FLOORBEAM IS CORRODED BEYOND LIMITS REPLACEMENT REQUIRED. C-CHECK REPLACED FS 280.0 CROSSBEAM IAW REO.SDR SWIA201333866Skin · corrodedMAIN AVIONICS COMPARTMENT DOOR CUT OUT SURROUND SKIN HAS FRETTING CORROSION ON INNER SKIN SURFACE. C-CHECK REPAIRED IAW REO.SDR SWIA201333063Light · inoperativeNR 4 AND NR 5 OVERHEAD EMERGENCY LIGHTS ARE BURNED OUT. (FLT 5527) RELAMPED EMERGENCY LIGHTS.SDR SWIA201332730Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT DOES NOT ILLUMINATE. (FLT 6476) REPLACED NR 2 EMERGENCY POD LIGHT.SDR SWIA201332554Light · inoperativeEMERGENCY EXIT ROW LIGHT IN ROW 12 A AND B HAS A BULB OUT. (FLT 5159) RELAMPED EMERGENCY LIGHT.SDR SWIA201232151Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT BURNED OUT. (FLT 5648) RELAMPED EMERGENCY LIGHT.SDR SWIA201230657Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6239) RELAMPED EMERGENCY LIGHT.SDR SWIA201230611Light · inoperativeSECOND FROM LAST OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230452Sign · inoperativeMID CABIN OVERHEAD FLIGHT ATTENDANT EMERGENCY EXIT SIGN LIGHTS ARE OUT. (FLT 5297) REPLACED OVERHEAD EMERGENCY EXIT SIGN ASSEMBLY MID CABIN IN REF TO AMM.SDR SWIA201230382Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230401Cable · failedPASSENGER DOOR IS HARD TO OPEN FROM EXTERIOR AND WILL NOT POP OUT FROM FUSELAGE CUTOUT. (SERVICE) REPLACED THE PASSENGER DOOR AFT GAS SPRING AFT CABLE. ADJUSTED GAS SPRING CABLE ANCHOR IN REF TO AMM.SDR SWIA201230020Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5428) RELAMPED EMERGENCY LIGHT.SDR SWIA201229781Latch · obstructedAFT FLIGHT ATTENDANT JUMPSEAT SEAT BELT BUCKLE LATCH IS STICKING. (FLT 6261) CLEANED DEBRIS.SDR SWIA201229364Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5192) RELAMPED EMERGENCY LIGHT.SDR SWIA201229282Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6397) RELAMPED EMERGENCY LIGHT.SDR SWIA201128841Skin · chafedLEFT AILERON UPPER LEADING EDGE CHAFED. (C-CHECK) REPLACE LEFT AILERON UPPER LEADING EDGE PER SRM.SDR SWIA201128610Battery Pack · dischargedAFT 2 OVERHEAD EMERGENCY LIGHTS ARE OUT. (SERVICE) REPLACED NR 4 ELBP & BATTERY CHARGER. P/N:AD-2013-1A S/N OFF:75713SDR SWIA201128611Light · inoperativeNR 5 CEILING EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201128567Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5350) RELAMPED EMERGENCY LIGHT.SDR SWIA201128430Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4248) RELAMPED EMERGENCY LIGHT.SDR SWIA201128297Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5785) RELAMPED EMERGENCY LIGHT.SDR SWIA201127312Relay · failedEMERGENCY EXIT LIGHTS CYCLE ON AND THEN OFF CONTINUOUSLY WHEN IN THE 'AUTO' POSITION. (FLT 2059) REPLACED RELAY K135 IN JB11.SDR SWIA201126483Sensor · out of adjustGEAR DISAGREE WARNINGS. (FLT 6497) ADJUSTED LEFT NLG WEIGHT ON WHEELS SENSOR.SDR SWIA201125508Roller · lack of lubeMAIN CABIN DOOR DIFFICULT TO OPEN. (FLT 6940) CLEANED AND LUBED MAIN CABIN DOOR ROLLERS.SDR SWIA201024794Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT INOPERATIVE. (FLT 6093) RELAMPED EMERGENCY LIGHT.SDR SWIA201024506Light · inoperativeSECOND TO LAST EMERGENCY CEILING LIGHT INOP. (FLT 6115) RELAMPED EMERGENCY LIGHT.SDR SWIA201024507Printed Ckt Board · defectiveEMERGENCY LIGHT ILLUMINATING INTERMITTENTLY. (FLT 6573) REPLACED PCB5 ON JB11 PER AMM.SDR SWIA201024322Crossbeam · corrodedFS 280 CROSSBEAM CORRODED AND CRACKED. (C CHECK) BEAM REPLACED PER REO.SDR SWIA201024090Light · inoperativeNR 5 EMERGENCY EXIT LIGHT INOP. (FLT 5934) RELAMPED EMERGENCY LIGHT.
Back to N746SK