N635SW, cancelled Nov 28, 2018
Service difficulty reports · 319
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 = 'N635SW' AND deregistration_id = 'N635SW-2018-11-28' 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 = 'N635SW' AND deregistration_id = 'N635SW-2018-11-28' 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 SWAA061571Skin · delaminatedDURING SCHEDULED 10Y CHECK, FOUND RT WING T/E INBOARD FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA061559Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA061558Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED BS 827, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA061557Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA061556Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA061555Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 9L. REPAIRED FRAME SECTION PER SRM.SDR SWAA061554Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 9R. REPAIRED FRAME SECTION PER SRM.SDR SWAA061553Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 9R. REPAIRED FRAME SECTION PER SRM.SDR SWAA061552Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 60, WL 200. REPAIRED FRAME SECTION PER ER.SDR SWAA061551Stringer Clip · crackedDURING SCHEDULED 10Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 13R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA061550Stringer Clip · crackedDURING SCHEDULED 10Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA061549Stringer Clip · crackedDURING SCHEDULED 10Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA061548Door Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND R1 DOOR FRAME CUTOUT CRACKED AT BS 296.5, STR 6R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA061529Stringer Clip · crackedDURING SCHEDULED 10Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA053382Bearing · bindingSHUDDERING AND BINDING FELT IN AILERONS DURING FLIGHT CONTROL CHECK. REMOVED AND REPLACED AILERON CENTERING MECHANISM ROLLER BEARING IAW MM.SDR SWAA052938Structure · corrodedDURING SCHEDULED C3 CHECK, FOUND COCKPIT FLOOR Z-CHORD CORRODED AT BS 270, BETWEEN LBL 54 TO RBL 54. MX FERRY TO DALLAS. REMOVED AND REPLACED Z-CHORD PER SRM.SDR SWAA052894Bracket · looseDURING SCHEDULED C3 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FLOOR BRACKETS LOOSE. SECURED BRACKETS PER MM.SDR SWAA052893Lens · looseDURING SCHEDULED C3 CHECK, FOUND FWD GALLEY EMERGENCY EXIT SIGN LENS LOOSE. SECURED LENS PER MM.SDR SWAA052892Fuse · failedDURING SCHEDULED C3 CHECK, FOUND RT AFT EXTERIOR EMERGENCY LIGHT INOP. REMOVED & REPLACED BATTERY CHARGER FUSE PER MM.SDR SWAA051806Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA051562Solenoid · faultyAIR TURNBACK, LANDING GEAR HANDLE WOULD NOT RAISE PAST OFF POSITION. CYCLED LANDING GEARS AND SAME PROBLEM. USED GEAR LEVER OVERRIDE TRIGGER TO RAISE GEARS. REMOVED AND REPLACED LANDING GEAR HANDLE LOCK OUT SOLENOID PER MM.SDR SWAA043399Keelbeam · crackedDURING SCHEDULED C4 CHECK, FOUND LT KEELBEAM WEB CRACKED BETWEEN BS 700 TO BS 710. REPAIRED KEELBEAM PER SRM.SDR SWAA041439Hydraulic Line · leakingAIR TURNBACK, NR 2 ENGINE B-HYDRAULIC PUMP LOW PRESSURE LIGHT ILLUMINATED AND B-SYSTEM QUANTITY DROPPED TO 1/4 FULL. REMOVED AND REPLACED NR 2 ENGINE B-SYSTEM HYDRAULIC SUPPLY LINE PER MM.SDR SWAA041430Hydraulic Line · leakingAIR TURNBACK, DECLARED EMERGENCY. DURING CLIMB NR 2 ENGINE HYD PUMP LOW PRESSURE LIGHT ILLUMINATED, ACCOMPANIED BY HYDRAULIC FLUID QUANTITY INDICATING 1/3 FULL. REMOVED AND REPLACED NR 2 ENGINE HYDRAULIC PRESSURE LINE PER MM.SDR SWAA040649Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040669Slide · out of adjustR1 DOOR EVACUATION SLIDE OUT OF ADJUST. REPOSITIONED SLIDE PER MM.SDR SWAA040506Fitting · corrodedDURING SCHEDULED RON CHECK, FOUND RT MLG FORWARD HANGER FITTING PITTED. REPAIRED HANGER FITTING PER EA.SDR SWAA040330Hook · shearedDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EVAC SLIDE GIRT BAR HOOK FASTENER SHEARED. REMOVED AND REPLACED RETAINER HOOK PER MM.SDR SWAA040329Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040145Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040131Slide · out of adjustR1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA032248Wedge · delaminatedDURING SCHEDULED C4 CHECK, FOUND NR 2 L/E SLAT T/E WEDGE DELAMINATED AT OUTBD END. REPAIRED WEDGE PER SRM.SDR SWAA032069Indicator · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA031135Indicator · out of positionFWD SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA030709Lens · crackedDURING SCHEDULED C2 CHECK, FOUND CEILING EMERGENCY EXIT LIGHT LENS CRACKED IN AFT CABIN. REMOVED AND REPLACED LENS PER MM.SDR SWAA030708Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT INBD T/E FOREFLAP DELAMINATED ON UPPER SURFACE. REMOVED AND REPLACED LEFT INBD FOREFLAP PER MM.SDR SWAA020955Rod End · wornDURING SCHEDULED SERVICE CHECK, SWA SI 11111-55, ELEVATOR TABS FAILED FREE PLAY INSPECTION. REMOVED AND REPLACED ROD END ASSY'S ON BOTH TABS.SDR SWAA020549Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA011929Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT ENTRY DOOR FWD FRAME CRACKED AT CUTOUT FOR #2 STOP. REPAIRED FRAME PER SRM.SDR SWAA011467Light · inoperativeDURING SCHEDULED PMC CHECK, FOUND TWO EEPLS END CAPS MISSING, AND TWO EEPLS LIGHTS INOP. INSTALLED END CAPS AND RELAMPED EEPLS LIGHTS PER MM.SDR SWAA011362Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND EEPLS INOP AT FWD CABIN. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA011287Light · inoperativeEEPLS INOP AT ROWS 4 TO 7 AND LOOSE AT ROW 9. REPAIRED AND RESECURED EEPLS PER MM.SDR SWAA011261Cover · missingEEPLS TRACK COVER MISSING ROWS 9&15. REPLACED COVERS PER MM.SDR SWAA011224Light · inoperativeEEPLS INOP AT ROW 14. REPAIRED EEPLS PER MM.SDR SWAA011007Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.SDR SWAA010356Lens · missingDURING SCHEDULED C2 CHECK, FOUND EEPLS MISSING RED LENS AT REAR SECTION OF CABIN. INSTALLED TRACK COVER ASSY PER MM.SDR SWAA010016Cover · looseEEPLS TRACK COVER LOOSE AT ROW 15. SECURED TRACK COVER PER MM.SDR SWAA002713Cover · missingEEPLS TRACK COVER MISSING AT MID CABIN. REPLACED TRACK COVER PER MM.SDR SWAA002571Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REPOSITIONED EVAC SLIDE ASSY PER MM.SDR SWAA002470Wire · disconnectedEEPLS WIRES EXPOSED & DISCONNECTED AT ROW 17. RECONNECTED & STOWED WIRES PER MM.
Back to N635SW, cancelled Nov 28, 2018