N343SW, cancelled Oct 27, 2017
Service difficulty reports · 247
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 = 'N343SW' AND deregistration_id = 'N343SW-2017-10-27' 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 = 'N343SW' AND deregistration_id = 'N343SW-2017-10-27' 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 SWAA097239Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA095566Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND AFT GALLEY LOWER EMERGENCY EXIT SIGN LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA095256Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND RT HORIZONTAL STABILIZER SKIN CRACKED AT STA 92.70. REPAIRED SKIN PER SRM.SDR SWAA095255Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND RT HORIZONTAL STABILIZER SKIN CRACKED AT STA 157.10. REPAIRED SKIN PER SRM.SDR SWAA095254Slide · out of positionDURING SCHEDULED HC1 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA095037Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 520, STR 15L. REPAIRED SKIN PER ER.SDR SWAA091583Escape Rope · out of positionRT EMERGENCY EXIT ESCAPE ROPE OUT OF DOOR. REPACKED ROPE PER MM.SDR SWAA090931Lens · looseDURING SCHEDULED RON CHECK, FOUND EMERGENCY EXT BULLNOSE LIGHT LENS LOOSE AT ROW 5. SECURED LIGHT PER MM.SDR SWAA090884Lens · looseDURING SCHEDULED RON CHECK, EMERGENCY EXIT BULLNOSE LIGHT LENS LOOSE AT ROW 5. SECURED LIGHT ASSY PER MM.SDR SWAA090874Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 17R. REPAIRED FRAME PER ER.SDR SWAA090816Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT, BS 304, WL 259. REPAIRED SKIN PER ER.SDR SWAA090815Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM UPPER FLANGE CORRODED AT BS 360, BETWEEN LBL 21 TO RBL 21. REPAIRED BEAM PER ER.SDR SWAA090814Light · inoperativeDURING SCHEDULED 20Y CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED & REPLACED LIGHT PER MM.SDR SWAA090813Light · damagedDURING SCHEDULED 20Y CHECK, FOUND EMERGENCY EXIT LIGHT DAMAGED AT AFT LAV. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA090812Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 258, WL 187. REPAIRED SKIN PER ER.SDR SWAA090811Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT KEEL BEAM CORRODED BETWEEN BS 500D TO BS 540. REPAIRED BEAM PER ER.SDR SWAA090810Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986 BETWEEN RBL 18 TO RBL 42, WL 208. REPAIRED BEAM PER ER.SDR SWAA090792Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT CREASE BEAM WEB CORRODED AT BETWEEN BS 420 TO BS 440. REPAIRED BEAM PER SRM.SDR SWAA090791Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 751, STR 18R. REPAIRED SKIN PER ER.SDR SWAA090781Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, BETWEEN RBL 18 TO RBL 42, WL 208. REPAIRED BEAM PER ER.SDR SWAA090755Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND RT KEEL BEAM CORRODED BETWEEN BS 520 TO BS 525. REPAIRED BEAM PER SRM.SDR SWAA090743Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, BS 292, BETWEEN WL 232 TO WL 233. REPAIRED SKIN PER ER.SDR SWAA090742Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090672Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BUTT SPLICE CRACKED AT BS 258, WL 173 LT SIDE. REPAIRED SKIN PER ER.SDR SWAA090671Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BUTT SPLICE CRACKED AT BS 258, WL 175 LT SIDE. REPAIRED SKIN PER ER.SDR SWAA090670Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BUTT SPLICE CRACKED AT BS 258, WL 179 LT SIDE. REPAIRED SKIN PER ER.SDR SWAA090669Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BUTT SPLICE CRACKED AT BS 258, WL 180 LT SIDE. REPAIRED SKIN PER ER.SDR SWAA090668Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BUTT SPLICE CRACKED AT BS 258, WL 184 LT SIDE. REPAIRED SKIN PER ER.SDR SWAA090667Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BUTT SPLICE CRACKED AT BS 258, WL 186 LT SIDE. REPAIRED SKIN PER ER.SDR SWAA090607Crease Beam · crackedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 360 TO BS 380, STR 17R. REMOVED AND REPLACED WEB PER SRM.SDR SWAA090605Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING NR 2 SLAT WEDGE I/B END DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA090606Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 616 TO BS 639. REPAIRED WEB PER SRM.SDR SWAA090604Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 616 TO BS 639. REPAIRED WEB PER SRM.SDR SWAA090603Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727, RBL 45. REPAIRED BEAM PER ER.SDR SWAA090602Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 305, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA090601Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA090600Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 13L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA090599Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM UPPER FLANGE CRACKED AT BS 328, RBL 28. REPAIRED BEAM PER SRM.SDR SWAA090598Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND ZEE CHORD UPPER FLANGE CORRODED AT BS 270 BETWEEN LBL 7 TO RBL 7. REPAIRED CHORD PER SRM.SDR SWAA090577Bracket · corrodedDURING SCHEDULED 20Y CHECK, FOUND ESCAPE SLIDE FLOOR BRACKET CORRODED AT BS 344, LBL 58, WL 208. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA090482Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090455Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090311Skin · puncturedDURING SCHEDULED 20Y CHECK, FOUND LT WING INBD MID-FLAP T/E WEDGE SKIN PUNCTURED. REPAIRED MID FLAP PER SRM.SDR SWAA090289Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 12L. R&R CLIP PER SRM.SDR SWAA090174Wedge · debondedDURING SCHEDULED 20Y CHECK, FOUND RT WING INBD MID FLAP T/E WEDGE DISBONDED. REPAIRED WEDGE PER SRM.SDR SWAA090113Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 727, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090112Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090111Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA090110Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA090109Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.
Back to N343SW, cancelled Oct 27, 2017