N342SW, cancelled Oct 26, 2017
Service difficulty reports · 250
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 = 'N342SW' AND deregistration_id = 'N342SW-2017-10-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 = 'N342SW' AND deregistration_id = 'N342SW-2017-10-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 SWAA2012021301354Roller · out of trackWHEN SELECTING FLAPS 1, ON APPROACH, AIRCRAFT ROLLS TO THE RIGHT. FOUND RIGHT OUTBOARD AFT FLAP OUTBOARD CONTROL ROD ROLLER OUT OF TRACK. RE-INSTALLED IAW MM.SDR SWAA120632Skin · crackedDURING SCHEDULED CV CHECK, FOUND L2 DOOR FUSELAGE SKIN CRACKED AT UPPER CORNER CUTOUT, BS 951. REPAIRED SKIN PER SRM.SDR SWAA117463Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT EMERGENCY EXIT SIDEWALL LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA117462Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EXIT SIGN LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA116461Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 942, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA116460Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 761, STR 20R. REPAIRED SKIN PER SRM.SDR SWAA116459Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 887, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA116333Skin · crackedDURING SCHEDULE SPV CHECK, FOUND SKIN CRACKED AT BS 740, STR 18R. REPAIRED SKIN IAW SRM.SDR SWAA114975Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 500B+15, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA114925Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500B+15, STR 9L. REPAIRED SKIN PER SRM.SDR SWAA114004Slide · looseL2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MT.SDR SWAA111643Door Frame · crackedDURING SCHEDULED 2HC2 CHECK, FOUND FORWARD CARGO DOOR AFT LOWER FRAME AT I/B CUTOUT OF I/B AFT DOOR STOP CRACKED. REMOVED AND REPLACED DOOR PER MM.SDR SWAA107117Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CRACKED AT BS 727B, RBL 24.8. REPAIRED BEAM PER ER AND EA.SDR SWAA107089Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA107088Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR SWAA107087Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA107055Web · corrodedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM SHEAR WEB CORRODED BETWEEN BS 449 TO BS 454, LBL 73. REPAIRED BEAM PER SRM AND BAC DWG.SDR SWAA107054Web · corrodedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM SHEAR WEB CORRODED BETWEEN BS 387 TO BS 393, LBL 73. REPAIRED BEAM PER SRM AND BAC DWG.SDR SWAA107048Structure · corrodedDURING SCHEDULED 22Y CHECK, FOUND VERTICAL CHORD CORRODED AT BS 1126, RBL 16. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA107011Angle · corrodedDURING SCHEDULED 22Y CHECK, FOUND L-ANGLE CORRODED AT BS 308, LBL 55. REMOVED AND REPLACED L-ANGLE PER SRM.SDR SWAA107010Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 26L. REPAIRED FRAME PER SRM.SDR SWAA107009Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED CLIP PER SI AND EA.SDR SWAA107008Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6L. REMOVED AND REPLACED CLIP PER SI AND EA.SDR SWAA107007Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 4L. REMOVED AND REPLACED CLIP PER SI AND EA.SDR SWAA107006Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 6L. REMOVED AND REPLACED CLIP PER SI AND EA.SDR SWAA107005Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 8L. REMOVED AND REPLACED CLIP PER SI AND EA.SDR SWAA107004Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 4L. REMOVED AND REPLACED CLIP PER SI AND EA.SDR SWAA107003Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 1L. R&R CLIP PER SI AND EA.SDR SWAA107002Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA107001Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 6R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA107000Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 4R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA106999Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 987, BETWEEN BBL 0 TO RBL 46. REPAIRED BEAM PER SRM.SDR SWAA106998Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 10R. REMOVED AND REPLACED CLIP PER ER AND EA.SDR SWAA106997Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 4R. REMOVED AND REPLACED CLIP PER ER AND EA.SDR SWAA106996Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 4R. REMOVED AND REPLACED CLIP PER ER AND EA.SDR SWAA106995Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING O/B FORE FLAP LOWER SURFACED DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA106994Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA106993Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 300, STR 12L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA106992Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 11L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA106991Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 936, RBL 14. REMOVED AND REPLACED SHEAR TIE PER SRM AND BAC DWG.SDR SWAA106831Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 7L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA106626Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA104262Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 972.5, STR 24L. REPAIRED SKIN PER ER.SDR SWAA104175Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND LT OVERWING EMERGENCY EXIT SIGN LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA102547Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 824, STR 19L. REPAIRED SKIN PER AAR EA.SDR SWAA102546Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 770, STR 18L. REPAIRED SKIN PER AAR EA.SDR SWAA102545Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 750, STR 19L. REPAIRED SKIN PER AAR EA.SDR SWAA102476Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 729D, STR 19L. REPAIRED SKIN PER AAR EA.SDR SWAA102475Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 747 +17, STR 19L. REPAIRED SKIN PER AAR EA.SDR SWAA102474Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 787 +13, STR 19L. REPAIRED SKIN PER AAR EA.
Back to N342SW, cancelled Oct 26, 2017