N364SW, cancelled Apr 26, 2016
Service difficulty reports · 302
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 = 'N364SW' AND deregistration_id = 'N364SW-2016-04-26' 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 = 'N364SW' AND deregistration_id = 'N364SW-2016-04-26' 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 SWAA104373Angle · crackedDURING SCHEDULED 18Y CHECK, FOUND STUB FRAME ANGLE CRACKED AT BS 639, RBL 46. REPAIRED ANGLE PER SRM AND BAC DWG.SDR SWAA102743Connector · dirtyAIR TURNBACK / DECLARED EMERGENCY. WHEEL WELL FIRE WARNING LIGHT ILLUMINATED INFLIGHT. DECLARED EMERGENCY - RETURNED TO HOU. CLEANED FIRE WARNING CONNECTORS AT MLG WHEEL WELL PER MT.SDR SWAA097224Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM AND EA.SDR SWAA097223Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA097269Strip · wornDURING SCHEDULED 2HC2 CHECK, FOUND EEPLS WORN AT ROW 8 DEF. REMOVED AND REPLACED EEPLS STRIP PER MM.SDR SWAA094466Slide · out of adjustDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA086616Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 362, STR 4R. REPAIRED STRINGER PER SRM.SDR SWAA086436Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BETWEEN BS 500A TO BS 500B, STR 19L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086413Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 500D, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER PAE ER.SDR SWAA086369Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND R1 DOOR FRAME CRACKED AT BS AFT BOTTOM STOP PIN FITTING. REPAIRED FRAME ASSY PER SRM.SDR SWAA086010Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 25R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA086009Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 20R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA086008Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 520, BETWEEN STR 21R AND STR 22R. REPAIRED SHEAR TIE PER SRM & BAC DRAWING.SDR SWAA085889Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 18R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085888Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 22R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085705Skin · crackedDURING SCHEDULED SPV CHECK, FOUND L1 DOOR UPPER HINGE CUTOUT FUSELAGE SKIN CRACKED AT BS 303, WL 258. REPAIRED SKIN PER PAE ER.SDR SWAA085704Skin · crackedDURING SCHEDULED SPV CHECK, FOUND L1 DOOR LOWER HINGE CUTOUT FUSELAGE SKIN CRACKED AT BS 303, WL 238. REPAIRED SKIN PER PAE ER.SDR SWAA085631Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 18R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085630Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 21L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085629Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085628Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 23L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085627Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR 14R TO STR 15R. REPAIRED SHEAR TIE PER SRM.SDR SWAA085626Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM CORRODED BETWEEN RT BS 493 TO BS 500. REPAIRED BEAM PER SRM.SDR SWAA085625Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM CORRODED AT BETWEEN RT BS 480 TO BS 492. REPAIRED BEAM PER SRM.SDR SWAA085624Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CRACKED AT BS 947, LBL 54. REPAIRED BEAM PER PAE ER.SDR SWAA085623Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085601Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CRACKED AT BS 947, LBL 54. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA085600Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS. 360, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085599Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 986 BETWEEN RBL 50 TO LBL 50, WL 208. REPAIRED BEAM PER PAE ER.SDR SWAA085578Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 1010, STR 24R. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA085577Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085576Fitting · corrodedDURING SCHEDULED SPV CHECK, FOUND L1 DOOR AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA085530Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 8R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA085285Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 380, STR 15L. REPAIRED STRINGER PER SRM.SDR SWAA085284Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 927, STR 24R TO STR 25R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA085183Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT STA 908, STR 4R. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA085088Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084941Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER 27R CORRODED AT BS 967. REPAIRED STRINGER PER SRM.SDR SWAA084940Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084939Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084938Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 967, RBL 30. REPAIRED FLOORBEAM PER SRM.SDR SWAA084878Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 947, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA084849Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084848Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 817, LBL 67. REMOVED AND REPLACED WEB PER SRM.SDR SWAA084847Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084846Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084845Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084753Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084752Fitting · crackedDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FITTING CRACKED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA084697Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907,STR 8L. REPAIRED FRAME PER SWA EA.
Back to N364SW, cancelled Apr 26, 2016