N709SK
Service difficulty reports · 207
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 = 'N709SK' 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 = 'N709SK' 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 SWIA201743712Intercostal · corrodedPAX DOOR INTERCOSTAL IS CORRODED. REMOVED AND REPLACED THE INTERCOSTAL IAW SRM. LEAK CHECKED GOOD.SDR SWIA201743711Intercostal · corrodedPAX DOOR INTERCOSTAL IS CORRODED. REPLACED THE INTERCOSTAL IAW SRM.SDR SWIA201743710Intercostal · corrodedINTERCOSTAL IS CORRODED. REPLACED THE INTERCOSTAL IAW SRM. PRESSURE CHECKED GOOD.SDR SWIA201743709Intercostal · corrodedPAX DOOR INTERCOSTAL IS CORRODED. REMOVED & INSTALLED A NEW PAX DOOR INTERCOSTAL IAW SRM. LEAK CHECKED GOOD.SDR SWIA201743708Intercostal · corrodedPAX DOOR INTERCOSTAL IS CORRODED. REPLACED THE INTERCOSTAL IAW SRM.SDR SWIA201743707Intercostal · corrodedPAX DOOR INTERCOSTAL IS CORRODED. REPLACED THE INTERCOSTAL IAW SRM. LEAK CHECKED GOOD.SDR SWIA201743706Intercostal · corrodedPAX DOOR INTERCOSTAL CORRODED. REPLACED THE INTERCOSTAL IAW SRM. PRESSURE CHECKED GOOD.SDR SWIA201743705Intercostal · corrodedPAX DOOR INTERCOSTAL IS CORRODED. REMOVED AND REPLACED THE INTERCOSTAL IAW AMM. LEAK CHECKED GOOD, NO DEFECTS NOTED.SDR SWIA201743704Stringer Splice · corrodedSTRINGER SPLICE 25R HAS CORROSION AT BS 333. REMOVED AND REPLACED THE STRINGER SPLICE IAW SRM. PRESSURE CHECKED GOOD, NO DEFECTS NOTED.SDR SWIA201743703Stringer · corrodedCORROSION FOUND ON STRINGER 25R, BS 333 - 349. REPLACED THE STRINGER IAW SRM.SDR SWIA201743702Stringer · corrodedCORROSION FOUND ON STRINGER 26R AT BS 333 - 349. REPLACED THE STRINGER IAW SRM. PRESSURE CHECKED GOOD.SDR SWIA201743701Frame · corrodedBS 349 FRAME HAS CORROSION. STRINGER 26R. REPLACED THE FRAME SECTION BETWEEN STRINGERS 24R AND 24L IAW SRM. PRESSURE CHECKED GOOD.SDR SWIA201743700Intercostal · corrodedFORWARD BS 364, STRINGER 27 INTERCOSTAL HAS CORROSION. REPLACED THE INTERCOSTAL IAW SRM.SDR SWIA201743699Stringer · corrodedFORWARD BS 364, STRINGER 26R INTERCOSTAL HAS CORROSION. REPLACED THE INTERCOSTAL IAW SRM.SDR SWIA201743698Web · corrodedPAX DOOR AFT WEB HAS CORROSION. REPLACED WITH A FACTORY NEW PART IAW SRM.SDR SWIA201743697Web · corrodedPAX DOOR FWD WEB HAS CORROSION. THE DOOR WEB WAS REPLACED WITH FACTORY NEW PART IAW SRM.SDR SWIA201743696Skin · dentedAFT STRUCTURE OF THE TAILCONE ON LOWER RIGHT SIDE DENTED AND GOUGED 14.75 INCHES L X .002 INCH DEEP AND DENT IS 8.125 INCH L X .250 INCH W X .025 INCH D. REPAIRED IAW REO.SDR SWIA201541392Floor Panel · crackedTRU BAY FLOOR CRACKED ON RT SIDE AT FS 193.00. REPAIRED RT TRU BAY FLOOR CRACK IAW STS EA.SDR SWIA201541391Skin · dentedDENT IN FUSELAGE FWD SKIN OF FS 202.75 AND ABOVE STRINGER 14R. REPAIRED UPPER RT SKIN FROM FS 202.75 TO FS 193.00, WL79.5 TO BL 0.0 IAW SRM AND STS EA.SDR SWIA201439045Flashlight · no testFWD F/A FLASHLIGHT FAILS PREFLIGHT INSPECTION. REPLACED FWD F/A FLASHLIGHT WITH A SERVICEABLE UNIT IAW AMM.SDR SWIA201438420Light · inoperativeMOST AFT CEILING EMERGENCY FLOOD LIGHT INOPERATIVE. R & R MOST AFT CEILING EMERGENCY FLOOD LIGHT IAW AMM.SDR SWIA201437819Light · inoperativeSIDE WALL LIGHT OVER LEFT REAR EMERGENCY EXIT INOPERATIVE. REPLACED SIDE WALL LIGHT.SDR SWIA201436307Door Frame · corrodedPAX DOOR FWD FORMER CORRODED OUT TO LIMITS, REQUIRES REPLACEMENT. C-CHECK REPLACED PAX DOOR'S FWD IAW SRM.SDR SWIA201436309Structure · crackedFS 274 AT LBL 9.0 IS CRACKED. C-CHECK REPAIR OF FS 274 AT LBL 9.0 IAW REO.SDR SWIA201436308Structure · crackedFS 274 AT RBL 9.0 IS CRACKED. C-CHECK REPAIRED FS 274 AT RBL 9.0 IAW REO.SDR SWIA201436310Transcowl · chafedUPPER RT TRANS COWL HAS CHAFE AT LATCH INNER SIDE DOUBLER. C-CHECK REPAIRED TRANS COWL INTERNAL DOUBLER IAW REO.SDR SWIA201436312Web · corrodedCORROSION FOUND ON LT FS 280 LOWER WEB. C-CHECK REPLACED LT FS 280 LOWER WEB IAW REO.SDR SWIA201436311Web · corrodedCORROSION FOUND ON RT FS 280 LOWER WEB. C-CHECK REPLACED RT FS 280 LOWER WEB IAW REO.SDR SWIA201436313Wire · chafedRT ENG INBD SIDE, IDG WIRE CHAFING ON BRACKET NEXT TO MAIN FUEL PUMP & 3 INCHES HIGHER ABOVE ADEL CLAMP, AGAINST WIRE SHEATHS. C-CHECK REPAIRED RT ENG INBD SIDE IDG WIRE ON LOCATION NEXT TO MAIN FUEL PUMP & SECOND CHAFED LOCATION 3 INCHES ABOVE ADEL CLAMP AGASDR SWIA201436314Hinge · gougedPAX DOOR PIANO HINGE, FUSELAGE SIDE HAS A GOUGE ON LAND NR 27. C-CHECK BLENDED GOUGE ON PAX DOOR PIANO HINGE, FUSELAGE SIDE LAND NR 27 IAW REO.SDR SWIA201335168Power Supply · failedTHREE EMERGENCY OVERHEAD LIGHTS & TWO EXIT SIGNS AT BULKHEAD DO NOT ILLUMINATE. FLT 5183 REPLACED EMERGENCY POWER SUPPLIES NR 1, NR 2, & NR 3. PN1 ON/OFF: 2013-1A, SN1ON: 104421, SN1OFF: 69411, PN2 ON/OFF: 2013-1A, SN2 ON: 43273, SN2 OFF: 100600, PN3 ONSDR SWIA201334734Battery · dischargedEMERGENCY LIGHTS TURN ON, THEN FADE OUT. FLT#5524 RECHARGED ALL EMERGENCY LIGHT BATTERIES IAW AMM.SDR SWIA201334690Fmu · failedWHILE ADVANCING POWER FOR TAKEOFF, N1 DID NOT INCREASE & ITT REACHED 1027° ON RT ENGINE. REJECTED THE TAKEOFF & RT ENGINE AUTO SHUTDOWN. RETURNED TO GATE. FLT#4963 REPLACED RT ENGINE FUEL METERING UNIT & OPERABILITY BLEED VALVE. PERFORMED BORESCOPE INSPECSDR SWIA201334440Light · inoperativeEMERGENCY LIGHT POD IS BURNED OUT. FLT#5221 RELAMPED.SDR SWIA201334125Light · inoperativeNR 6 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT#6449 RELAMPED.SDR SWIA201333711Plug · leakingOIL LEVEL DROPPED TO 17 PERCENT DURING FLIGHT. REPLACED SPLINE PLUG, RAN LT ENGINE AT 85 PERCENT N2 AND SHUTDOWN ENGINE TO CHECK FOR LEAKS. COMPLIED WITH LEAK CHECK OF LT ENGINE BOTH OIL AND HYD WITH NO LEAKS NOTED.SDR SWIA201333486Hydraulic System · failedHYD 2 LOW PRESSURE CAUTION PRESSURE WENT TO 0 ON FINAL. REPLACED THE EDP AND THE ACMP IAW AMM. REPLACED THE CASE DRAIN FILTERS AND THE ACMP PRESS MANIFOLD FILTER IAW AMM.SDR SWIA201333231Light · inoperativeLEFT FLOOR LEVEL EMERGENCY EXIT LIGHT IS BURNED OUT. (FLT 6535) RELAMPED EMERGENCY LIGHT.SDR SWIA201333066Light · inoperativeTWO LIGHTS BURNED OUT ON EMERGENCY EXIT ROW, LEFT SIDE BY SEATS A/B. (FLT 5651) RELAMPED EMERGENCY LIGHTS.SDR SWIA201332944Light · inoperativeTHE 12 A/B EMERGENCY EXIT LIGHT CLOSEST TO FLOOR IS BURNED OUT. (FLT 6269) RELAMPED EMERGENCY EXIT LIGHT.SDR SWIA201332853Relay · failedMAIN CABIN DOOR DIFFICULT TO OPEN, WINCH CABLE JAMMED. (FLT 6539) REPLACED MAIN CABIN DOOR ASSIST RELAY IAW AMM. P/N: 2R5206B S/N ON: A0528 P/N OFF: 601R94556-3 S/N OFF: A1090SDR SWIA201232471Battery Pack · not seatedEMERGENCY LIGHTS DO NOT ILLUMINATE. (FLT 6360) RESEATED ELBP 2.SDR SWIA201232418Wire · looseTWO ADJACENT CEILING EMERGENCY OVERHEAD LIGHTS INOPERATIVE. (FLT 6518) SECURED LOOSE WIRING AT OVERHEAD LIGHT 6A.SDR SWIA201232325Battery Pack · dischargedMULTIPLE EMERGENCY LIGHTS INOPERATIVE SEVERAL EXIT SIGNS AND SEVERAL OVERHEAD LIGHTS. (FLT 5220) REPLACED ALL 4 ELBPS. P/N: AD-2013-1A S/N ON: 69411 P/N OFF: 79590 P/N: AD-2013-1A S/N ON: 77256 P/N OFF: 82504 P/N: AD-2013-1A S/N ON: 43070 P/N OFF: 7SDR SWIA201232235Light · inoperativeLEFT OVERWING EMERGENCY LOWER EXIT SIGN HAS ONE BULB NOT WORKING. (FLT 6488) RELAMPED. EMERGENCY EXIT SIGN.SDR SWIA201231596Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5182) RELAMPED EMERGENCY LIGHT.SDR SWIA201231299Light · inoperativeFORWARD OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5162) RELAMPED EMERGENCY LIGHT.SDR SWIA201230431Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5347) RELAMPED EMERGENCY LIGHT.SDR SWIA201202149642Battery Pack · failedFLT 6485, EMERGENCY EXIT LOWER LIGHT BY 12 C&D IS OUT. REPLACED BATTERY PACK NR 3.SDR SWIA201229163Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.
Back to N709SK