N360SW, cancelled Jul 24, 2018
Service difficulty reports · 354
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 = 'N360SW' AND deregistration_id = 'N360SW-2018-07-24' 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 = 'N360SW' AND deregistration_id = 'N360SW-2018-07-24' 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 SWAA091785Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091784Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 727D TO 727E, STR 17R. REPAIRED WEB PER SRM.SDR SWAA091783Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 727E TO 727D, STR 17L. REPAIRED WEB PER SRM.SDR SWAA091782Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 727E TO 747, STR 17L. REPAIRED WEB PER SRM.SDR SWAA091781Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CHORD CRACKED AT BS 639, RBL 45. REPAIRED FRAME PER SRM.SDR SWAA091780Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CHORD CRACKED AT BS 616, RBL 64. REPAIRED FRAME PER SRM.SDR SWAA091779Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091778Web · crackedDURING SCHEDULED SPV CHECK, FOUND COCKPIT FLOOR WEB CRACKED BETWEEN BS 179 TO BS 181, RBL 29, WL 208. REPAIRED WEB PER SRM.SDR SWAA091777Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA091776Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091775Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RADIO ALTIMETER FUSELAGE BELLY SKIN CUTOUT CRACKED AT BS 413, BETWEEN LBL 3 TO RBL 3. REPAIRED SKIN PER EA.SDR SWAA091689Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RADIO ALTIMETER BELLY SKIN CUTOUT CRACKED AT BS 413, BETWEEN LBL 3 TO RBL 3. REPAIRED SKIN PER ER.SDR SWAA091596Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA091595Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA091594Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA091593Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA091592Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA091591Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA091590Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA091589Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA091588Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA091587Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA091586Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4R. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA091551Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 500B, STR 10R. REPAIRED STRINGER PER SRM.SDR SWAA091550Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 727E, STR 9L. REPAIRED FRAME PER SRM.SDR SWAA091549Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091548Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091547Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091546Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091545Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091544Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091543Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR 14R TO STR 15R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA091542Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091541Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091308Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA086412Flap · delaminatedDURING SCHEDULED HC1 CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA084667Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 942, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA084666Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 942, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA082688Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 821, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA082687Skin · delaminatedDURING SCHEDULED HC2 CHECK, FOUND RT WING INBOARD T/E AFT FLAP OUTBOARD END DELAMINATED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA082686Battery · inoperativeDURING SCHEDULED HC2 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA082649Skin · corrodedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 976, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA082650Skin · corrodedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 987, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA082516Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 727C TO BS 727D, RBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA082517Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 867 TO BS 887, RBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA082464Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM TEE CAP CORRODED AT BS 986, RBL 38 TO LBL 44. REMOVED AND REPLACED TEE CAP PER SRM.SDR SWAA082463Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT ENTRY DOOR CUTOUT FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA082424Stiffener · crackedDURING SCHEDULED BRDG CHECK, FOUND RADIAL STIFFENER CRACKED AT AFT PRESSURE BULKHEAD BS 1016, 3 O'CLOCK POSITION. REMOVED AND REPLACED STIFFENER PER SRM.SDR SWAA082425Stringer · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 7L CRACKED AT BS 1016. REPAIRED STRINGER PER SRM.SDR SWAA082426Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FWD SERVICE DOOR CUTOUT FWD FRAME CRACKED AT LOWER FWD CORNER. REPAIRED FRAME PER SRM.
Back to N360SW, cancelled Jul 24, 2018