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 SWAA094428Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA094427Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA094426Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND MID CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA094425Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND RT WING LOWER EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA094424Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA094423Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND LT WING LOWER EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA094392Stringer Splice · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CORRODED AT BS 904, STR 19R. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA094391Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 902, STR 18R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA094311Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4L. REMOVED AND REPLACED CLIP PER MM.SDR SWAA094310Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED SPLICE PER MM.SDR SWAA094293Sign · inoperativeDURING SCHEDULED SPV CHECK, FOUND CENTER AISLE OVERWING EMERGENCY EXIT SIGN BATTERY PACK FUSE INOP. REMOVED AND REPLACED SIGN PER MM.SDR SWAA094137Stringer Clip · crackedDURING SCHEDULED SPV FOUND STRINGER CLIP CRACKED AT BS 500B, STR 25L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA094136Stringer Clip · crackedDURING SCHEDULED SPV FOUND STRINGER CLIP CRACKED AT BS 492, STR 24L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA094135Stringer Clip · crackedDURING SCHEDULED SPV FOUND STRINGER CLIP CRACKED AT BS 400, STR 20L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA094134Stringer Clip · crackedDURING SCHEDULED SPV FOUND STRINGER CLIP CRACKED AT BS 500C, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA094133Stringer Clip · crackedDURING SCHEDULED SPV FOUND STRINGER CLIP CRACKED AT BS 500C, STR 25L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA094132Stringer Clip · crackedDURING SCHEDULED SPV FOUND STRINGER CLIP CRACKED AT BS 500C, STR 20L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA094131Stringer Clip · crackedDURING SCHEDULED SPV FOUND STRINGER CLIP CRACKED AT BS 500C, STR 19L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA094130Stringer Clip · crackedDURING SCHEDULED SPV FOUND STRINGER CLIP CRACKED AT BS 500A, STR 19L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA094109Shear Tie · corrodedDURING SCHEDULED SPV, FOUND SHEAR TIE CORRODED AT BS 360, STR 14L TO STR 14R. REPAIRED SHEAR TIE PER SRM & ACO.SDR SWAA094108Frame · crackedDURING SCHEDULED SPV, FOUND AFT CARGO DOOR CUTOUT FRAME CORRODED AT BS 764. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA093954Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 728, STR 23R. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA093953Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093952Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 23R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093951Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 887, BETWEEN STR 15L TO STR 16L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA093950Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 12L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA093892Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND BS 178 BULKHEAD CRACKED AT BS 178, RBL 29, WL 207. REMOVED AND REPLACED WEB PER SRM.SDR SWAA093891Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND BS 178 BULKHEAD CRACKED AT BS 178, LBL 29, WL 207. REMOVED AND REPLACED WEB PER SRM.SDR SWAA093756Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093755Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 2L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093754Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 1L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093753Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093699Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 380, STR 8L. REPAIRED STRINGER PER SRM.SDR SWAA093700Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 8R. REPAIRED CLIP PER SRM.SDR SWAA093628Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 11R. REMOVED AND REPLACED CLIP PER ER.SDR SWAA093585Structure · crackedDURING SCHEDULED SPV CHECK, FOUND BULKHEAD UPPER CHORD CRACKED AT BS 178, LBL 24, WL 235. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA093596Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093586Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093597Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093491Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091841Window · arcedEN ROUTE TO DEN, L1 COCKPIT WINDOW ARCED. REMOVED AND REPLACED WINDOW PER MM.SDR SWAA091598Flap · delaminatedDURING SCHEDULED 16Y CHECK, FOUND LT WING I/B TRAILING EDGE FORE FLAP DELAMINATED. REMOVED AND REPLACED FOREFLAP PER MM.SDR SWAA091597Flap · delaminatedDURING SCHEDULED 16Y CHECK, FOUND RT WING I/B TRAILING EDGE FORE FLAP DELAMINATED. REMOVED AND REPLACED FOREFLAP PER MM.SDR SWAA091501Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME WEB CRACKED AT BS 303, STR 16L. REPAIRED WEB PER ACO.SDR SWAA091488Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA091487Skin · corrodedDURING SCHEDULED 16Y CHECK, FOUND LOWER SKIN CORRODED AT BS 460, BL 0. REPAIRED SKIN PER SRM.SDR SWAA091435Light · inoperativeDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. SECURED BULB PER MM.SDR SWAA091434Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500, BL 0. REPAIRED FRAME PER SRM.SDR SWAA090676Gasper Fan · faultyGASPER FAN C/B POPPED EN ROUTE TO HOU, TURNED OFF GASPER FAN. FLT ATTENDANT DETECTED A SLIGHT WHIFF/ODOR IN FWD CABIN, NOTHING IN REAR OF AIRCRAFT NOR ON FLT DECK. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA090540Battery · dischargedDURING SCHEDULED MV3 CHECK, FOUND FWD I/B EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.
Back to N368SW, cancelled Mar 22, 2018