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 SWAA102176Stringer Clip · brokenDURING SCHEDULED HC2 CHECK, FOUND STR CLIP BROKEN AT BS 767, STR 19R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102175Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 20R. REPAIRED SKIN PER SRM.SDR SWAA102174Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D+5, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA101899Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT SERVICE DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA101695Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND AFT ENTRY LOWER EMERGENCY EXIT LIGHTS INOP. RELAMPED PER MM.SDR SWAA101694Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND FWD SERVICE LOWER EMERGENCY EXIT LIGHTS INOP. RELAMPED PER MM.SDR SWAA100956Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND SKIN CRACKED AT BS 934, STR 22R. REPAIRED SKIN PER EA.SDR SWAA098037Slide · out of positionDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA097922Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA096546Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA096224Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 413, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA096223Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 385, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA096222Cover · looseDURING SCHEDULED HC1 CHECK, FOUND LT EEPLS COVER LOOSE AT ROW 7. SECURED COVER PER MM.SDR SWAA096221Light · looseDURING SCHEDULED HC1 CHECK, FOUND LT EEPLS LOOSE BETWEEN ROW 8 TO ROW 15. SECURED EEPLS PER MM.SDR SWAA094880Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA094645Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT AT LOWER FWD CORNER INOP. RELAMPED PER MM.SDR SWAA094333Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA094074Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500D, STR 11R TO STR 13R. REPAIRED SKIN PER SWA EA.SDR SWAA094073Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA093806Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 500C, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA092482Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND EMERGENCY EXIT LIGHT INOP AT ROW 15. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA092481Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND LT FWD NOSE WHEEL WELL SKIN CRACKED AT BETWEEN BS 239 TO BS 247. REPAIRED SKIN PER SWA EA.SDR SWAA092015Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 304, WL 261L. REPAIRED SKIN PER SWA EA.SDR SWAA091819Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 291, WL 233. REPAIRED SKIN PER SRM.SDR SWAA091818Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 24L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091774Aileron · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING AILERON DELAMINATED. REPAIRED AILERON PER SRM.SDR SWAA091773Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR, BETWEEN BS 303 TO BS 304, BETWEEN WL 233 TO WL 261. REPAIRED SKIN PER ER.SDR SWAA091772Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 440, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME PER SRM.SDR SWAA091771Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 727B TO BS 727C, LBL 65. REPAIRED WEB PER SRM.SDR SWAA091770Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 420 TO BS 500D, LBL 65. REPAIRED WEB PER SRM.SDR SWAA091769Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 380 TO BS 400, LBL 65. REPAIRED WEB PER SRM.SDR SWAA091768Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, BETWEEN BS 290 TO BS 291, WL 234.5. REPAIRED SKIN PER ER.SDR SWAA091767Rib · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT WING LOWER CHORD CRACKED AT BS 135.5, BETWEEN STR 2R TO STR 3R. REPAIRED CHORD PER ACO.SDR SWAA091766Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT KEEL BEAM CORRODED AT BS 510C. REPAIRED BEAM PER SRM.SDR SWAA091765Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT CREASE BEAM WEB CORRODED BETWEEN BS 500C TO BS 500D, LBL 65. REPAIRED BEAM PER SRM.SDR SWAA091764Crease Beam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT CREASE BEAM CORRODED BETWEEN BS 460 TO BS 480, LBL 65. REPAIRED BEAM PER SRM.SDR SWAA091763Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT KEEL BEAM CORRODED BETWEEN BS 500D TO BS 520, STR 28L. REPAIRED BEAM PER SRM.SDR SWAA091762Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, BETWEEN STR 28L TO STR 28R. REPAIRED SHEAR TIE PER SRM.SDR SWAA091761Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT FWD CARGO BAY, BS 492, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME PER SRM.SDR SWAA091760Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947, RBL 3. REPAIRED BEAM PER SRM.SDR SWAA091688Flap · crackedDURING SCHEDULED 20Y CHECK, FOUND RT WING O/B AFT FLAP CRACKED. REPAIRED AFT FLAP PER SRM.SDR SWAA091687Hook · looseDURING SCHEDULED 20Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR HOOK LOOSE. REMOVED AND REPLACED HOOK PER SRM.SDR SWAA091678Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING I/B AFT FLAP T/E WEDGE SKIN UPPER I/B CORNER DELAMINATED. REPAIRED SKIN PER SRM.SDR SWAA091677Rib · crackedDURING SCHEDULED 20Y CHECK, FOUND LT WING LOWER CHORD CRACKED AT BS 135, BETWEEN STR 2L TO STR 3L. REPAIRED CHORD PER ACO.SDR SWAA091663Support Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SUPPORT ANGLE CRACKED BETWEEN BS 292 TO BS 301, LBL 64. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA091662Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING I/B AFT FLAP T/E WEDGE LOWER I/B CORNER DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA091585Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING NR 1 SLAT O/B END UPPER T/E WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA091584Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING NR 5 SLAT T/E WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA091582Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 400, STR 8L. REPAIRED WEB PER SWA EA.SDR SWAA091540Skin · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING NR 2 SLAT I/B END UPPER T/E LOWER SURFACE DELAMINATED. REPAIRED SLAT PER SRM.
Back to N344SW, cancelled Oct 26, 2017