N344SW, cancelled Oct 26, 2017
Service difficulty reports · 292
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 = 'N344SW' AND deregistration_id = 'N344SW-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 = 'N344SW' AND deregistration_id = 'N344SW-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 SWAA111486Keelbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LOWER BULKHEAD KEEL BEAM FITTING CRACKED AT BS 727, LBL 6. REMOVED AND REPLACED FITTING PER SRM AND BAC DWG.SDR SWAA111485Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111484Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 2R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111483Plate · crackedDURING SCHEDULED 22Y CHECK, FOUND L2 DOOR INTERNAL CLOSE OUT PLATE BETWEEN HINGES CRACKED. REMOVED AND REPLACED PLATE PER BAC DWG.SDR SWAA111393Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 1012, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111300Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 986, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA111299Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111298Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111297Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111296Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM T-CAP CORRODED AT BS 986, BETWEEN LBL 4 TO LBL 44. REMOVED AND REPLACED T-CAP PER SRM.SDR SWAA111266Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 523, BETWEEN STR 15L TO STR 17L. REPAIRED SKIN PER SRM.SDR SWAA111265Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111205Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111204Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 26L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111203Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 13L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111202Bolt · corrodedDURING SCHEDULED 22Y CHECK, FOUND LT MLG SHOCK STRUT T-BOLT ATTACH BOLT BORE CORRODED. REMOVED AND REPLACED T-BOLT PER MM.SDR SWAA111458Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 907+8.25 TO BS 927+2, STRINGER 24L TO STRINGER 26L. REPAIRED SKIN PER SRM.SDR SWAA111130Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111129Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 26L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA111128Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CRACKED AT BS 673, BL 0. REPAIRED BEAM PER EA.SDR SWAA111080Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111079Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 25L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111078Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111077Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA111076Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED ON UPPER SURFACE I/B END. REPAIRED FORE FLAP PER SRM.SDR SWAA111075Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CRACKED AT BS 727D, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME PER BAC DWG.SDR SWAA111044Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT FLOORBEAM CORRODED AT BS 729E, LBL 12. REPAIRED BEAM PER SRM.SDR SWAA110984Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 23R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA110983Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 24L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA110982Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 11R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA110820Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 4R. REMOVED AND REPLACED CLIP PER SI.SDR SWAA110819Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA110818Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7L. REMOVED AND REPLACED CLIP PER SI.SDR SWAA110817Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 11R. REMOVED AND REPLACED CLIP PER SRM AND SI.SDR SWAA110816Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED CLIP PER SRM AND SI.SDR SWAA110815Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED CLIP PER SRM AND SI.SDR SWAA110814Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO FLOORBEAM ANGLE CORRODED AT BS 860, RBL 2. REPAIRED BEAM PER EA.SDR SWAA110813Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 727E, LBL 3. REPAIRED BEAM PER EA.SDR SWAA110812Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO FLOORBEAM CORRODED AT BS 727E, LBL 17. REPAIRED BEAM PER EA.SDR SWAA110811Channel · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO CHANNEL CORRODED AT BS 732D, RBL 3.0. REMOVED AND REPLACED CHANNEL PER SRM AND EA.SDR SWAA110810Channel · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO CHANNEL CORRODED AT BS 732D, LBL 3.0. REMOVED AND REPLACED CHANNEL PER SRM AND EA.SDR SWAA110809Channel · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO CHANNEL CORRODED AT BS 732D, LBL 12.50. REMOVED AND REPLACED CHANNEL PER SRM AND EA.SDR SWAA110442Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REMOVED AND REPLACED R1 DOOR PER EA.SDR SWAA107302Control Lever · faultyDECLARED EMERGENCY. AFTER SELECTING GEAR DOWN 3 GREEN 3 RED. UNSAFE GEAR INDICATION. MANUALLY EXTENDED. REMOVED AND REPLACED LANDING GEAR LEVER ASSY PER MM.SDR SWAA107118Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA106459Hinge · brokenDURING SCHEDULED MV2 CHECK, FOUND LT WING I/B GROUND SPOILER HINGE BROKEN. REMOVED AND REPLACED GROUND SPOILER PER MM.SDR SWAA104125Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 969.5, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA104124Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 738.4E, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA104102Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 921.75 TO BS 924.75, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA104089Skin · crackedDURING SCHEDULED 26Y CHECK, FOUND SKIN CRACKED AT BS 729.25E, STR 18L. REPAIRED SKIN PER SRM.
Back to N344SW, cancelled Oct 26, 2017