N316SW, cancelled Sep 10, 2012
Service difficulty reports · 452
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 = 'N316SW' AND deregistration_id = 'N316SW-2012-09-10' 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 = 'N316SW' AND deregistration_id = 'N316SW-2012-09-10' 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 SWAA094975Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 3R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094974Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 21L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094973Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094972Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094971Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094970Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094969Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094968Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 683, STR 1. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094967Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094966Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 18L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094924Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 597, STR 8L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA094923Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 683, STR 2R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094922Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094834Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093791Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 475, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA093790Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 752, STR 14R. REPAIRED SKIN PER SRM.SDR SWAA093789Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 731E, STR 14R. REPAIRED SKIN PER SRM.SDR SWAA093788Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 732B, STR 14R. REPAIRED SKIN PER SRM.SDR SWAA093787Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 727C, STR 14R. REPAIRED SKIN PER SRM.SDR SWAA090980Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 360, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA090979Light · inoperativeDURING SCHEDULED HC2 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT BULB INOP. RELAMPED PER MM.SDR SWAA090978Light · inoperativeDURING SCHEDULED HC2 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT BULB INOP. RELAMPED PER MM.SDR SWAA087400Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 291, BETWEEN STR 5R TO STR 19R. REPAIRED FRAME PER SRM.SDR SWAA087399Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA087398Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA087397Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA087396Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER AAR EA.SDR SWAA087395Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FWD FUSELAGE SKIN CRACKED AT CARGO DOOR CUTOUT, LOWER FWD CORNER. REPAIRED SKIN PER SRM.SDR SWAA087394Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 355 TO BS 357, STR 16R. REPAIRED SKIN PER AAR EA.SDR SWAA087239Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 348, STR 16R. REPAIRED STRINGER PER AAR EA.SDR SWAA087144Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 440, STR 16L. REPAIRED SKIN PER AAR EA.SDR SWAA087019Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 15L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086987Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 15L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086926Skin · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 911, BELOW STR 23R. REPAIRED SKIN PER SRM.SDR SWAA086877Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 28L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086876Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 28L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086875Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 15L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086874Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086873Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA086201Battery Pack · dischargedDURING SCHEDULED MV2 CHECK, FOUND FWD O/B FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA086092Battery Pack · dischargedDURING SCHEDULED CV CHECK, FOUND EMERGENCY EXIT BULLNOSE LIGHT INOP BETWEEN ROW 3 TO ROW 4. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA084267Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA083550Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 779, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA083069Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 484, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA082303Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 512D, STR 21R. REPAIRED SKIN PER SWA EA.SDR SWAA082300Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 373, STR 26L. REPAIRED SKIN PER SWA EA.SDR SWAA082302Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 505C, STR 17R. REPAIRED SKIN PER SWA EA.SDR SWAA082304Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 502D AND BS 514D, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA082301Skin · crackedDURING SCHEDULED CV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 443, STR 26L. REPAIRED SKIN PER SRM.SDR SWAA081165Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 505B, STR 15R. REPAIRED SKIN PER SWA EA.
Back to N316SW, cancelled Sep 10, 2012