N368SW, cancelled Mar 22, 2018
Service difficulty reports · 360
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 = 'N368SW' AND deregistration_id = 'N368SW-2018-03-22' 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 = 'N368SW' AND deregistration_id = 'N368SW-2018-03-22' 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 SWAA087225Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND VERTICAL BEAM WEB CRACKED AT WL 180, RBL 5.7, BS 178. REPAIRED WEB PER SRM.SDR SWAA087224Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND VERTICAL BEAM WEB CRACKED AT WL 180, LBL 5.7, BS 178. REPAIRED WEB PER SRM.SDR SWAA087226Attach Fitting · corrodedDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR AFT GIRT BAR MOUNT ATTACH FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA087119Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND BULKHEAD VERTICAL BEAM WEB CHORD CRACKED AT BS 178, RBL 5.7, BETWEEN WL 198 TO WL 199. REPAIRED CHORD PER SRM.SDR SWAA087118Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND BULKHEAD VERTICAL BEAM WEB CHORD CRACKED AT BS 178, RBL 17, WL 230. REPAIRED CHORD PER SRM.SDR SWAA086771Slat · delaminatedDURING SCHEDULED HC2 CHECK, FOUND RT WING NR 5 SLAT DELAMINATED AT O/B EDGE. REPAIRED SLAT PER MM.SDR SWAA086015Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 495 TO 437, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA086014Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 432 TO 434, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA086013Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 385 TO 387, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA086012Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 731C TO 733C, STR 4R. REPAIRED SKIN PER SWA EA.SDR SWAA086011Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503C, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA082015Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 830, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA081434Fitting · corrodedDURING SCHEDULED MV2 CHECK, FOUND LT MLG WALKING BEAM FWD OUTBOARD FITTING CORRODED. REMOVED AND REPLACED FITTING PER SWA EA.SDR SWAA081433Fitting · corrodedDURING SCHEDULED MV2 CHECK, FOUND RIGHT MLG WALKING BEAM FWD OUTBOARD FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA081009Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 503D, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA081008Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 733D, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA080782Lens · looseBULLNOSE EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 11 ABC. SECURED LENS PER MM.SDR SWAA080162Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 522, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA075834Stringer · corrodedDURING SCHEDULED 14Y CHECK, FOUND STRINGER 27L CORRODED AT BS 967. REPAIRED STRINGER PER SRM.SDR SWAA075749Structure · crackedDURING SCHEDULED 14Y CHECK, FOUND RIGHT ELEVATOR TAB CRACKED AT NR 2 HINGE. REPAIRED RIGHT ELEVATOR TAB PER SRM.SDR SWAA075750Structure · debondedDURING SCHEDULED 14Y CHECK, FOUND LEFT ELEVATOR TAB DISBONDED AT OUTBOARD END. REPAIRED LEFT ELEVATOR TAB PER SRM.SDR SWAA075735Lens · crackedDURING SCHEDULED 14Y CHECK, FOUND RIGHT OVERWING EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED RIGHT OVERWING EMERGENCY EXIT LIGHT LENS PER MM.SDR SWAA075704Light · brokenDURING SCHEDULED 14Y CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT ASSY BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA075687Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075580Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075583Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA075582Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA075581Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073624Beam · crackedDURING SCHEDULED C2 CHECK, FOUND R1 DOOR CRACKED AT LOWER BEAM WEB. REMOVED AND REPLACED R1 DOOR ASSY PER MM.SDR SWAA072077Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA072076Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA071903Hinge · wornLEFT WING NR 4 SPOILER HINGE WORN. REMOVED AND REPLACED NR 4 SPOILER PER MM.SDR SWAA070733Slide · out of adjustDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA070629Slide · out of adjustDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA070501Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR CUTOUT LOWER FWD CORNER. REPAIRED SKIN PER SRM.SDR SWAA070188Vertical Beam · crackedDURING SCHEDULED SPV CHECK, FOUND BULKHEAD VERTICAL BEAM CHORD CRACKED AT BS 178, LBL 5.7, WL 184. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA070187Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT ENTRY DOOR CUTOUT LOWER FWD CORNER. REPAIRED SKIN PER SRM.SDR SWAA070168Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME SECTION PER ER.SDR SWAA064888Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA061783Bulkhead · crackedDURING SCHEDULED C2 CHECK, FOUND PRESSURE BULKHEAD CHORD WEB CRACKED AT BS 1016, STR 7L. REPAIRED WEB PER SRM.SDR SWAA060739Cover · missingEEPLS TRACK COVER MISSING BETWEEN ROW 8 TO ROW 10. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA060382Skin · crackedDURING SCHEDULED C1 CHECK, FOUND RT HORIZONTAL STAB LOWER SKIN CRACKED AT INBD AFT SPAR BETWEEN STAB STA 96 TO STAB STA 115. REPAIRED SKIN PER SRM.SDR SWAA060036Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, BETWEEN STR 23L TO STR 24L. REPAIRED SKIN PER SRM.SDR SWAA053419Strip · loosePHOTOLUMINESCENT STRIP LOOSE AT ROW 8 DEF. SECURED STRIP PER MM.SDR SWAA053151Light · looseEEPLS STRIP LOOSE AT FWD END. REMOVED AND REPLACED STRIP PER MM.SDR SWAA052154Battery · inoperativeDURING SCHEDULED RON CHECK, FOUND RT AFT CABIN EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA052064Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR FWD LOWER CORNER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA051900Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA051899Tab · wornDURING SCHEDULED C3 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED ELEVATOR TAB PER MM.SDR SWAA051743Light · erraticOVERWING EMERGENCY EXIT LIGHTS REMAINED ILLUMINATED WITH EMERGENCY EXIT LIGHT SWITCH ARMED. POWERED DOWN AIRCRAFT & PERFORMED OPERATION CHECKS. ALL LIGHTS WORKING NORMAL PER MM.
Back to N368SW, cancelled Mar 22, 2018