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 SWAA112330Bulkhead · crackedDURING SCHEDULED 26Y CHECK, FOUND RT AFT BULKHEAD WEB CRACKED AT BS 663.75. REPAIRED WEB PER EA.SDR SWAA112329Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, RBL 24.5. REPAIRED BEAM PER EA.SDR SWAA2012100408281Bulkhead · crackedRIGHT WING CENTER SECTION AFT BULKHEAD BS 663.75 CRACKED. REPAIRED BULKHEAD PER EA.SDR SWAA111428Light · brokenDURING SCHEDULED 2HC1 CHECK, FOUND RT EEPLS BROKEN AT ROW 8. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA110199Cover · missingRT OVERHEAD EMERGENCY EXIT LIGHT COVER MISSING AT ROW 12. REMOVED AND REPLACED COVER PER MM.SDR SWAA106019Actuator · brokenDURING SCHEDULED MV2 CHECK, FOUND RT WING NR 5 GROUND SPOILER BROKEN. REMOVED AND REPLACED SPOILER ACTUATOR PER MM.SDR SWAA105742Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, STR 21L. REPAIRED FRAME PER SRM.SDR SWAA105729Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 15L. REPAIRED SPLICE PER SRM.SDR SWAA105624Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA105549Support Angle · crackedDURING SCHEDULED SPV CHECK, FOUND RT WING UPPER T/E SUPPORT ANGLE CRACKED. REMOVED AND REPLACED ANGLE PER SRM AND BAC DWG.SDR SWAA104516Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 519, STR 28L. REPAIRED SKIN PER EA.SDR SWAA104515Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 585.0, STR 10L. REPAIRED SKIN PER EA.SDR SWAA104514Flap · delaminatedDURING SCHEDULED HC2 CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA104513Flap · delaminatedDURING SCHEDULED HC2 CHECK, FOUND RT WING O/B TRAILING EDGE FLAP DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA104297Spoiler · delaminatedDURING SCHEDULED MV2 CHECK, FOUND LT WING NR 3 FLIGHT SPOILER DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA100376Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA097178Slide · out of positionL1 DOOR EVAC SLIDE FELL OUT OF CONTAINER. DID NO DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA096702Light · looseDURING SCHEDULED CV CHECK, FOUND RT EMERGENCY EXIT LOWER LIGHT LOOSE. SECURED PER MM.SDR SWAA095769Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT FWD EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA094451Skin · corrodedDURING SCHEDULED 24Y CHECK, FOUND SKIN CORRODED AT BS 988, STR 27L. REPAIRED SKIN PER SRM.SDR SWAA094305Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 400, BETWEEN STR 14L TO STR 13L. REMOVED AND REPLACED SHEAR TIE PER ER.SDR SWAA094304Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 927, BETWEEN STR 27L TO STR 27R. REPAIRED SHEAR TIE PER ER.SDR SWAA094083Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 500, BETWEEN STR 28L AND 28R. REPAIRED SHEAR TIE PER SRM.SDR SWAA093966Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 907, BETWEEN STR 27L TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA093732Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 1016, BETWEEN STR 26L TO STR 27L. REPAIRED SKIN PER SRM.SDR SWAA093570Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND RT WING NR 6 SLAT I/B WEDGE LOWER SKIN DELAMINATED ON I/B END. REPAIRED WEDGE PER SRM.SDR SWAA093328Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500B, BETWEEN STR 26L TO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA093326Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 867, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA093303Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, BETWEEN STR 26L TO STR 27L. REPAIRED SHEAR TIE PER SR.SDR SWAA093293Hook · looseDURING SCHEDULED 24Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR HOOKS LOOSE. SECURED HOOKS PER SRM.SDR SWAA093292Hook · looseDURING SCHEDULED 24Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR HOOKS LOOSE. SECURED HOOKS PER SRM.SDR SWAA093243Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND STUB BEAM SUPPORT ANGLE CRACKED AT BS 639, LBL 46, WL 207. R&R STUB BEAM PER SRM.SDR SWAA091825Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 305, STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA086665Lens · missingDURING SCHEDULED MV2 CHECK, FOUND OVERHEAD EMERGECY EXIT LIGHT LENS MISSING AT ROW 19. INSTALLED LENS PER MM.SDR SWAA086327Lens · missingDURING SCHEDULED MV2 CHECK, FOUND BULLNOSE LIGHT LENS MISSING AT ROW 4. REPLACED LENS PER MM.SDR SWAA086157Slide · out of adjustDURING SCHEDULED SPV CHECK, FOUND R2 DOOR SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA084477Battery Pack · dischargedDURING SCHEDULED SPV CHECK, AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA082780Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT SERVICE DOOR CUTOUT UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA082791Structure · crackedDURING SCHEDULED HC2 CHECK, FOUND LT WING NR 2 L/E SLAT CRACKED AT LOWER INBOARD END. REPAIRED SLAT PER SWA EA.SDR SWAA082781Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA081658Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND LT AFT CABIN EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA080307Bar · corrodedDURING SCHEDULED MV2 CHECK, FOUND RT WING MLG STABILIZER BAR CORRODED. REMOVED AND REPLACED STABILIZER BAR PER MM.SDR SWAA075727Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA073991Hinge · wornDURING SCHEDULED CABIN VISIT CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 TAB HINGE PER SWA EA.SDR SWAA073967Hinge · wornDURING SCHEDULED CABIN VISIT, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 TAB HINGE ASSY PER SWA EA.SDR SWAA072521Lamp · inoperativeDURING SCHEDULED MV2 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA072522Lamp · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA072304Glowstrip · wornDURING SCHEDULED BRDG CHECK, FOUND RIGHT AFT CABIN EELS PHOTOLUMINESCENT STRIP WORN. REMOVED AND REPLACED EEPLS STRIP PER MM.SDR SWAA072303Glowstrip · wornDURING SCHEDULED BRDG CHECK, FOUND RIGHT MID CABIN EELS PHOTOLUMINESCENT STRIP WORN. REMOVED AND REPLACED EEPLS STRIP PER MM.SDR SWAA072040Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER 26R CORRODED BETWEEN BS 1006 AND BS 1016. REMOVED AND REPLACED STRINGER PER SRM.
Back to N694SW, cancelled Mar 16, 2018