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 SWAA120190Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 328, STR 20R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA120154Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947.5, STR 25R. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA120113Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM BS 727B, RBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA120063Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND LT SKIN CRACKED AT BS 211.8. REPAIRED SKIN IAW SRM.SDR SWAA120038Stringer Splice · crackedDURING SCHEDULED 24Y CHECK FOUND, STRINGER SPLICE CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA120037Stringer Splice · crackedDURING SCHEDULED 24Y CHECK FOUND, STRINGER SPLICE CHANNEL CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED CHANNEL IAW SRM AND DWG.SDR SWAA118613Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 22R. REMOVED AND REPLACE CLIP IAW SRM AND DWG.SDR SWAA118612Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 16L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118575Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 22R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118574Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 20L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118570Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 25R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA118726Tie Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND CRACKED TIE CLIP BS 500B, STR 25R FWD CARGO COMPATMENT. REPLACED TIE CLIP PER SRM.SDR SWAA118725Tie Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND CRACKED TIE CLIP BS 500C, STR 25R FWD CARGO COMPATMENT. REPLACED TIE CLIP PER SRM.SDR SWAA1201137Skin · corrodedSKIN CORRODED AT BS 517, STR 28L. REPAIRED SKIN PER EA.SDR SWAA116502Skin · delaminatedDURING SCHEDULED MV2 CHECK, FOUND LT WING I/B AFT FLAP DELAMINATED ON LOWER SURFACE IN MIDDLE OF FLAP. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA116380Lens · crackedDURING SCHEDULED 28Y CHECK, FOUND LT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT LENS CRACKED AT ROW 4. REMOVED AND REPLACED LENS PER MM.SDR SWAA114467Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA113937Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA113887Wedge · delaminatedDURING SCHEDULED HC2 CHECK, FOUND RT WING I/B MID FLAP CLOSE OUT WEDGE DELAMINATED. REMOVED AND REPLACED WEDGE PER MM.SDR SWAA113886Spoiler · delaminatedDURING SCHEDULED HC2 CHECK, FOUND RT WING I/B GROUND SPOILER DELAMINATED AT O/B TRAILING EDGE. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA113885Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 947.5, STR 14R. REPAIRED SKIN PER SRM.SDR SWAA111233Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA106507Light · damagedDURING SCHEDULED HC1 CHECK, FOUND LT EEPLS DAMAGED AT ROW 2. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA106506Light · damagedDURING SCHEDULED HC1 CHECK, FOUND RT EEPLS DAMAGED AT ROW 17. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA106505Light · damagedDURING SCHEDULED HC1 CHECK, FOUND LT EEPLS DAMAGED AT ROW 15. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA105752Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA103379Engine · failedDIVERSION/INFLIGHT SHUTDOWN/DECLARED EMERGENCY. NR 1 ENG FAILED DURING FLIGHT, FL 330 WITH VIBRATION OIL QUANTITY 0, EGT AT 970 DEGREES. REMOVED AND REPLACED NR 1 ENGINE PER MT.SDR SWAA101564Sign · looseRIGHT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA100902Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND SKIN CORRODED AT BS 227, RBL 2. REPAIRED SKIN PER AAR EA.SDR SWAA100879Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND RT EEPLS INOP AT ROW 8. RELAMPED PER MM.SDR SWAA100878Door Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND L1 DOOR FRAME CRACKED AT LOWER FWD CORNER. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA100804Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 942, STR 17L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100803Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 942, STR 18L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA100802Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 942, STR 18L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100756Rib · crackedDURING SCHEDULED 22Y CHECK, FOUND LT WING T/E RIB CRACKED AT WBL 415.93. REPAIRED RIB PER SRM.SDR SWAA100675Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, BBL 0. REPAIRED WEB PER SRM.SDR SWAA100647Strap · crackedDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR CUTOUT FRAME STRAP CRACKED AT STA 351. REMOVED AND REPLACED STRAP PER BAC DWG.SDR SWAA100630Door Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND L1 DOOR CUTOUT AFT SIDE FRAME CRACKED AT 6TH STOP FITTING CUTOUT. REPAIRED FRAME PER SRM.SDR SWAA100629Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR CUTOUT AT AFT SIDE. REMOVED AND REPLACED SKIN PER SRM.SDR SWAA100595Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA100533Slat · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING L/E NR 3 SLAT O/B DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA100466Stringer Splice · corrodedDURING SCHEDULED 22Y CHECK, FOUND FWD CARGO COMPARTMENT STRINGER END SPLICE CORRODED AT BS 540, STR 27R. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA100447Rib · crackedDURING SCHEDULED 22Y CHECK, FOUND LT WING I/B FORE FLAP L/E RIB CRACKED AT WBL 254. REMOVED AND REPLACED RIB PER SRM.SDR SWAA100446Rib · crackedDURING SCHEDULED 22Y CHECK, FOUND LT WING O/B FORE FLAP L/E RIB CRACKED AT WBL 254. REMOVED AND REPLACED RIB PER SRM.SDR SWAA100445Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 348, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100415Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 227, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100317Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097301Repair · missingDURING SCHEDULED MV4 CHECK, FOUND RT WING T/E FORE FLAP SKIN REPAIR MISSING. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA094277Lamp · weakDURING SCHEDULED CV CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT WEAK. RELAMPED PER MM.SDR SWAA091990Tab · failedDURING SCHEDULED HC2 CHECK, FOUND RT ELEVATOR TAB FAILED FREE PLAY CHECK. REPAIRED TAB PER SWA EA.
Back to N697SW, cancelled Oct 5, 2019