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 SWAA091633Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 749, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA091632Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 727D, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA091631Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 759, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA091630Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 500D, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA091629Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 750, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA091628Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 500D, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA091052Lens · missingBULLNOSE LIGHT LENS MISSING AT ROW 6. INSTALLED LENS PER MM.SDR SWAA086133Strip · missingDURING SCHEDULED MV2 CHECK, FOUND EEPLS STRIP MISSING AT MID CABIN. INSTALLED STRIP PER MM.SDR SWAA086122Strip · missingFOUND EEPLS STRIP MISSING AT MID CABIN. INSTALLED STRIP PER MM.SDR SWAA085037Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND AFT SERVICE DOOR SKIN CRACKED AT LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA084725Battery · dischargedRIGHT AFT CABIN EMERGENCY EXIT LIGHTS REMAIN ILLUMINATED. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA083070Flap · delaminatedDURING SCHEDULED SPV CHECK, FOUND RIGHT WING OUTBOARD T/E AFT FLAP DELAMINATED AT INBOARD CORNER. REMOVED AND REPLACED FLAP PER MM.SDR SWAA082800Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 506A, STR 20R. REPAIRED SKIN PER SRM.SDR SWAA081219Smoke Detector · inoperativeDURING SCHEDULED BRDG CHECK, AFT CARGO COMPARTMENT RT FWD SMOKE DETECTOR INOP. REMOVED AND REPLACED SMOKE DETECTOR PER MM.SDR SWAA081045Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, BETWEEN STR 3L AND STR 2R. REPAIRED FRAME PER SWA EA.SDR SWAA081043Beltframe · crackedDURING SCHEDULED BRDG CHECK, FOUND BELTFRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME PER SWA EA.SDR SWAA081044Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080991Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080967Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 727, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080946Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080947Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080948Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080949Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080950Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080951Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080952Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080945Keelbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND KEEL BEAM CORRODED BETWEEN BS 520 AND BS 540, LBL 11. REPAIRED KEEL BEAM PER SRM.SDR SWAA080857Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080855Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080856Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080799Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080777Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND LT WING NR 2 L/E SLAT LOWER SURFACE CRACKED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA080774Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 14R. REPAIRED FRAME PER SRM.SDR SWAA080776Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, STR 7L. REPAIRED FRAME PER SRM.SDR SWAA080775Stringer · corrodedDURING SCHEDULED BRDG CHECK, FOUND STRINGER 16R CORRODED AT BS 485. REPAIRED STRINGER PER SRM.SDR SWAA080778Support Angle · crackedDURING SCHEDULED BRDG CHECK, FOUND WING CENTER SECTION FRONT SPAR STIFFENER SUPPORT ANGLE CRACKED AT BS 540, LBL 57. REMOVED AND REPLACED SUPPORT ANGLE PER SRM.SDR SWAA080707Bulkhead · crackedDURING SCHEDULED BRDG CHECK, FOUND AFT PRESSURE BULKHEAD DOME CAP WEB CRACKED AT BS 1016, 12 O'CLOCK POSITION. REPAIRED WEB PER SRM.SDR SWAA080706Angle · corrodedDURING SCHEDULED BRDG CHECK, FOUND ZEE CHORD CORRODED AT BS 270, LBL 11 TO RBL 11. REMOVED AND REPLACED ZEE CHORD PER SRM.SDR SWAA080681Bulkhead · crackedDURING SCHEDULED BRDG CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, 9 O'CLOCK POSITION. REPAIRED WEB PER SRM.SDR SWAA080653Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 2R. REPAIRED FRAME PER SRM.SDR SWAA080652Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080651Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080615Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 1006, STR 24L. REPAIRED SHEAR TIE PER SRM.SDR SWAA080614Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 360 AND BS 400, STR 17R. REMOVED AND REPLACED WEB PER SWA EA.SDR SWAA080613Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 400 AND BS 420, STR 17L. REMOVED AND REPLACED WEB PER SWA EA.SDR SWAA080584Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM UPPER TEE CAP CRACKED AT BS 727B, LBL 45. REPAIRED FLOORBEAM TEE CAP PER SWA EA.SDR SWAA080545Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 988, STR 20L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080546Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 1006, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080524Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR FRAME CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME PER SRM.SDR SWAA080434Bracket · corrodedDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR BRACKET CORRODED. REMOVED AND REPLACED BRACKET PER SRM.
Back to N332SW, cancelled Jan 3, 2018