N325SW, cancelled Mar 28, 2012
Service difficulty reports · 344
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 = 'N325SW' AND deregistration_id = 'N325SW-2012-03-28' 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 = 'N325SW' AND deregistration_id = 'N325SW-2012-03-28' 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 SWAA071665Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071664Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071663Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071662Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071661Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA071610Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071630Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071629Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 2L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071628Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 2R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071627Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 1. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071634Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071635Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071632Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071633Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA071637Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 800, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA071631Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 583, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA071636Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 583, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA071601Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE BELLY SKIN CRACKED AT BS 413 TO BS 433, LBL 3 TO RBL 3. REPAIRED SKIN PER EA.SDR SWAA071567Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E+17, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA071541Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 303.9, STR 17L. REMOVED AND REPLACED FRAME WEB PER SRM.SDR SWAA071458Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 270, STR 15R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071457Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 26R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA071331Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 25R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA071330Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 344, LBL 10. REPAIRED FLOORBEAM PER SRM.SDR SWAA064519Shear Tie · corrodedDURING SCHEDULED C1 CHECK, FOUND SHEAR TIE CORRODED AT BS 967, BL 0. REPAIRED SHEAR TIE PER SRM.SDR SWAA064518Skin · corrodedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 967, STR 27L AND STR 27R. REPAIRED SKIN PER SWA EA.SDR SWAA064517Skin · corrodedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 947, STR 27L. REPAIRED SKIN PER SWA EA.SDR SWAA062854Skin · crackedDURING SCHEDULED C4 CHECK, FOUND L1 DOOR LOWER GATE SKIN CRACKED AT AFT LOWER CORNER. REPAIRED L1 DOOR PER MM.SDR SWAA062853Crank Assy · wornDURING SCHEDULED C4 CHECK, FOUND LT ELEVATOR TAB CONTROL MACHANISM WITH EXCESSIVE PLAY AT OUTBOARD TAB CONTROL ROD. REMOVED AND REPLACED TAB CRANK ASSY PER MM.SDR SWAA062852Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA062851Skin · crackedDURING SCHEDULED C4 CHECK, FOUND LT HORZONTAL STAB LOWER SKIN CRACKED AT STA 117. REPAIRED SKIN PER SRM.SDR SWAA061970Fire Detector · faultyAIR TURNBACK / DECLARED EMERGENCY. AFT CARGO COMPARTMENT FIRE WARNING LIGHT ILLUMINATED AND WARNING HORN SOUNDED. DEPLOYED FIRE EXTINGUISHER. REMOVED AND REPLACED AFT CARGO COMPARTMENT FIRE DETECTORS PER MM.SDR SWAA061924Fitting · crackedDURING SCHEDULED SERVICE CHECK, FOUND NLG ACTUATOR SUPPORT FITTING GUSSETT CRACKED IN RADIUS. REMOVED AND REPLACED GUSSETT FITTING PER SRM.SDR SWAA061648Wedge · crackedDURING SCHEDULED SPV CHECK, FOUND RT WING T/E MID FLAP T/E WEDGE CRACKED. REMOVED AND REPLACED T/E WEDGE PER MM AND SRM.SDR SWAA061621Bulb · inoperativeDURING SCHEDULED SPV CHECK, FOUND EMERGENCY EXIT LIGHTS INOP FROM ROW 2 TO ROW 5. RELAMPED LIGHTS PER MM.SDR SWAA061620Bulb · inoperativeDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA060478Light · looseMID CABIN EEPLS TRACK LOOSE. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA060227Flashlight · inoperativeFWD GALLEY OUTBOARD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA060157Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 511D, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA060182Skin · crackedDURING WALKAROUND INSP, FOUND FUSELAGE SKIN CRACKED AT BS 500C, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA054162Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 16L. REPAIRED SKIN PER SRM.SDR SWAA054161Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LATCH CABLE ASSY MISROUTED. REROUTED CABLE ASSY PER MM.SDR SWAA052806Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 934, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA052805Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 465 TO BS 485, STR 16R TO STR 17R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA052452Battery Pack · failedEMERGENCY EXIT INTERIOR & EXTERIOR LIGHTS FAILED TEST. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA052057Battery Pack · looseDURING SCHEDULED RON CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT ILLUMINATED WITH SWITCH IN ARMED POSITION. RESEATED CONNECTOR TO BATTERY PACK PER MM.SDR SWAA051673Bushing · wornDURING SCHEDULED C4 CHECK, LT ELEVATOR TAB FAILED THE FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR TAB NR 1 HINGE BUSHING & HARDWARE PER MM.SDR SWAA051147Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 968, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA051043Acm · malfunctionedAIR TURNBACK / DECLARED EMERGENCY. BURNING SMELL IN CABIN & COCKPIT. REMOVED AND REPLACED RT AIR CYCLE MACHINE PER MM.SDR SWAA050521Lamp · inoperativeDURING SCHEDULED C3 CHECK, FOUND L1 & R1 DOOR EMERGENCY EXIT SIGNS INOP. RELAMPED L1 & R1 EXIT SIGNS PER MM.
Back to N325SW, cancelled Mar 28, 2012