N348SW, cancelled Jul 16, 2012
Service difficulty reports · 282
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 = 'N348SW' AND deregistration_id = 'N348SW-2012-07-16' 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 = 'N348SW' AND deregistration_id = 'N348SW-2012-07-16' 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 SWAA105821Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 277, BETWEEN STR 15R TO STR 16R. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA105820Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 294.5, LBL 54. REPAIRED BEAM PER SRM.SDR SWAA105819Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 712, BBL 0.0. REPAIRED BEAM PER SRM.SDR SWAA105818Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, LBL 49. REPAIRED BEAM PER SRM.SDR SWAA105817Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, LBL 27. REPAIRED BEAM PER SRM.SDR SWAA105816Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 967, LBL 5. REPAIRED BEAM PER SRM.SDR SWAA105815Web · crackedDURING SCHEDULED 22Y CHECK, FOUND SUPPORT STRUCTURE WEB CRACKED BETWEEN BS 294.5 TO BS 305.5, STR 7L. REMOVED AND REPLACED WEB PER BAC DWG.SDR SWAA105814Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 4R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105813Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105812Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 9L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105811Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 4L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105810Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 3L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105809Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 6L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105808Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 4L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105807Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 4R. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105806Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105805Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 23L. REMOVED AND REPLACED CLIP PER SRM AND BAC DWG.SDR SWAA105690Lens · brokenDURING SCHEDULED 22Y CHECK, FOUND R1 DOOR OVERHEAD EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA105016Slide · out of limitsDURING SCHEDULED MV1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA103284Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 377, STR 15L. REPAIRED SKIN PER EA.SDR SWAA103283Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 922, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA103282Light · wornDURING SCHEDULED 2HC1 CHECK, FOUND RT EEPLS WORN AT ROW 8. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA102797Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 923, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA101483Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND FWD EEPLS LAMPS INOP NEAR FWD DOORS. RELAMPED PER MM.SDR SWAA100571Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA100570Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA100514Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 740E, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA100513Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN AT BS 328, BETWEEN STR 19R TO STR 20R. REPAIRED SKIN PER SRM.SDR SWAA100512Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA097560Slat · delaminatedDURING SCHEDULED SPV CHECK, FOUND RT WING NR 5 L/E SLAT O/B TRAILING EDGE DELAMINATED. REMOVED AND REPLACED SLAT PER SRM.SDR SWAA097559Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND R1 DOOR LOWER FRAME WEB CRACKED. REMOVED AND REPLACED DOOR PER SRM.SDR SWAA097549Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND R1 DOOR LOWER CUTOUT FRAME WEB CRACKED. REPAIRED FRAME PER SRM.SDR SWAA097486Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 271, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA097485Fitting · crackedDURING SCHEDULED HC2 CHECK, FOUND RT WING I/B GROUND SPOILER I/B ACTUATOR MOUNT HOUSING CRACKED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA097059Lug · corrodedDURING SCHEDULED 20Y CHECK, FOUND VERTICAL STABILIZER LT AND RT FAIL-SAFE FWD LUG CORRODED. REPAIRED LUG PER EA.SDR SWAA093436Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 923, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA092290Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND EXTERNAL EMERGENCY LIGHT AFT OF I/B AFT LT FLAP INOP. RELAMPED PER MM.SDR SWAA086346Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND LOWER CHORD CORRODED AT BS 227, BETWEEN BL 0 TO RBL 5. REPAIRED CHORD PER SWA EA.SDR SWAA086162Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND VERTICAL STABILIZER RT O/B FWD LUG FITTING CORRODED. REPAIRED FITTING PER SWA EA.SDR SWAA086163Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND VERTICAL STABILIZER LT O/B FWD LUG FITTING CORRODED. REPAIRED FITTING PER SWA EA.SDR SWAA086085Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT FWD CARGO KEEL BEAM CORRODED AT BS 524. REPAIRED KEEL BEAM PER SRM.SDR SWAA086066Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND VERTICAL STABILIZER LT OUTBOARD REAR LUG FITTING CORRODED. REPAIRED FITTING PER EA.SDR SWAA086027Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE STRINGER ANGLE CRACKED AT BS 301, STR 10L. REPAIRED ANGLE PER SRM.SDR SWAA086026Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN AT L1 DOOR UPPER HINGE CUTOUT CRACKED. REPAIRED SKIN PER EA.SDR SWAA086025Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN AT L1 DOOR LOWER HINGE CUTOUT CRACKED. REPAIRED SKIN PER EA.SDR SWAA086021Stringer · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CRACKED AT BS 788, STR 16R. REPAIRED STRINGER PER SRM.SDR SWAA085990Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085989Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 28L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085988Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 28L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085910Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 27L. REMOVED AND REPLACED CLIP PER SRM.
Back to N348SW, cancelled Jul 16, 2012