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 SWAA060621Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 597, STR 13L. REPAIRED SHEAR TIE PER SWA EA.SDR SWAA060620Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 579, STR 13L. REPAIRED SHEAR TIE PER SWA EA.SDR SWAA060619Beltframe · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 500D, STR 19R. REPAIRED BELTFRAME PER SWA EA.SDR SWAA060613Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA060612Stringer · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 365, STR 27L. REPAIRED STRINGER PER SRM.SDR SWAA060611Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 927, BL 0. REPAIRED FLOORBEAM PER SRM.SDR SWAA060610Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 753 TO BS 764, STR 19L TO STR 20L. REPAIRED SKIN PER SWA EA.SDR SWAA060609Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT CARGO DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA060608Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR CUTOUT, FWD LOWER CORNER. REPAIRED SKIN PER SWA EA.SDR SWAA060607Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA060606Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 751, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA060605Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 732E TO BS 741E, STR 22L TO STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA060571Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FLOOR BRACKET CORRODED. REMOVED AND REPLACED FWD BRACKET PER SRM.SDR SWAA060570Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 764 TO BS 765, STR 19L. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA060537Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND LEFT WING NR 2 L/E SLAT LOWER T/E SKIN CRACKED AT OUTBOARD END. REPAIRED SLAT PER SRM.SDR SWAA060403Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 793, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA060402Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 372, STR 8L. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA060119Outflow Valve · faultyAIR TURNBACK, CABIN ALTITUDE HORN SOUNDED. REMOVED AND REPLACED CABIN PRESSURE CONTROLLER AND MAIN OUTFLOW VALVE PER MM. RESECURED AFT CARGO DOOR SEAL PER MM.SDR SWAA054052Fan · faultySMOKE ODOR IN CABIN. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA053864Line · looseFUMES SMELL IN FWD GALLEY. FOUND HYDRAULIC FLUID LEAK AT LINE FWD OF RT AIR CYCLE MACHINE. TIGHTENED HYDRAULIC LINE PER MM.SDR SWAA053815Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 941, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA053269Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LT AFT CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA053213Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA053212Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA053211Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA053210Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA052863Lens · brokenDURING SCHEDULED SERVICE CHECK, FOUND LT OVERWING EMERGENCY EXIT SIDEWALL LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA051957Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA050925Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 980, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA050924Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 777, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA050923Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 23R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA050922Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 19L. REPAIRED SKIN PER SWA EA.SDR SWAA050921Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 740, STR 23L. REPAIRED SKIN PER SWA EA.SDR SWAA050920Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 515, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA050919Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747 + 2, STR 24R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA050437Skin · crackedDURING SCHEDULED A1 CHECK, FOUND 3 EACH FUSELAGE SKIN CRACKS AT BS 727E, STRINGER 23L AND STRINGER 19R, BS 867, STRINGER 24R. REPAIRED SKIN PER EA.SDR SWAA043641Skin · delaminatedDURING SCHEDULED C3 CHECK, FOUND RT WING INBOARD T/E FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA043580Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 940, STRINGER 21L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043579Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 727 + 10, BELOW STRINGER 22L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043578Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 751, BELOW STRINGER 19R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041495Frame · crackedDURING SPV, FOUND FRAME AND FRAME WEB AT BS 639, STRINGER 17R, CRACKED. REPAIRED FRAME AND FRAME WEB PER ER.SDR SWAA041422Light · looseDURING SPV, FOUND BULLNOSE EMERGENCY EXIT LIGHT AT ROW 10 DEF, LOOSE. SECURED BULLNOSE LIGHT PER MM.SDR SWAA041421Shear Tie · crackedDURING SPV, FOUND SHEAR TIE AT BS 500C, STRINGER 16R, CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA041420Stringer · crackedDURING SPV, FOUND STRINGER 20L AT BS 727D + 4, CRACKED. REPAIRED STRINGER SECTION PER SRM.SDR SWAA041419Stringer Clip · crackedDURING SPV, FOUND STRINGER CLIPS AT BS 500C AND BS 500D, STRINGER 9L, CRACKED. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA041418Buttstrap · crackedDURING SPV, FOUND BUTT STRAP AT BS 360, STRINGER 14L, CRACKED. REPAIRED STRAP PER SRM.SDR SWAA041417Shear Tie · crackedDURING SPV, FOUND SHEAR TIES AT BS 360, BELOW AND ABOVE STRINGER 14L, CRACKED. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR SWAA041394Shear Tie · crackedDURING SPV, FOUND SHEAR TIE AT BS 360, STRINGER 14R, CRACKED. REPAIRED SHEAR TIE PER SRM.SDR SWAA041393Splice · crackedDURING SPV, FOUND STRINGER SPLICES AT BS 908, STRINGER 4R AND STRINGER 4L, CRACKED. REMOVED AND REPLACED STRINGER SPLICES PER SRM.SDR SWAA041392Stringer · crackedDURING SPV, FOUND STRINGER 4R AT BS 639, CRACKED. REPAIRED STRINGER PER SRM.
Back to N672SW, cancelled Dec 22, 2014