N365SW, cancelled May 11, 2016
Service difficulty reports · 325
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 = 'N365SW' AND deregistration_id = 'N365SW-2016-05-11' 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 = 'N365SW' AND deregistration_id = 'N365SW-2016-05-11' 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 SWAA116586Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND RT EMERGENCY EXIT LIGHT BATTERY PACK INOP BETWEEN ROW 8 TO ROW 10. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA114419Battery Pack · dischargedDURING SCHEDULED OTS CHECK, FOUND RT EXTERIOR EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA114363Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 947, STR 7L. REPAIRED SKIN PER ER AND EA.SDR SWAA113708Battery · dischargedDURING SCHEDULED MV2 CHECK FOUND, LT EEPLS INOP AT ROW 9. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA113707Battery Pack · dischargedDURING SCHEDULED MV2 CHECK FOUND, RT EEPLS INOP AT ROW 8. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA112619Flap · delaminatedDURING SCHEDULED MV2 CHECK, FOUND LT WING AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA106891Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA104332Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO FRAME CRACKED AT BS 500D, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER ER.SDR SWAA104331Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CRACKED AT BS 665, RBL 24.8. REPAIRED BEAM PER ER.SDR SWAA104330Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CRACKED AT BS 665, LBL 24.8. REPAIRED BEAM PER ER.SDR SWAA104329Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 847, STR 25L. REPAIRED SKIN PER ER.SDR SWAA104328Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 945, STR 25R. REPAIRED SKIN PER ER.SDR SWAA104104Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR LOWER AFT FRAME CRACKED BELOW LOWER AFT STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA104023Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 4L. REMOVED AND REPLACED CLIP PER SRM AND SI.SDR SWAA104022Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED CLIP PER SRM AND SI.SDR SWAA103994Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT WING NR 1 SLAT L/E LOWER SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA103873Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 440, BETWEEN STR 14R TO STR 15R. REPAIRED SKIN PER SRM.SDR SWAA103872Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND BULKHEAD UPPER CHORD CRACKED AT BS 178, LBL 24. REMOVED AND REPLACED CHORD PER SRM AND BAD DWG.SDR SWAA103871Web · crackedDURING SCHEDULED SPV CHECK, FOUND FLOOR WEB CRACKED BETWEEN BS 178 TO BS 188, BETWEEN RBL 25 TO RBL 29. REMOVED AND REPLACED WEB PER SRM AND BAC DWG.SDR SWAA103870Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA103869Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA103868Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA103867Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 867, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA103866Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 2L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA103548Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 727 TO BS 908, BETWEEN STR 20L TO STR 25L. REMOVED AND REPLACED SKIN PANEL PER SRM.SDR SWAA101841Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 503B, STR 10L. REPAIRED SKIN PER SRM.SDR SWAA101840Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA100450Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT OVERHEAD EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA097934Skin · delaminatedDURING SCHEDULED SPV CHECK, FOUND RT WING FORE FLAP I/B FLAP SKIN DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA096048Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 500C, STR 10L. REPAIRED SKIN PER EA.SDR SWAA096047Light · looseDURING SCHEDULED 2HC2 CHECK, FOUND RT EEPLS LOOSE AT ROW 1. SECURED EEPLS PER MM.SDR SWAA095211Boot · looseABORTED TAKEOFF, "AUTO FAIL" & "STANDBY" LIGHTS ON PRESSURIZATION PANEL ILLUMINATED AFTER TAKEOFF. AIRCRAFT WOULD NOT HOLD PRESSURIZATION PER QRH PROCEDURES. FOUND LOOSE PNEUMATIC BOOT ON AFT KEEL BEAM AND SEVERAL BODY DRAINS LEAKING. REPAIRED PER MT.SDR SWAA094601Flap · delaminatedDURING SCHEDULED SPV CHECK, FOUND RT WING O/B TRAILING EDGE FLAP DELAMINATED. REPAIRED FLAP PER MM.SDR SWAA094569Cover · looseFWD AISLE OVERHEAD EMERGENCY EXIT LIGHT COVER LOOSE. REMOVED AND REPLACED COVER PER MM.SDR SWAA093924Cover · looseLT OVERWING EMERGENCY EXIT SIGN LOOSE. REMOVED AND REPLACED COVER PER MM.SDR SWAA093866Lens · looseLEFT OVERWING EMERGENCY EXIT DOOR SIGN LENS LOOSE. SECURED LENS PER MM.SDR SWAA093565Sign · looseLT MID CABIN EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA092506Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 745, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA091717Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA085796Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 15L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085795Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA084537Battery Pack · dischargedDURING SCHEDULED 16Y CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER MM.SDR SWAA084536Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD ENTRY DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA084535Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD ENTRY DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA084487Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084486Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 21R. REPAIRED FRAME PER SRM.SDR SWAA084485Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA084484Floorbeam · corrodedDURING SCHEDULED HC2 CHECK, FOUND FLOORBEAM CORRODED AT BS 270, LBL 8 TO RBL 8. REPAIRED FLOORBEAM PER SRM.SDR SWAA084483Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKN CRACKED AT AIR CONDITIONING ACCESS DOOR BS 520. REPAIRED SKIN PER SWA EA.SDR SWAA084454Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20L. REPAIRED FRAME PER SRM.
Back to N365SW, cancelled May 11, 2016