N312SW, cancelled Oct 31, 2011
Service difficulty reports · 320
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 = 'N312SW' AND deregistration_id = 'N312SW-2011-10-31' 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 = 'N312SW' AND deregistration_id = 'N312SW-2011-10-31' 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 SWAA095645Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 500A, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA095587Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MM.SDR SWAA094326Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 404, STR 26R. REPAIRED SKIN PER SWA EA.SDR SWAA094000Skin · crackedDURING SCHEDULED 2HC1 CHECK, SKIN CRACKED AT BS 495, STR 9L. REPAIRED SKIN PER SRM.SDR SWAA093999Skin · crackedDURING SCHEDULED 2HC1 CHECK, SKIN CRACKED AT BS 855, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA093998Light · looseDURING SCHEDULED 2HC1 CHECK, EEPLS LOOSE AT ROW 8. SECURED EEPLS PER MM.SDR SWAA093997Skin · crackedDURING SCHEDULED 2HC1 CHECK, SKIN CRACKED AT BS 947, STR 5R. REPAIRED SKIN PER SWA EA.SDR SWAA093996Skin · crackedDURING SCHEDULED 2HC1 CHECK, SKIN CRACKED AT BS 906, STR 3L. REPAIRED SKIN PER SWA EA.SDR SWAA093995Lens · looseBULLNOSE LIGHT LENS LOOSE AT ROW 2. SECURED LENS PER MM.SDR SWAA093353Keelbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LT KEEL BEAM CRACKED AT BS 713. REPAIRED BEAM PER SRM.SDR SWAA093340Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT KEEL BEAM SHEAR TIE CORRODED AT BS 500D. REPAIRED SHEAR TIE PER BAC DWG.SDR SWAA093339Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT KEEL BEAM CORRODED AT BS 500D. REPAIRED BEAM PER SRM.SDR SWAA093338Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND R/H KEEL BEAM CORRODED AT BS 533. REPAIRED BEAM PER SRM.SDR SWAA093337Stiffener · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT PRESSURE BULKHEAD STIFFENER CORRODED BETWEEN BS 1016 TO BS 1018 AT SIX O'CLOCK POSITION. R&R STIFFENER PER SRM.SDR SWAA093314Fuse · blownDURING SCHEDULED 24Y CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT INOP BETWEEN ROW 2 TO ROW 3. R&R POWER SUPPLY FUSE PER MM.SDR SWAA093313Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND L/H KEEL BEAM CHORD CORRODED AT BS 727, LBL 8. R&R BEAM PER SRM.SDR SWAA093304Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 559, STR 13R. REPAIRED FRAME PER AAR EA.SDR SWAA093294Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND R/H KEEL BEAM CORRODED BETWEEN BS 625 TO BS 741, STR 27R. R&R BEAM PER SRM.SDR SWAA093247Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, LBL 24.5. REPAIRED BEAM PER AAR EA.SDR SWAA093246Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER ACO.SDR SWAA093194Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 259.5, BETWEEN STR 20L TO STR 21L. REPAIRED SKIN PER SRM.SDR SWAA093161Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA093146Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 986, BETWEEN STR 19R TO STR 20R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA093145Fitting · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPT CRACKED SUPPORT BRACKET AT BS 727, RBL 25. REMOVED AND REPLACED T-FITTING PER SRM.SDR SWAA093110Lens · looseDURING SCHEDULED 24Y CHECK, FOUND AFT CABIN EMERGENCY EXIT SIGN LENS LOOSE AT BS 907. SECURED LENS PER MM.SDR SWAA093109Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM LOWER CHORD CRACKED AT BS 663, RBL 24. REPAIRED BEAM PER AAR EA.SDR SWAA093108Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 747, STR 25L. REPAIRED STRINGER PER SRM.SDR SWAA093078Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO COMPARTMENT SHEAR TIE CORRODED AT BS 500D. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA092885Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 13R. REPAIRED FRAME PER AAR EA.SDR SWAA092777Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER EA.SDR SWAA092776Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR SWAA092775Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND CENTER LONGITUDINAL FLOORBEAM CRACKED AT BS 707. REPAIRED BEAM PER SI.SDR SWAA092774Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092773Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092772Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092771Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092770Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092769Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500B, STR 16R. REPAIRED FRAME PER SRM.SDR SWAA092768Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 727E, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA092767Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092766Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500, BETWEEN STR 28R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA092730Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092649Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092648Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND RT WING NR 5 L/E SLAT LOWER SKIN CRACKED AT OUTBOARD END. REPAIRED SKIN PER SRM.SDR SWAA092589Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092567Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092566Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FRAME CRACKED AT BS 847, BETWEEN STR 1R TO STR 2R. REPAIRED FRAME PER SRM.SDR SWAA092530Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092456Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092455Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6R. REMOVED AND REPLACED CLIP PER SRM.
Back to N312SW, cancelled Oct 31, 2011