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 SWAA043323Lens · crackedDURING SCHEDULED C2 CHECK, FOUND SIDEWALL EMERGENCY EXIT LIGHT LENS AT ROW 11 ABC, CRACKED. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA043322Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN AT BS 937, STRINGER 14L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA043161Duct · restrictedEQUIPMENT COOLING LIGHT ILLUMINATED. AUTOPILOT SYS DISCONNECTED AND FUMES ENTERED COCKPIT. FOUND INSTRUMENT COOLING AIRFLOW TO CAPT'S & F/O'S INSTRUMENT PANELS RESTRICTED. CLEANED DISTRIBUTION DUCT AND OPS CK GOOD PER MM.SDR SWAA042121Fitting · looseDURING SCHEDULED 1/4D CHECK, FOUND L2 DOOR EVAC SLIDE FWD GIRT BAR FLOOR FITTING LOOSE. SECURED L2 DOOR EVAC SLIDE FITTING PER MM.SDR SWAA042120Floorbeam · crackedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 663, BL 0, CRACKED. REPAIRED FLOORBEAM PER EA.SDR SWAA042103Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND FLOORBEAM AT BS 500D, RBL 13, CORRODED. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR SWAA041912Bushing · wornDURING SCHEDULED C1 CHECK, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 ELEVATOR TAB HINGE BUSHING AND HARDWARE PER MM.SDR SWAA041650Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 961, STRINGER 21L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041467Skin · crackedDURING SCHEDULED PM CHECK, FOUND FUSELAGE SKIN AT BS 740, STRINGER 18L, BS 792, STRINGER 19L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041220Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 727E + 16, STRINGER 19L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040987Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 275, BETWEEN STRINGERS 15L AND 16L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040982Flap · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP DELAMINATED. REMOVED AND REPLACED LT WING OUTBOARD T/E AFT FLAP PER MM.SDR SWAA032031Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT OUTBD TE FORE FLAP DELAMINATED AT T/E. REMOVED AND REPLACED LT OUTBD T/E FORE FLAP PER MM.SDR SWAA032020Girt Bar · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA032034Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT ENTRY DOOR CUTOUT LOWER FWD CORNER. REPAIRED SKIN PER SRM.SDR SWAA032030Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT INBOARD AFT T/E FLAP DELAMINATED AT LOWER INBD CORNER. REMOVED AND REPLACED LT INBD AFT T/E FLAP PER MM.SDR SWAA031964Slide · deployedDURING SCHEDULED SERVICE CHECK, FWD SVC DOOR EMERGENCY EVAC SLIDE DEPLOYED. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031512Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 807, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA031271Bulkhead · crackedDURING SCHEDULED C1 CHECK, FOUND BS 1016 BULKHEAD CRACKED AT STR 7L. REPAIRED BULKHEAD PER SRM.SDR SWAA030360Bushing · wornDURING SCHEDULED C4 CHECK, SWA SI 11139-55, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED RT ELEVATOR TAB MAST HARDWARE AND BUSHING AND NR 1 TAB HINGE BUSHING PER MM.SDR SWAA030266Stringer · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER 5R CRACKED AT BS 827+12. REPAIRED STRINGER PER SRMSDR SWAA030265Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 2 EA STRINGER CLIPS CRACKED, BS 616, STR 5L AND BS 727A, STR 4L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA030264Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 5L. REPAIRED STRINGER SPLICE PER SRM.SDR SWAA030263Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR 14L AND STR 15L. REPAIRED SHEAR TIE PER SRM.SDR SWAA030259Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER SPLICES CRACKED (3 EA) AT BS 360 AT STR 4L, BS 908 AT STR 4L AND BS 908 AT STR 4R. REMOVED AND REPLACED STRINGER SPLICES PER SRM.SDR SWAA030258Tie Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND TIE CLIPS CRACKED (2 EA) AT STR 4L, BS 727B AND BS 807. REMOVED AND REPLACED TIE CLIPS PER SRM.SDR SWAA030072Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 2 EA STRINGER CLIPS CRACKED, BS 727B, STR 4L AND BS 847, STR 4R. REMOVED AND REPLACED BOTH STRINGER CLIPS PER SRM.SDR SWAA022801Battery · dischargedDURING SCHEDULED SPECIAL VISIT, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA022039Skin · crackedDURING WALK AROUND INSPECTION, FOUND FUSELAGE SKIN CRACKED AT BS 947.5, STR 26R. REPAIRED SKIN PER SRM.SDR SWAA021599Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND RT OTBD OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA021385Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 510, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA021379Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND FWD SVC DOOR EMERGENCY EVAC SLIDE GIRT ASSY OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA020206Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED .1 INCHES LONG AT POINT C ON LT C-D WINDOW POST. REPAIRED SKIN PER SRM.SDR SWAA020205Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED .25 INCHES LONG AT POINT C ON RT C-D WINDOW POST. REPAIRED SKIN PER SRM.SDR SWAA020189Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAMECRACKED, BS 639, STRINGER 15R. REPAIRED FRAME PER SWA RA.SDR SWAA020188Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED, BS 559, STRINGER 14L. REPAIRED FRAME PER SWA RA.SDR SWAA020152Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA020146Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME INNER CHORD CRACKED AT BS 559, STR 14R. REPAIRED FRAME CHORD PER SWA RA.SDR SWAA020118Flap · delaminatedDURING SCHEDULED 1/2 D CHECK, FOUND LT OUTBD T/E AFT FLAP DELAMINATED AT AFT EDGE CENTER. REMOVED AND REPLACED AFT T/E OTBD FLAP PER MM.SDR SWAA020117Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY DOOR EMERGENCY EVAC SLIDE FLOOR GIRT BAR BRACKETS (FWD AND AFT) CORRODED. REMOVED AND REPLACED BOTH BRACKETS PER SRM & MM.SDR SWAA020111Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR FRAME CRACKED AT AFT LOWER CORNER. REPAIRED DOOR FRAME PER SRM.SDR SWAA020110Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED STRINGER TIE CLIP PER SRM.SDR SWAA020106Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 26R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA020083Stiffener · crackedDURING SCHEDULED 1/2D CHECK, FOUND VERTICAL STIFFENER CRACKED AT BS 616 BELOW FLOOR LEVEL LT SIDE. REPAIRED STIFFENER PER SRM.SDR SWAA020092Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 773, STR 14L. REPAIRED SKIN PER SRM.SDR SWAA013115Light · looseDURING SCHEDULED C4 CHECK, FOUND EEPLS LOOSE AT BOTH FWD AND AFT CABIN. SECURED EEPLS PER MM.SDR SWAA012603Beam · wornDURING SCHEDULED A2 CHECK, FOUND LT MLG WALKING BEAM I/B BEARING MIGRATED 3/16. REMOVED AND REPLACED WALKING BEAM PER MM.SDR SWAA012282Light · inoperativeDURING SCHEDULED C3 CHECK, FOUND EEPLS INOP AT MID AND AFT CABIN. RELAMPED EEPLS PER MM.SDR SWAA012264Flap · delaminatedDURING SCHEDULED PM CHECK, FOUND RT T/E OUTBOARD AFT FLAP DELAMINATED ON INBOARD END, APPROX 11. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA012212Slide · looseAFT ENTRY DOOR EMERGENCY EVAC SLIDE ASSY LOOSE. SECURED AFT ENTRY EVAC SLIDE ASSY PER MM.
Back to N325SW, cancelled Mar 28, 2012