N332SW, cancelled Jan 3, 2018
Service difficulty reports · 293
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 = 'N332SW' AND deregistration_id = 'N332SW-2018-01-03' 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 = 'N332SW' AND deregistration_id = 'N332SW-2018-01-03' 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 SWAA100845Shear Tie · crackedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CRACKED AT BS 520, STR 28L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA100790Fitting · corrodedDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA100788Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 344, STR 6L. REPAIRED FRAME PER SRM.SDR SWAA100713Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 312, STR 19R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100657Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 799, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA100656Flap · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA100608Strap · crackedDURING SCHEDULED 22Y CHECK, FOUND CHANNEL STRAP CRACKED BETWEEN BS 312 TO BS 344, STR 18L. REMOVED AND REPLACED STRAP PER SRM.SDR SWAA100607Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 320, STR 20L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA100606Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 13L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100560Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS BS 500C, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA100511Flap · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA100510Slat · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING NR 5 SLAT DELAMINATED. REPAIRED NR 5 SLAT PER SRM.SDR SWAA100509Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 11R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100508Flap · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA100507Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277 STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100475Web · crackedDURING SCHEDULED 22Y CHECK, FOUND WEB CRACKED BETWEEN BS 277 TO BS 291.5, BETWEEN STR 8R TO STR 10R. REMOVED AND REPLACED WEB PER SRM.SDR SWAA100474Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 2L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100449Beam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL BEAM CRACKED BETWEEN BS 698 TO BS 717, BBL 0.07. REPAIRED BEAM PER SI.SDR SWAA100433Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100432Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100431Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100430Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100429Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100428Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100427Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100426Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100425Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100424Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100423Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100382Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 343, BETWEEN STR 21R TO STR 22R. REPAIRED SKIN PER SRM.SDR SWAA100102Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 515C, STR 8L. REPAIRED SKIN PER SRM.SDR SWAA097480Acm · faultyLOSS PRESSURE AT 14,000 FT ALT WARNING HORN SOUNDED. MASKS DIDN'T FALL. REMOVED AND REPLACED BELLY DRAINS, FWD OUTFLOW VALVE, AND LEFT ACM PER MM.SDR SWAA097098Actuator · brokenCONTROL YOKE STICKS 6 UNITS DURING LEFT TURN. FOUND NR 5 GRND SPOILER ACT ATTACH BRACKET BROKEN. REMOVED AND REPLACED SPOILER ACT ASSY PER MM.SDR SWAA095503Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 303.5, WL 238 LT. REPAIRED SKIN PER ER.SDR SWAA095502Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA095501Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA095499Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA094982Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 384, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA094777Cover · missingR2 DOOR EXTERNAL EMERGENCY EXIT LIGHT LENS COVER MISSING. REPAIRED LIGHT PER EA.SDR SWAA094193Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EXTERNAL EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT SOCKET ASSY PER MM.SDR SWAA092196Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 792, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA091996Flap · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LT WING O/B AFT FLAP DELAMINATED I/B. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA091995Wedge · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LT WING NR 1 SLAT DELAMINATED ON T/E WEDGE. REMOVED AND REPLACED SLAT PER MM.SDR SWAA091640Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 440, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA091639Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 445, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA091638Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 747, STR 20L. REPAIRED SKIN PER SWA EA.SDR SWAA091637Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 779, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA091636Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 779, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA091635Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 763, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA091634Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 760, STR 19L. REPAIRED SKIN PER SWA EA.
Back to N332SW, cancelled Jan 3, 2018