N658SW, cancelled Mar 15, 2018
Service difficulty reports · 512
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 = 'N658SW' AND deregistration_id = 'N658SW-2018-03-15' 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 = 'N658SW' AND deregistration_id = 'N658SW-2018-03-15' 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 SWAA100915Battery Pack · dischargedDURING SCHEDULED MV4 CHECK, FOUND LT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHTS INOP BETWEEN ROW 2 TO ROW 3. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA096356Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA096355Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA2013062517539Skin · crackedFUSELAGE SKIN CRACKED AT AFT SERVICE DOOR LOWER HINGE CUTOUT LOWER CORNER. REPAIRED SKIN IAW SRM.SDR SWAA2013062517538Skin · crackedFUSELAGE SKIN CRACKED AT AFT ENTRY DOOR LOWER HINGE CUTOUT LOWER CORNER. REPAIRED SKIN IAW SRM & EA.SDR SWAA096369Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA096343ASkin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA096186Slide · out of positionDURING SCHEDULED HC2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA096190Light · looseDURING SCHEDULED 2HC2 CHECK, FOUND RT EEPLS LOOSE AT ROW 1. SECURED EEPLS PER MM.SDR SWAA095954Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA095619Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND TWO FWD EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA095403Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA095320Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA094188Stringer · corrodedDURING SCHEDULED SPV, FOUND STRINGER CORRODED AT BS 510B, STR 21R. REPAIRED STR PER SRM.SDR SWAA094176Stringer · corrodedDURING SCHEDULED SPV, FOUND STRINGER CORRODED AT BS 510B, STR 21R. REPAIRED STR PER SRM.SDR SWAA094151Frame · crackedDURING SCHEDULED SPV, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 20L TO STR 21L. REPAIRED FRAME PER EA AND SRM.SDR SWAA094150Frame · crackedDURING SCHEDULED SPV, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20L TO STR 21L. REPAIRED FRAME PER EA AND SRM.SDR SWAA094149Frame · crackedDURING SCHEDULED SPV, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 20R TO STR 21R. REPAIRED FRAME PER EA AND SRM.SDR SWAA094148Frame · crackedDURING SCHEDULED SPV, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20R TO STR 21R. REPAIRED FRAME PER EA AND SRM.SDR SWAA094147Keelbeam · corrodedDURING SCHEDULED SPV, FOUND RT KEEL BEAM CORRODED AT BS 643. REMOVED AND REPLACED KEEL BEAM SECTION PER SRM.SDR SWAA094102Skin · crackedDURING SCHEDULED SPV, FOUND FUSELAGE SKIN CRACKED AT LOWER RADIO ALTIMETER ANTENNA CUTOUT, BS 406 TO BS 434, RBL 4 TO BL 0. REPAIRED SKIN PER ER.SDR SWAA094101Skin · crackedDURING SCHEDULED SPV, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT, BS 304, WL 238. REPAIRED SKIN PER ER.SDR SWAA094122Skin · crackedDURING SCHEDULED SPV, FOUND L1 DOOR UPPER HINGE CUTOUT SKIN CRACKED AT BS 301-304, WL 227-261. REPAIRED SKIN PER SWRM & ER.SDR SWAA094121Stringer · corrodedDURING SCHEDULED SPV, FOUND STRINGER CORRODED AT BS 500C, STR 21L. REPAIRED STRINGER PER SRM.SDR SWAA094056Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 530, STR 25R. REPAIRED STRINGER PER SRM.SDR SWAA094055Keelbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND LT KEEL BEAM CORRODED BETWEEN BS 500D TO BS 540. REPAIRED BEAM PER ER.SDR SWAA094046Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 1013, STR 26L. REPAIRED STRINGER PER SRM.SDR SWAA094045Keelbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND LT KEEL BEAM CORRODED AT BS 500D, STR 28L. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA093906Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 500C, STR 20L. REPAIRED STRINGER PER SRM.SDR SWAA093878Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA093830Keelbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND LT KEEL BEAM CORRODED AT BS 675. REMOVED AND REPLACED BEAM PER BAC DWG.SDR SWAA093729Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 500C, STR 24R. REPAIRED STRINGER PER SWA EA.SDR SWAA093728Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SWA EA.SDR SWAA093727Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 485, STR 9L. REPAIRED STRINGER PER SWA EA.SDR SWAA093726Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 907, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA093669Lens · debondedDURING SCHEDULED SPV CHECK, FOUND AFT EMERGENCY EXIT SIGN LENS DISBONDED. REPAIRED LENS PER MM.SDR SWAA093670Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 663, STR 3L. REPAIRED FRAME PER ER.SDR SWAA093671Sill · corrodedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOORWAY LOWER SILL CHORD CORRODED BETWEEN BS 794 TO BS 847, BETWEEN STR 24R TO STR 25R. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA093622Connector · corrodedDURING SCHEDULED SPV CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT WIRE CONNECTOR CORRODED AT BS 735D, BETWEEN STR 22R TO STR 23R. REMOVED AND REPLACED CONNECTOR AND WIRING PER WDM.SDR SWAA093621Connector · corrodedDURING SCHEDULED SPV CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT WIRE CONNECTOR CORRODED AT BS 735D, BETWEEN STR 22L TO STR 23L. REMOVED AND REPLACED CONNECTOR AND WIRING PER WDM.SDR SWAA093598Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 409, STR 23R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA093599Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 515B, STR 23L. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA093615Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 660, BL 0. REPAIRED BEAM PER SRM.SDR SWAA093617Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 732A, STR 14R. REPAIRED SKIN PER ER.SDR SWAA093614Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM CORRODED AT BS 790, STR 17R. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA093616Stringer Splice · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CORRODED AT BS 908, STR 25L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA093500Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 515B, STR 22L. REPAIRED STRINGER PER ER.SDR SWAA093426Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 400, BETWEEN STR 15R TO STR 16R. REPAIRED SHEAR TIE PER SRM.SDR SWAA093427Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 597, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SRM.SDR SWAA093446Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 729A, STR 14R. REPAIRED SKIN PER ER.
Back to N658SW, cancelled Mar 15, 2018