N694SW, cancelled Mar 16, 2018
Service difficulty reports · 479
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 = 'N694SW' AND deregistration_id = 'N694SW-2018-03-16' 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 = 'N694SW' AND deregistration_id = 'N694SW-2018-03-16' 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 SWAA2012091707674Shear Tie · corrodedSHEAR TIE CORRODED AT BS 360, BETWEEN STR 26L AND STR 27L. REPAIRED SHEAR TIE PER ER AND EA.SDR SWAA2012091707673Shear Tie · corrodedSHEAR TIE CORRODED AT BS 380, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER ER AND EA.SDR SWAA2012083007189Stringer · corrodedSTRINGER CORRODED AT BS 907, STR 26L. REPAIRED STRINGER PER SRM.SDR SWAA2012100108117Frame · corrodedFRAME CORRODED AT BS 867, STR 27R. REPAIRED FRAME PER ER AND EA.SDR SWAA2012091007473Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500C, STR 23L. REMOVED & REPLACED CLIP IAW SRM & DWG.SDR SWAA2012082206889Frame · corrodedFRAME CORRODED AT BS 727E O/B OF RIGHT KEEL BEAM AFT SIDE. REPAIRED FRAME PER SRM & DWG.SDR SWAA2012091807729Floorbeam · crackedFLOORBEAM UPPER CHORD CRACKED AT BS 947, LBL 53. REPAIRED CHORD PER ER AND EA.SDR SWAA2012091707672Frame · crackedFRAME CRACKED AT BS 663, STR 3R. REPAIRED FRAME PER ER AND EA.SDR SWAA2012091307574Floorbeam · corrodedFLOORBEAM CORRODED AT BS 1006, LBL 10. REPAIRED BEAM PER ER AND EA.SDR SWAA2012090407296Strap · corrodedSPLICE STRAP CORRODED BETWEEN BS 1006 TO BS 1028, LBL 3. REMOVED AND REPLACED STRAP IAW SRM & BOEING DWG.SDR SWAA2012090407295Frame · crackedFRAME CRACKED AT BS 947, STR 18L. REMOVED AND REPLACED FRAME PER DWG AND SRM.SDR SWAA2012083007188Stringer · corrodedSTRINGER CORRODED BETWEEN BS 270 TO BS 277, STR 22R. REPAIRED STRINGER PER SRM.SDR SWAA2012092708075Skin · crackedFUSELAGE SKIN CRACKED AT R1 DOOR CUTOUT AT FWD LOWER CORNER. REPAIRED SKIN PER ER AND EA.SDR SWAA2012092708074Floorbeam · crackedLONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 706 TO BS 709, RBL 25. REPAIRED WEB PER ER AND EA.SDR SWAA2012092407925Attach Angle · corrodedRIGHT CREASE BEAM WEB ATTACH ANGLE CORRODED AT BS 291, STR 17R. REMOVED AND REPLACED ANGLE PER SRM AND DWG.SDR SWAA2012091807728Floorbeam · crackedLONGITUDINAL FLOORBEAM VERTICAL WEB CRACKED AT BS 660, WL 207. REPAIRED BEAM PER ER AND EA.SDR SWAA2012090507367Floorbeam · crackedLONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 706 TO BS 709, LBL 25. REPAIRED WEB PER ER AND EA.SDR SWAA2012090407294Support Angle · corrodedFWD ENTRY DOOR THRESHOLD O/B "Z" SUPPORT ANGLE CORRODED. REMOVED AND REPLACED "Z" SUPPORT ANGLE PER DWG & SRM.SDR SWAA2012090407293Support Angle · corrodedFORWARD ENTRY DOOR THRESHOLD I/B Z-SUPPORT ANGLE CORRODED. REMOVED AND REPLACED Z-ANGLE IAW SRM.SDR SWAA2012081706770Attach Angle · crackedVERTICAL LONGITUDINAL FLOORBEAM ATTACH ANGLE CRACKED AT BS 727B, WL 207. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012082006841Structure · crackedRIGHT SIDE NOSE WHEEL WELL CRACKED AT BS 245, RBL 15. REPAIRED NOSE WHEEL WELL IAW SRM.SDR SWAA2012100108219Light · crackedR1 DOOR LOWER EMERGENCY EXIT LIGHT ASSEMBLY CRACKED. REMOVED AND REPLACED LIGHT ASSY PER AMM.SDR SWAA2012091107524Skin · corrodedFUSELAGE SKIN AT FORWARD LAV SERVICE DOOR CUTOUT LOWER EDGE CORRODED BETWEEN BS 268 TO BS 272, STR 22R. REMOVED AND REPLACED SKIN PER SRM AND DWG.SDR SWAA2012051804138Tee Fitting · corrodedFWD E/E DOOR AND NOSE LANDING GEAR WHEEL WELL CORRODED UNDER LEVELING COMPOUND. REPAIRED "T" CHORD IAW EA AND AMM.SDR SWAA2012050803740Fuse · leakingDURING CRUISE, SMELLED A FAINT ODOR OF CHLORINE. FLIGHT ATTENDANTS IN AFT GALLEY SMELLED IT STRONGLY & SAW IT WAS COMING FROM THE AFT GALLEY VENTS, DIVERTED AND DECLARED EMERGENCY. FLIGHT DECK CREW O2 WAS USED IN FLIGHT. FOUND NR 2 T/R FUSE ABOVE HEAT EXCSDR SWAA2012041103012Sign · looseRIGHT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA120621Spoiler · crackedDURING SCHEDULED 16Y CHECK, FOUND LT WING NR 4 GROUND SPOILER CRACKED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA120620Slide · out of positionDURING SCHEDULED CV CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.SDR SWAA120003Wire · exposedR2 DOOR EMERGENCY EXIT LIGHT WIRES EXPOSED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA117378Bulkhead · crackedDURING SCHEDULED 28Y CHECK, FOUND BULKHEAD CRACKED AT BS 1016, S23R. REPAIRED BULKHEAD PER EA.SDR SWAA117180Slat · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LT WING NR 2 SLAT DELAMINATED ON O/B AFT END. REMOVED AND REPLACED NR 2 SLAT PER MM.SDR SWAA117179Slat · wornDURING SCHEDULED HC2 CHECK, FOUND RT WING NR 5 L/E SLAT O/B SLAT CAN WORN. REMOVED AND REPLACED NR 5 SLAT CAN PER MM.SDR SWAA117178Slat · wornDURING SCHEDULED HC2 CHECK, FOUND RT WING NR 5 L/E SLAT I/B SLAT CAN WORN. REMOVED AND REPLACED NR 5 SLAT CAN PER MM.SDR SWAA117177Slat · wornDURING SCHEDULED HC2 CHECK, FOUND LT WING NR 2 L/E SLAT O/B SLAT CAN WORN. REMOVED AND REPLACED NR 2 SLAT PER MM.SDR SWAA116986Stringer Clip · crackedDURING SCHEDULED 28Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA116701Fitting · crackedDURING SCHEDULED SPV CHECK, FOUND LT WING NR 3 SLAT O/B AUX TRACK FITTING COMMON TO LOWER SKIN CRACKED. REPAIRED FITTING PER SRM.SDR SWAA116650Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT WING NR 1 SLAT LOWER T/E SKIN CRACKED AT I/B END. REPAIRED SKIN PER SRM.SDR SWAA116377Lens · crackedDURING SCHEDULED 28Y CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT LENS CRACKED AT ROW 12. REMOVED AND REPLACED LENS PER MM.SDR SWAA116287Lens · crackedDURING SCHEDULED 28Y CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT LENS CRACKED AT ROW 6. REMOVED AND REPLACED LENS PER MM.SDR SWAA115985Fuse · inoperativeDURING SCHEDULED MV3 CHECK, FOUND RT AFT EMERGENCY EXIT LIGHT FUSE INOP. REMOVED AND REPLACED FUSE PER MM.SDR SWAA115984Fuse · inoperativeDURING SCHEDULED MV3 CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT FUSE INOP. REMOVED AND REPLACED FUSE PER MM.SDR SWAA115455Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 685+3, STR 10R. REPAIRED SKIN IAW EA.SDR SWAA114408Pump · faultyDECLARED EMERGENCY -- FLASHING MASTER CAUTION FOR NR 1 ENGINE DRIVEN HYDRUALIC PUMP LOW PRESSURE LIGHT ILLUMINATED IN FLIGHT. A SYSTEM HYDRAULIC QUANTITY DROPPED TO 1/4. REMOVED AND REPLACED NR 1 ENGINE DRIVER HYDRAULIC PUMP PER MM.SDR SWAA113644Light · inoperativeDURING SCHEDULED MV2 CHECK FOUND, R2 DOOR EMERGENCY LIGHT BULB INOP. RELAMPED PER MM.SDR SWAA113643Light · inoperativeDURING SCHEDULED MV2 CHECK FOUND, L1 DOOR EMERGENCY LIGHT BULB INOP. RELAMPED PER MM.SDR SWAA112709Gasper Fan · faultyDECLARED EMERGENCY - FLIGHT ATTENDANT AND PASSENGER REPORTED,"BURNING ELECTRICAL" SMELL IN CABIN. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA112307Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND FLOORBEAM CRACKED AT BS 322, RBL 40. REPAIRED BEAM PER SRM.SDR SWAA112306Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND FLOORBEAM CRACKED AT BS 314, RBL 26. REPAIRED BEAM PER SRM.SDR SWAA112305Shear Tie · corrodedDURING SCHEDULED 26Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, BETWEEN RBL 10 TO RBL 14. REPAIRED SHEAR TIE PER SRM.SDR SWAA112304Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN RBL 10 TO RBL 14. REPAIRED FRAME PER SRM.
Back to N694SW, cancelled Mar 16, 2018