N335SW, cancelled Jan 3, 2018
Service difficulty reports · 389
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 = 'N335SW' AND deregistration_id = 'N335SW-2018-01-03' 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 = 'N335SW' AND deregistration_id = 'N335SW-2018-01-03' 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 SWAA117659Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 9L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA116966Flap · delaminatedRIGHT WING I/B TRAILING EDGE FLAP DELAMINATED. REMOVED AND REPLACED T/E FLAP IAW MM.SDR SWAA116302Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND RT EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA116097Structure · wornDURING SCHEDULED HC2 CHECK, FOUND LT WING NR 2 SLAT CAN WORN. REPAIRED SLAT CAN PER EA.SDR SWAA115812Battery · dischargedFWD ENTRY EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA115440Smoke Detector · faultyDIVERSION - AT 37,000 FEET AFT CARGO FIRE LIGHT ILLUMINATED. AFTER CLEARING MASTER FIRE WARNING, LIGHT WENT OUT, SYSTEM TEST OK. UPON DISCHARGING FIRE FIRE BOTTLES, AFT CARGO FIRE LIGHT RE-ILLUMINATED, THEN WHEN OUT. INSPECTED FWD AND AFT CARGO COMPARTMENTSDR SWAA115068Hinge Fitting · brokenDURING SCHEDULED MV2 CHECK, FOUND RT WING I/B GROUND SPOILER O/B HINGE FITTING BROKEN. REMOVED AND REPLACED SPOILER PANEL PER MM.SDR SWAA114924Lens · looseL1 DOOR EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LENS PER MM.SDR SWAA113373Light · inoperativeFWD EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA113371Skin · crackedDURING SCHEDULED SPV CHECK FOUND, LEFT WING NR 3 SLAT CRACKED ON THE LWR SKIN 36 INCHES I/B FROM O/D END. REPAIRED SKIN IAW SRM.SDR SWAA111581Lens · looseFWD F/A JUMPSEAT EMERGENCY EXIT LIGHT COVER LOOSE. REMOVED AND REPLACED EMERGENCY LIGHT LENS.SDR SWAA107823Slide · looseR2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA107342Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND LT OVERWING LOWER EMERGENCY EXIT LIGHT BULB INOP. RELAMPED PER MM.SDR SWAA106393Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT FWD EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA104931Control Box · defectiveNR 1 ENGINE THRUST LEVER WILL NOT MOVE. REMOVED AND REPLACED NR 1 ENGINE STRUT DRUM CONTROL BOX AND THRUST CONTROL PUSH-PULL CABLE PER MM.SDR SWAA104947Charger · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER ASSY PER MM.SDR SWAA104946Charger · inoperativeR2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA104949Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA104948Battery · dischargedDURING SCHEDULED MV2 CHECK, FOUND AFT EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA104101Lens · brokenL1 DOOR OVERHEAD EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA101915Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND FWD EMERGENCY EXIT SIGN INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA101838Outflow Valve · faultyDURING DESCENT THROUGH 7000FT, OUTFLOW VALVE WENT FULL OPEN WITH LOSS OF CABIN PRESSURE. NO AUTO FAIL LIGHT. REMOVED AND REPLACED AFT OUTFLOW VALVE PER MM.SDR SWAA100955Lens · brokenL1 DOOR LOWER EMERGENCY EXIT DOOR LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA100476Lens · looseDURING SCHEDULED MV1 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA097455Lens · missingDURING SCHEDULED 2HC1 CHECK, FOUND LT OVERHEAD EMERGENCY EXIT LIGHT LENS MISSING AT ROW 13. INSTALLED LENS PER MM.SDR SWAA097454Cover · crackedDURING SCHEDULED 2HC1 CHECK, FOUND RT EEPLS COVER CRACKED AT ROW 12. REMOVED AND REPLACED COVER PER MM.SDR SWAA097297Lens · looseDURING SCHEDULED SPV CHECK, FOUND BULLNOSE EMERGENCY LIGHT LENS LOOSE AT ROW 23 DEF. SECURED LENS PER MM.SDR SWAA097296Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 420, STR 1 TO STR 2L. REPAIRED SKIN PER ER.SDR SWAA097241Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACKS PER MM.SDR SWAA097107Structure · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE CHORD CORRODED AT BS 227, LBL 5, WL 172. REPAIRED CHORD PER ER.SDR SWAA097106Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA097105Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA097104Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA097103Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA097039Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA096871Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 509C, IN SKIN LAP LOWER ROW. REPAIRED SKIN PER ER.SDR SWAA096870Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 480, STR 14R. REPAIRED FRAME PER EA.SDR SWAA096785Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FWD BULKHEAD CENTER FRAME FWD SIDE CORRODED AT BS 227, BL 0. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA096763Shear Tie · brokenDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE BROKEN AT BS 380, BETWEEN STR 18R TO STR 19R. REMOVED AND REPLACED SHEAR TIE SRM.SDR SWAA096762Shear Tie · brokenDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE BROKEN AT BS 520, BETWEEN STR 23R TO STR 24R. REMOVED AND REPLACED SHEAR TIE SRM.SDR SWAA096761Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED CLIP PER BAC DWG.SDR SWAA096760Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 707 TO BS 713, BL 0. REPAIRED WEB PER ER.SDR SWAA096729Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096721Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 19L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096551Stringer Clip · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CORRODED AT BS 360, STR 21L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096550Web · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR NR 4 WEB CRACKED AT AFT END. REMOVED AND REPLACED WEB PER BAC DWG.SDR SWAA096549Stringer Splice · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CORRODED AT BS 910, STR 24L. REMOVED AND REPLACED SPLICE PER BAC DWG.SDR SWAA096532Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096531Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 21L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096466Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 43. REPAIRED BEAM PER ER.
Back to N335SW, cancelled Jan 3, 2018