N302SW, cancelled Sep 29, 2014
Service difficulty reports · 369
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 = 'N302SW' AND deregistration_id = 'N302SW-2014-09-29' 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 = 'N302SW' AND deregistration_id = 'N302SW-2014-09-29' 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 SWAA085429Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 19L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085428Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 24R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085427Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 867, STR 20R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085426Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 907, STR 22R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085425Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 927, STR 23R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085424Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 907, BETWEEN STR 27L TO 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA085423Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 927, BETWEEN STR 27L TO 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA085422Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085421Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085420Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085419Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085407Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 18L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085406Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 20R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085405Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500B, STR 20L. REPAIRED FRAME PER SRM.SDR SWAA085418Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO FRAME CORRODED AT BS 440, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA082755Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 912, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA082756Skin · delaminatedDURING SCHEDULED SPV CHECK, FOUND RT WING OUTBOARD T/E AFT FLAP DELAMINATED AT INBOARD END. REMOVED AND REPLACED FLAP PER MM.SDR SWAA081185Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081186Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA081187Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA080993Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA080656Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA075536Flashlight · inoperativeFWD CABIN EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA074638Lens · missingBULLNOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 23 ABC. INSTALLED LENS PER MM.SDR SWAA074294Actuator · faultyAIR TURNBACK. CLIMBING OUT OF TUS WITH LANDING GEAR HANDLE IN UP POSITION NLG UNSAFE LIGHT ILLUMINATED. CYCLED GEAR SEVERAL TIMES THEN GOT THREE GREEN LIGHTS. REMOVED AND REPLACED NLG RETRACT ACTUATOR AND FUSE PER MM.SDR SWAA074150Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER 26R CORRODED AT BS 867. REPAIRED STRINGER PER SRM.SDR SWAA074151Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 402, STR 5L. REPAIRED SKIN PER ER.SDR SWAA074126Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 1016, STR 20L. REPAIRED SKIN PER ER.SDR SWAA074120Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 410, BETWEEN RBL 3 AND LBL 3. REPAIRED SKIN PER ER.SDR SWAA073975Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 555, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA073954Stringer Splice · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CORRODED AT BS 360, STR 23L. REPAIRED STRINGER SPLICE PER SRM.SDR SWAA073947Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER 24R CORRODED AT BS 357. REPAIRED STRINGER PER SRM.SDR SWAA073946Stringer Splice · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CORRODED AT BS 360, STR 24R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA073906Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 420, STR 26R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073904Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727, STR 24L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073905Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727, STR 23L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073880Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 380, STR 13R. REPAIRED SHEAR TIE PER SRM.SDR SWAA073878Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA073879Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 582, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA073872Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER 26R CORRODED AT BS 360. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA073871Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA073870Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA073873Stringer Splice · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CORRODED AT BS 360, STR 22L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA073869Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA073721Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 847, STR 13R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA073674Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER 26R CORRODED BETWEEN BS 1006 AND BS 1016. REPAIRED STRINGER PER SRM.SDR SWAA073675Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER 15R CRACKED AT BS 380. REPAIRED STRINGER PER SRM.SDR SWAA073633Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073628Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA073629Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 6L. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to N302SW, cancelled Sep 29, 2014