N502SW, cancelled Jan 29, 2014
Service difficulty reports · 246
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 = 'N502SW' AND deregistration_id = 'N502SW-2014-01-29' 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 = 'N502SW' AND deregistration_id = 'N502SW-2014-01-29' 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 SWAA111918Frame · crackedDURING SCHEDULED OTS CHECK, FOUND CRACK LT SIDE FRAME REINFORCEMENT FWD PIT STA 482A. REPAIRED FRAME PER SRM.SDR SWAA106939Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 842, STR 16L. REPAIRED SKIN PER EA.SDR SWAA106792Slide · out of adjustL2 DOOR EVACUATION SLIDE OUT OF ADJUST. REPOSITIONED SLIDE ASSY PER MM & MT.SDR SWAA105376Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 482B + 15, STR 16R. REPAIRED SKIN PER EA.SDR SWAA102330Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 540, STR 8R. REPAIRED SKIN PER EA.SDR SWAA102032Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 306, STR 18R. REPAIRED SKIN PER AAR EA.SDR SWAA102018Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 890, STR 22R. REPAIRED SKIN PER SRM.SDR SWAA098130Light · brokenR1 DOOR LOWER EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA097607Window · arcedL1 COCKPIT WINDSHIELD ARCING ON DESCENT AND CRACKED UPON PARKING AT GATE. REMOVED AND REPLACED L1 WINDOW PER MM.SDR SWAA096668Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 372, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA096667Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 802, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA096533Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA096451Fitting · looseDURING SCHEDULED 20Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA096417Light · missingDURING SCHEDULED 20Y CHECK, FOUND FWD GALLEY EMERGENCY EXIT LIGHT MISSING. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA096409Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR UPPER STUB FRAME CRACKED. REMOVED AND REPLACED FRAME SECTION PER BAC DWG.SDR SWAA096391ALight · missingDURING SCHEDULED 20Y CHECK, FOUND FWD GALLEY EMERGENCY EXIT LIGHT MISSING. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA096383AFrame · crackedDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR UPPER STUB FRAME CRACKED. REMOVED AND REPLACED FRAME SECTION PER BAC DWG.SDR SWAA096388Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 987, STR 24L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096362AStringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 987, STR 24L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096343Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA096342Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 967, STR 19L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096341Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA096340Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA096301Stringer · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CRACKED AT BS 980, STR 21L. REPAIRED STRINGER PER SRM.SDR SWAA096300Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE BELLY SKIN CORRODED AT BS 304, RBL 6. REPAIRED SKIN PER SRM.SDR SWAA096299Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096298Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096258Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT MLG BEAM I/B SUPPORT LINK CORRODED. REMOVED AND REPLACED BEAM PER MM.SDR SWAA096228Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 291, BETWEEN STR 16R TO STR 17R. REPAIRED FRAME PER AAR EA.SDR SWAA096187Attach Fitting · crackedDURING SCHEDULED 20Y CHECK, FOUND RT WING I/B LOWER TRAILING EDGE PANEL SUPPORT ROD UPPER ATTACH FITTING CRACKED. REPAIRED FITTING PER SWA EA.SDR SWAA096120Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING NR 3 SLAT O/B TRAILING EDGE WEDGE DELAMINATED. REPAIRED WEDGE PER MM.SDR SWAA096119Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER AAR EA.SDR SWAA096118Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER AAR EA.SDR SWAA096041Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER EA.SDR SWAA095979Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095978Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095977Stringer Splice · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CRACKED BETWEEN BS 907 TO BS 908, STR 4L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA095976Stringer Splice · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CRACKED BETWEEN BS 907 TO BS 908, STR 4R. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA095975Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095974Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095973Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA096049Shear Tie · crackedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CRACKED AT BS 616, STR 5L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA095822Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095821Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095820Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING NR 4 SLAT T/E WEDGE DELAMINATED. REPAIRED SLAT PER MM.SDR SWAA095754Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095753Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095752Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095803Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095802Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 5R. REMOVED AND REPLACED CLIP PER SRM.
Back to N502SW, cancelled Jan 29, 2014