N672SW, cancelled Dec 22, 2014
Service difficulty reports · 224
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 = 'N672SW' AND deregistration_id = 'N672SW-2014-12-22' 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 = 'N672SW' AND deregistration_id = 'N672SW-2014-12-22' 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 SWAA2012032602593Skin · damagedTHIS IS TO REPORT DAMAGE OF A SPARE FORE FLAP OFF RETIRED AIRCRAFT. LEFT WING O/B SPARE FORE FLAP LOWER SKIN PANEL DAMAGED. REPAIRED FORE FLAP PER EA.SDR SWAA084561Valve · faultyCABIN ALTITUDE HORN SOUNDED. PLACED PACKS ON HIGH RAN EMERGENCY DESCENT CHECKLIST. R&R HIGH STAGE VALVE PER MM.SDR SWAA084498Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 518D, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA084497Skin · crackedFUSELAGE SKIN CRACKED AT BS 700, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA084496Skin · crackedFUSELAGE SKIN CRACKED AT BS 583, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA082912Battery Pack · dischargedDURING SCHEDULED A1 CHECK, FWD CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA082911Battery Pack · dischargedDURING SCHEDULED A1 CHECK, MID CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA082909Battery Pack · inoperativeDURING SCHEDULED A1 CHECK, AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA082908Fitting · crackedDURING SCHEDULED A1 CHECK, FOUND LT WALKING BEAM ACTUATOR FITTING CRACKED AT AFT SPAR. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA082907Skin · crackedDURING SCHEDULED A1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 315, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA082365Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 1045, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA081253Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA081254Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 943, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA080753Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT OVERWING EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA073989Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 466, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA073966Skin · crackedDURING SCHEDULED HOU CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 466, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA073558Sign · dislodgedLEFT OVERWING EMERGENCY EXIT SIGN FELL OFF. SECURED SIGN PER MM.SDR SWAA073365Shear Tie · crackedDURING SCHEDULED MV2 CHECK, FOUND SHEAR TIE CRACKED AT BS 520, STR 16R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073364Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 516D, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA072570Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 24R. REPAIRED FRAME PER ACO.SDR SWAA072541Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 735E AND BS 747, STR 18R. REPAIRED SKIN PER SWA EA.SDR SWAA072106Light · inoperativeDURING SCHEDULED C3 CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA071551Skin · crackedFUSELAGE SKIN CRACKED AT BS 450, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA070602Cable · misroutedL2 DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA070207Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA064493Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 763, STR 19R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA064492Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 736D, STR 21L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA063713Charger · brokenDURING SCHEDULED C1 CHECK, FOUND EMERGENCY EXIT BATTERY CHARGER RECEPTICAL BROKEN AT OVERHEAD ROW 17. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA063145Hook · brokenR2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR HOOK BROKEN. REMOVED AND REPLACED EVAC SLIDE AFT GIRT BAR HOOK PER MM.SDR SWAA063060Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STR 21R. REPAIRED SKIN PER SWA EA.SDR SWAA063059Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 845, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA062043Actuator · shearedDURING SCHEDULED C4 CHECK, FOUND RT NR 5 GROUND SPOILER OUTBOARD ACTUATOR SHEARED. REMOVED AND REPLACED SPOILER ACTUATOR PER MM.SDR SWAA062042Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 816, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA062041Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 1012, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA061988Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA060727Stringer · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 598, STR 15L. REPAIRED STRINGER PER SRM.SDR SWAA060677Skin · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN BEAR STRAP CORRODED BETWEEN BS 1000 TO BS 1004, STR 27R. REPAIRED SKIN PER SWA EA.SDR SWAA060676Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 1006, STR 26R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA060667Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 500C, STR 24R. REPAIRED STRINGER PER SRM.SDR SWAA060666Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500D, LBL 5. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA060645Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727, STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA060644Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17L. REPAIRED FRAME PER SWA EA.SDR SWAA060643Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, STR 17L. REPAIRED FRAME PER SRM.SDR SWAA060642Frame · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 360, BL 0. REPAIRED FRAME PER SRM.SDR SWAA060641Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 727E, STR 14R. REPAIRED SHEAR TIE PER SWA EA.SDR SWAA060640Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 354, STR 16L. REPAIRED STRINGER PER SRM.SDR SWAA060639Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 365, STR 28L. REPAIRED STRINGER PER SRM.SDR SWAA060638Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 312, STR 26L. REPAIRED STRINGER PER SRM.SDR SWAA060637Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 500D, STR 18R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA060636Girt Bar · corrodedDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE GIRT BAR AFT FLOOR FITTING CORRODED. REMOVED AND REPLACED FLOOR FITTING PER SRM.
Back to N672SW, cancelled Dec 22, 2014