N330SW, cancelled Apr 23, 2012
Service difficulty reports · 208
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 = 'N330SW' AND deregistration_id = 'N330SW-2012-04-23' 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 = 'N330SW' AND deregistration_id = 'N330SW-2012-04-23' 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 SWAA073373Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16R. REPAIRED FRAME PER SRM.SDR SWAA073374Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 662, LBL 0.07. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA073344Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073345Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA073346Skin · corrodedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 808, BL 0. REPAIRED SKIN PER SRM.SDR SWAA073073Lamp · inoperativeDURING SCHEDULED A1 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA073039Lamp · inoperativeDURING SCHEDULED 14Y CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA073040Lamp · inoperativeDURING SCHEDULED 14Y CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA073011Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA071897Flap · delaminatedDURING SCHEDULED C3 CHECK, FOUND LEFT WING INBOARD T/E AFT FLAP DELAMINATED AT INBOARD T/E. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA071820Light · brokenDURING SCHEDULED SERVICE CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT BROKEN AT ROW 11 ABC. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA071814Skin · crackedFUSELAGE SKIN CRACKED AT BS 765, STR 20L. REPAIRED SKIN PER SWA EA.SDR SWAA071464Slide · dislodgedR2 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA070088Frame · crackedDURING SCHEDULED C2 CHECK, FOUND AFT CARGO DOOR AFT FRAME CRACKED AT NR 5 STOP FITTING. REMOVED AND REPLACED AFT CARGO DOOR PER SWA EA.SDR SWAA070087Glowstrip · wornDURING SCHEDULED C2 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT ROW 1 DEF. REMOVED AND REPLACED STRIP PER MM.SDR SWAA070086Frame · crackedDURING SCHEDULED C2 CHECK, FOUND R1 DOOR LOWER FRAME CRACKED BELOW LOWER CAM. REMOVED AND REPLACED R1 DOOR PER MM.SDR SWAA070085Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA070084Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 514D, STR 15L. REPAIRED SKIN SECTION PER SWA EA.SDR SWAA065076Light · inoperativeDURING SCHEDULED A1 CHECK, FOUND L1 DOOR LOWER EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA063568Bearing · wornDURING SCHEDULED C1 CHECK, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR NR 1 TAB HINGE BEARING PER MM.SDR SWAA063567Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA063566Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA062904Lamp · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND LOWER EMERGENCY EXIT LIGHT INOP AT R1 DOOR. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA062587Wire · brokenDURING SCHEDULED SERVICE CHECK, FOUND RT OVERWING EMEREGENCY EXIT LIGHT INOP. SPLICED BROKEN WIRE PER MM.SDR SWAA062009Skin · corrodedDURING SCHEDULED PM CHECK, FOUND RIGHT HORIZONTAL STAB UPPER SKIN CORRODED. REMOVED AND REPLACED RIGHT HORIZONTAL STAB PER MM.SDR SWAA061975Attach Fitting · brokenDURING SCHEDULED C4 CHECK, FOUND LT WING NR 4 GROUND SPOILER OUTBOARD ATTACH LUG BROKEN. REMOVED AND REPLACED NR 4 SPOILER PER MM.SDR SWAA061473Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT FWD CARGO DOOR CUTOUT BS 492, NR 5 STOP PAD. REMOVED AND REPLACED FRAME SECTION PER ER AND SB.SDR SWAA061472Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT AFT CARGO DOOR CUTOUT BS 847, NR 1 LOWER DOOR STOP. REMOVED AND REPLACED WEB PER ER.SDR SWAA061257Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 741D TO BS 750, STR 18R TO STR 19R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA061256Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 743E TO BS 744E, STR 19L TO STR 20L. REPAIRED SKIN PER SRM.SDR SWAA060071Slide · low pressureR1 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATING LOW. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA053537Light · looseDURING SCHEDULED C2 CHECK, FOUND EEPLS STRIP LOOSE BETWEEN ROW 8 TO ROW 10. REMOVED AND REPLACED STRIP PER MM.SDR SWAA053228Circuit Card · faultyRED UNSAFE LT MLG LIGHT REMAINED ILLUMINATED AFTER GEAR RETRACTION. RECYCLED GEAR HANDLE AND RED UNSAFE LIGHT EXTINGUISHED. REMOVED AND REPLACED MLG RED LIGHT SWITCH PC CARD M986 PER MM.SDR SWAA052883Light · looseEEPLS STRIP LOOSE AT ROW 10. SECURED STRIP PER MM.SDR SWAA052744Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA052586Battery Pack · inoperativeDURING SCHEDULED RON CHECK, FOUND FWD GALLEY EXIT SIGN INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA052275Battery Pack · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY INTERIOR & EXTERIOR LIGHTS INOP AT BOTH ENTRY DOORS. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA052205Light · looseRIGHT OVERWING EMERGENCY EXIT DOOR LIGHT LOOSE. SECURED LIGHT ASSY PER MM.SDR SWAA052226Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKS BETWEEN BS 727E + 3 AND BS 747, STR 19R. REPAIRED SKIN PER SWA EA AND SRM.SDR SWAA051649Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA051078Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA051077Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 787, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA051076Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 500 D, STR 15R. REPAIRED SKIN PER SWA EA.SDR SWAA051075Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 312, STR 18R. REPAIRED SKIN PER SRM.SDR SWAA051063Lens · looseDURING SCHEDULED C4 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA050042Shear Tie · damagedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 747, RBL 6 TO LBL 6, DAMAGED. REMOVED AND REPLACED SHEAR TIE SECTION PER SRM.SDR SWAA050026Battery · dischargedDURING SCHEDULED 1/4D CHECK, FOUND EMERGENCY EXIT LIGHT AT BS 673, LOW CHARGE. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA050018Bulkhead · crackedDURING SCHEDULED 1/4D CHECK, FOUND 3 EACH CRACKS AT PANEL NR 7 AND ONE EACH CRACK AT PANEL NR 2, ON BULKHEAD WEB AT BS 1016. REPAIRED BULKHEAD WEB PER EA.SDR SWAA050010Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN AT BS 500C + 6, ABOVE STRINGER 15R, CRACKED. REPAIRED SKIN PER EA.SDR SWAA043725Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND AFT CARGO COMPT FRAME SHEAR TIE CORRODED AT BS 747, RBL 7 TO RBL 13. REPAIRED SHEAR TIE PER SRM.
Back to N330SW, cancelled Apr 23, 2012