N697SW, cancelled Oct 5, 2019
Service difficulty reports · 430
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 = 'N697SW' AND deregistration_id = 'N697SW-2019-10-05' 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 = 'N697SW' AND deregistration_id = 'N697SW-2019-10-05' 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 SWAA075005Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 730C, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA075004Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 28L. REPAIRED SKIN PER SWA EA.SDR SWAA074084Battery Pack · dischargedDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA073207Strip · wornDURING SCHEDULED C2 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT ROW 1 ABC. R&R STRIP PER MM.SDR SWAA073208Casting · wornDURING SCHEDULED C2 CHECK, FOUND RT WING NR 5 SPOILER OUTBOARD ACTUATOR CASTING WORN. REPAIRED SPOILER CASTING PER SWA EA.SDR SWAA072740Lens · missingLEFT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LIGHT LENS PER MM.SDR SWAA072646Lens · missingDURING SCHEDULED RON CHECK, FOUND BULL NOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 8 DEF. INSTALLED LENS PER MM.SDR SWAA071494Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 759, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA071493Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503C, STR 11R. REPAIRED SKIN PER SWA EA.SDR SWAA071495Sign · crackedDURING SCHEDULED C1 CHECK, FOUND FWD CABIN EMERGENCY EXIT SIGN LENS CRACKED. REMOVED AND REPLACED EMERGENCY EXIT SIGN PER MM.SDR SWAA071210Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND BULL NOSE EMERGENCY EXIT LIGHT INOP AT ROW 21 DEF. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA065121Light · inoperativeLEFT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA064637Flap · delaminatedDURING SCHEDULED C4 CHECK, FOUND RIGHT WING INBOARD T/E AFT FLAP DELAMINATED AT LOWER OUTBOARD CORNER. REMOVED AND REPLACED INBOARD AFT FLAP PER MM.SDR SWAA064636Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 739E, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA064635Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 730E, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA064634Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 729D, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA064633Skin · crackedDURING SCHEDULED C4 CHECK, FOUND AFT CARGO DOOR SKIN CRACKED AT DOOR HANDLE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA063949Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 517D, STR 12L. REPAIRED SKIN PER SRM.SDR SWAA063948Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503D TO BS 506D, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA063947Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER CUTOUT BS 430, LBL 4. REPAIRED SKIN PER SRM.SDR SWAA063923Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT STR 24R. REMOVED AND REPLACED FRAME SECTION PER ACO.SDR SWAA063905Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA062979Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA062978Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 805, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA061610Skin · crackedDURING SCHEDULED C2 CHECK, FOUND RT WING NR 5 SLAT CRACKED AT LOWER L/E. REPAIRED NR 5 SLAT PER SRM.SDR SWAA061609Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND RT WING NR 4 SLAT DELAMINATED. REMOVED AND REPLACED NR 4 SLAT PER MM.SDR SWAA060756Lens · missingBULLNOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 17 ABC. INSTALLED LENS PER MM.SDR SWAA060437Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA060436Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 947.5, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA060435Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 19L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060434Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 380, STR 15L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA053330Door Frame · crackedDURING SCHEDULED C4 CHECK, FOUND AFT CARGO DOOR LOWER FRAME CRACKED AT STOP FITTING CUT OUT. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA053047Link · brokenNR 3 L/E FLAP TRANSIT INDICATOR LIGHT ILLUMINATED. FOUND BROKEN ATTACH LINK ASSY. REMOVED AND REPLACED NR 3 L/E FLAP ATTACH LINK ASSY PER MM.SDR SWAA052492Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. REPOSITIONED SLIDE PER MM.SDR SWAA052336Slide · dislodgedL1 DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED SLIDE PER MM.SDR SWAA052024Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA051418Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD LT EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA051120Pressure Panel · crackedDURING SCHEDULED 1/4D CHECK, FOUND 2 EA BEADED PRESSURE WEB CRACKS AT BS 664, LBL 31 & LBL 38. REPAIRED WEB PER SWA EA.SDR SWAA051119Lens · looseDURING SCHEDULED 1/4D CHECK, FOUND EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 13 ABC. SECURED LENS PER MM.SDR SWAA051097Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR CUTOUT, LOWER FWD CORNER. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA051073Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D + 2, STR 12R. REPAIRED SKIN PER SWA EA.SDR SWAA051072Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON SHEAR TIE AT BS 520, STR 28R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA051071Stringer Clip · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 727, BL 0. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051070Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND 2 EA CRACKS AT BS 1016 BULKHEAD WEB DOME CAP, 12 O'CLOCK POSITION. REPAIRED PER SWA EA.SDR SWAA050751Skin · crackedDURING WALK-AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 510, STR 16R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA050381Battery · inoperativeDURING SCHEDULED A2 CHECK, FOUND FWD SERVICE DOOR EMERGENCY EXIT LOWER LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA050208Skin · chafedDURING SCHEDULED A2 CHECK, FOUND UPPER FUSELAGE SKIN BETWEEN BS 867 AND 887, AT DORSAL FIN, CHAFED. REPAIRED SKIN PER EA.SDR SWAA043664Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 957, STRINGER 21L, CRACKED. REPAIRED SKIN SECTION PER EA.SDR SWAA043648Lamp · inoperativeDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA043363Skin · crackedDURING SCHEDULED A2 CHECK, FOUND 3 EACH FUSELAGE SKIN CRACKS BETWEEN BS 727E + 13 AND BS 790, STRINGER 18L. REPAIRED SKIN SECTIONS PER SRM.
Back to N697SW, cancelled Oct 5, 2019